Return to FileMaker.com
script to automatically add commas to pre-existing values in number field
Our accountant is having difficulty reading the amount in our value field (number field). Is there a way to automate this to pre-existing values?
Not every record would require this (example 300 or $300) but some would (example 30000 or $30,000).
The dollar symbol is not needed, just the comma.
Enter layout mode, select the field. Then use data formatting in the Inspector to specify the comma as a thousands separator.
Retrieving data ...