Hi @Darren_Murphy , I have a problem: How to lock the “Done” button based on actual server time not based on the time of the user gadget? Does your method still work or is there another way that is more certain? [image] YC for time zone change? Ask for Help That integer …

So there is a new feature to respect timezones with a date column. So if the option is selected, whenever a user adds a specific date and time with respect to their time zone, it will display the date and time for other users in other timezones with the correct time for there timezones. I think th…

The most reliable method to determine a users UTC offset at the moment would be @Jeff_Hager ’s solution: [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 abou…

What’s considered server time here? UTC / GMT time, or local time for the developer? @Darren_Murphy , have you experimented much with the new feature to respect timezones in a date column. Is that still in staging only? I wonder if that would be useful in some way, or could simplify some things. …

Sorry, I mean UTC/GMT time. Maybe I need to explain what I’m doing. I intend to fill the deadline according to my local time wherever I am, to determine the time limit for assignment submission to lock edit forms. I found the deadline can be cheated by changing the timezone on the user’s device. S…

[image] Jeff_Hager: @Darren_Murphy , have you experimented much with the new feature to respect timezones in a date column. Is that still in staging only? I wonder if that would be useful in some way, or could simplify some things. I haven’t had a chance to play with it, but I only see it in stag…

[image] Darren_Murphy: To be honest, I found it a little confusing. I think what it’s doing is saving the timezone of the user that entered the date. When you do that then glide (or rather the javascript) knows to convert that date time to your timezone. That’s basically what I’m doing in m…

Very appreciate for your explanation. Meanwhile I will use google script while waiting for updates from Glide. Thank you Jeff

One additional question @Jeff_Hager , what if the calculation is done in a google sheet via the formula if(A2>now(), false, true), instead a script? If I use a script then which current time is based on the time in the sheet?

[image] Himaladin: One additional question @Jeff_Hager , what if the calculation is done in a google sheet via the formula if(A2>now(), false, true), instead a script? I would definitely make sure you test it to be sure, but I feel like if you used a formula, it would only update if some other…

[image] Jeff_Hager: If you go into your sheet settings, you can set the timezone for your sheet. I’m assuming the script would use that same time. Actually, it doesn’t. The script timezone is independently set in the Project manifest file (appscript.json): [Screen Shot 2022-09-03 at 9.50.55…

Submission time

Ask for Help

Darren_Murphy September 2, 2022, 1:32pm 2

The most reliable method to determine a users UTC offset at the moment would be @Jeff_Hager’s solution:

Topic		Replies	Views
Display UTC time in Glide App in users Local Time Ask for Help	11	1281	August 22, 2024
Is Date Time Stamp - Local Time only? Ask for Help	9	882	May 26, 2020
Fixing timezones with Google sheets (not glide tables) Ask for Help	6	695	August 19, 2023
🆕 "Respect time zone" support for Date & Time column in Glide Tables & Airtable Community Resources	17	1901	September 24, 2025
Set column - Time zone Ask for Help	8	707	March 26, 2021

Submission time

Related topics