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?
Question
Question
Answer
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.
Changing the metadata field to a number and using the thousands separator now shows the comma on the template fields. Thank you!
I have a part two to this. I have a workflow that is taking those values to create a word document (via merge fields). The commas are not showing up there as well.
Since the formatting is only for display purposes, you have to change it where the data is displayed (so LF metadata or Word).
See https://support.microsoft.com/en-us/help/304387/date-phone-number-and-currency-fields-are-merged-incorrectly-when-you for more on how to format merge fields in Word.
Everything Worked like a charm. Thank you so much!!!!