I have a need to get a time value that is set by the outside world, and not the user’s device. For instance, I now have people doing corona tests with my app around the world (good), but we have opening hours of 12-19 CET during this pilot phase. BUT Glide uses the user’s device to work out ‘now’ so…

[image] clock3 System/GMT Time - Solved! Project Showcase This is an extension of the request for System Time, please . There’s been a lot of questions for a while about how to get a universal time that can be shared for multiple users across multiple time zones. Most of …

Demo: [image] [image] [image] [image] (hour(CET)-hour(L)) + (24 * ABS(day(CET)-day(L)) / (day(CET)-day(L))) + (minute(CET)-minute(L))/60 [image] L + (OS/24*-1) However as it’s summer time I believe you can try CEST instead. [image]

Thanks - but I’m not sure if this helps. I don’t know the user offset time for all users. Plus I don’t always have the ability to get the user to do an action to pick up a timestamp I can manipulate (with a webhook - which I already use). The time for a user coming in and seeing the ‘closed’ popup i…

You don’t need the user to do anything for this to calculate. It is automatic. We take the “now” value from a math column, then the other things are template columns and math columns. From your original post, do you mean you will show something to the user during 12-19 CET and something else during…

Yes - the system is open between 12 - 19 CET. But a user might come in from holiday in Peru… so -7 from CET Let’s say it is 2000 in CET. User time for ‘now’ is 1300 Peru time. I cannot just use a template column to pretend their time is CET. And the template column you have would compute the Tim…

With YC [image] [image] [image]

[image] Mark_Turrell: Unless I’m missing something! yes, you are :wink: The beauty of Jeff’s solution is it requires nothing from the user. It takes their “now” and through the use of a clever trick converts it to any (valid) time zone that you want.

Well if you insist… Here’s a video to show that it works regardless of the user’s timezone. I even moved to Alaska for you. The ‘pretend’ part here is to know if you use the current time of the user and add CEST to it then what would it convert to the user’s timezone. Glide can read th…

To make the YC column refresh, I tweaked the code a bit [image] [image] [image]

Hello @Mark_Turrell So you have the choice between 2 ways to do it Then it is possible to complete the script with other tips and tricks

Is it possible to have script to get 'system time' - UTC or GMT?

Ask for Help

Mark_Turrell August 8, 2021, 7:39am 15

This is fixed now thanks to @Manu.n and his XC (Experimental Code) to pick up UTC as a value.

Topic		Replies	Views
Display UTC time in Glide App in users Local Time Ask for Help	11	1291	August 22, 2024
System Time, please Feature Requests	20	1575	June 4, 2021
Submission time Ask for Help	12	577	September 3, 2022
Is Date Time Stamp - Local Time only? Ask for Help	9	886	May 26, 2020
Timezone Conversion Ask for Help	3	1097	May 26, 2020

Is it possible to have script to get 'system time' - UTC or GMT?

Related topics