Looking for suggestions here as I'm not sure what the right solution is. I have been tasked with making a currency field handle any currency. Currently, I have field properties format category set up to display as:
This is usually fine as I have only needed to worry about USD. However, this needs to be able to handle any currency, but I have no idea what would work. A few ideas I had:
That's all that comes to mind at the moment, but I'm looking for any suggestions or examples (easier for me to follow because I'm still learning) that may exist (I haven't been able to find anything in my searches yet). There may be a more logical solution than what comes to mind, and I welcome any help. Thanks in advance.
I would go with either 2 or 3. However, 2 has a problem that the number formatting and currency symbol are not necessarily connected. For example, if someone in France uses a USD amount they might want it formatted in the way that is customary there, and not in the US, and vice versa. Also, some currencies could have multiple formats associated with them, depending on the location (Euro in Spain is not the same as Euro in France), etc.
The issue with approach 3 is that people can (and will make mistakes), but then it will be on them, not on you.
However, it will also mean you won't be able to use what they enter in other calculations, since you won't know for sure what format was used. Don't know if that's an issue for you...
Thank you for the response. I think I follow along with most everything. Attached is the exploration I have been working on, as well as notes beside each example that I'm hoping to solve. I see merit in each one, but realize none are perfect.
Appreciate any assistance/feedback here. Thank you everyone!