Option to choose correct timeone
When the app is used in different countries (timezones), we need to have an option are we going to use user deviceโs locale timezone or for example Sheetโs timezone. We are having problems when we need to sort the view with the created datetime value. For exampleโฆ if someone fills the form in US and I will do the same in FI, sorted view is not correct.
I know we have the locale expression but itโs not bulletproof way because if Iโm abroad, it wonโt work eitherโฆ
Thoughts?
I believe it should only obey to the timezone set in the gSheet. I can be in FI without having my device use the timezone of the roaming OR I can even turn off roaming. But I agree that we should have such kinda setting to play with. On the contrary, Iโm not so sure if Excel users might have the same.
I concur, Having a Base Timezone is a must, but I also believe that the option to activate it or not needs to be there as you may also want to sort/work by timezone.
i.e. Global Organisation, local usage (Global Aggregate Info, Local Details).
Using local dates and times is a mess regardless of which local timezone you choose as the โbaseโ.
Keeping all times in UTC makes life much easier.
You can then decide whether to take on the burdens of: 1. Displaying dates and times in the userโs local timezone 2. Formatting dates and times based on the userโs preferred locale.
By the way, doing these two things properly is ridiculously difficult. The complications are endless.
User | Count |
---|---|
36 | |
33 | |
27 | |
23 | |
18 |