This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

Downloading CSV Files from other Countries

Posted on 12-05-2023 11:56 AM
Roland_Yambao
Bronze 1
Bronze 1
Reply posted on --/--/---- --:-- AM

I have an AppSheet app where the user downloads CSV files from the data on the app. The Download button's CSV file locale is English (United States), but the user is in Germany. When the user downloads the data, the DateTime columns are not always in the DateTime data type, sometimes they are text; when I download, I don't have this problem. When I make another button whose CSV file locale is English (Germany) and German (Germany), it completely ruins the CSV file, but the damage is not the same as if the German user downloads an English (United States) CSV file locale button. Is there a way to ensure that the DateTime data types from a download consistently stays in that data type form regardless of what the country of origin is downloading the singular download button.

0 1 254
Topic Labels
0 Likes
1 REPLY 1

Posted on --/--/---- --:-- AM
Landan_QREW
Silver 2
Silver 2
Reply posted on --/--/---- --:-- AM

The only thing I can think of is if you create your own manual csv attachment email (via an AppSheet Bot). Inside your template, you may be able to base a conditional expression on another datapoint that is user specific within the app. Ex. IF(USERSETTINGS('locale')='German', TEXT([datetimeColumn],"dd.mm.yyyy HH:MM:SS"),TEXT([datetimeColumn],"mm/dd/yyyy HH:MM:SS"))

0 Likes