Currently I'm going field by field changing the currency symbol in the data formatting section of the inspector.
Is there a quicker way to do this? It would be great if we could specify a field or global in the currency field.
I had to take control of currency as I had a solution with invoices in various types of currency. This means not using the FM native currency tools. Using auto enter custom function was the best for me. Depending on your setup the fields stay as numbers and you just display the appropriate currency and decimals. Or you need to change the fields to text and this poses some issues with other calculations.
Yeah I'm in the same boat. I handled the bulk of the issue with custom functions, but I'm still in the position of an ~45 minutes of work every time I convert my main file to another region.
Your custom function should do this automatically for you. Just have one custom function that stores the formatting for all currencies and uses the one needed at the time.
Retrieving data ...