Handling Regional Number Formatting in Spanish-Speaking Countries

Hi Appian Community,

I'm currently developing a multi-regional application in Appian that will be used by Spanish-speaking users across different countries, including Spain, Mexico, and Colombia. While they all share the same language, I've noticed that number formatting conventions vary significantly between regions, especially in how thousands and decimal separators are used.

For example:

• In Spain: 123.456,78 (dot for thousands, comma for decimals)
• In Mexico: 123,456.78 (comma for thousands, dot for decimals)

 My question is:

Does Appian automatically distinguish between regional variants of the Spanish language (like es_ES vs es_MX) when applying number and date formats?
Or do we need to explicitly configure the full locale (e.g., es_MX instead of just es) for each user to ensure the correct regional formatting?

Additionally, has anyone implemented custom logic to handle formatting based on the user's country? What best practices would you recommend to maintain consistency and avoid misinterpretation?

Any insights, experiences, or documentation you can share would be greatly appreciated!