I am developping an app in Spanish locale. Here are the set of pre-requeriments I have checked boxed:
- The Spreadsheet is configured on the Spanish Locale (File -> Spreadsheet settings -> Locale -> Spain)
- A table Products contains a column named Price which is defined in the Appsheet side as Decimal, with 2 digital values
- The App interface device (Google Chrome) is configured with the proper locale settings (chrome://settings/languages --> Spanish as default)
When the App is executed from a Spanish flavored Chrome and a screen to create a New Product is opened, we will not be able to input “3,25” as the intended value for the field. IF we do, the entry will be considered as Invalid and the record will not be saved.
I will need to input “3.25” as the Price value in order for the record to be properly saved. Back to the Spreadsheet, the value will be perfectly visible as “3,25”. Back to the App, the value will be perfectly read as “3,25”. But once again, if I wish to modify the value to, say “3,50”, I will not be able to… unless I modify it to “3.50” instead
This issue is even more annoying when the app is opened directly inside the Appsheet app in a Spanish mobile phone, for as the digits input pad will not offer a “dot” character but only a “comma” character… So everytime we will wish to add or modify a Product Price we will need to click on the digits input pad extensor key (the “*+#” key) in order to access the alternative special characters, then locate the required “dot”, click on it, then click back the digits input pad key to return to the digits default pad (“123” key) then input the two intended digits, then Save the record.
I would love to discover that this issue is only a missing pre-requirement on my side instead of a bug. Praying for that to be the case.
Thanks in advance,