I have a (currency) field in forms that shows the comma if the currency value is large enough. When the form comes into the repository, the matching field (text) on the metadata template does not show the comma. Any ideas why?
Using a comma (thousands separator) on the form field is a property of the field itself, but doesn't affect the data. If someone puts 1500 in the form field, the field knows to add the , to show 1,500, but the data is still 1500. Since you are sending this to a metadata text field, it gets the 1500 and just displays that.
One option is to keep the metadata field as a text field, and build a regular expression mask that would insert a comma every after three characters. Or you could switch the metadata field to be a number field that has an option to show thousands separator.