i build an attachment of the invoices, in the App i see correct price (in my case € 1.700,00), but in attachment there is € 1,700.00. How can i resolve?
I inserted Type PRICE, Current Symbol € and in Table i set localize Italy.
I1.D account: 592176 2.CRMAumenta-592176 3.PREVENTIVI 4.TOTALE VENDITA/NOLEGGIO, or every prices cells.
All prices cells in the app appear € 1.000,00 or €10,00 in the attachment € 1,000.00 or €10.00
I have tried that after having made the change in localize and saved it, at the reopening it always appears english, i checked also all € symbol in prices cells and are correct
The prices are being displayed in “en-US” decimal format because your Google sheet locale and hence the table locale are “en-US”. You can confirm this for yourself by going to Data > Tables and checking the “Data locale” property for table “PREVENTIVI”.
AppSheet extracts the table Locale from the Google Sheet. You need to set the Locale for the Google sheet as described in topic “Configuring the Locale” in this article help.appsheet.com - Locale Support in AppSheet
When you next open your app, AppSheet will automatically detect that the Locale has changed and update your table appropriately. Locale Support in AppSheet help.appsheet.com