I was surprised this morning to find some of my users were active in the future. After double checking the App I quickly realized it was because they were probably using the App in Asia. This caused the set column action to input a time-stamp that is effectively in the future vs. my time. Any fixes…

You can ask your users to specify their timezone, and save that as a part of their profile. Then you can make appropriate adjustments wherever necessary with date math columns.

Thanks - I see that working. As a workaround, what about having a cell in the Google sheet that always displays the GMT time and subtract from that? I have never created a cell in a Google sheet to do that but it’s probably possible. Then it just needs to be compared vs. the time-stamp. I just hat…

[image] Simon_Hill: As a workaround, what about having a cell in the Google sheet that always displays the GMT time and subtract from that? Do you mean as a method to determine the Users Timezone offset? So when a user triggers an action that causes a time to be set, you compare that time to…

Yes, exactly. Currently searching through Google Help but it’s not obvious how to use the = Now(). Maybe the answer lies in an external look-up… or maybe a template with a URL that returns the value…

I’d be avoiding the spreadsheet and instead be looking for a way to do it in the GDE. Try entering ‘now’ in a date time column in Glide, and see what it gives you. That might provide you with a starting point…

Yes, agree… but can you reassure me that Now is the App’s time (let’s call it GMT) and not the User’s now ? After all, using the Set Column with NOW inserts the user’s time.

Yes, you’re right. Computed columns are calculated on the users device, so now() will always be the local time according to the device. But still, there will be a way. I’ll have a think about it…

Solved it!! [image] Timestamp with your local time NOT user's time zone Community Resources Happy to share a trick if you want to track activity in your App, e.g. how many users are active in the last X hours then how many the last Y minutes. This solves the …

Set column - Time zone

Ask for Help

Simon_Hill March 26, 2021, 10:14am 9

Solved it!!

Topic		Replies	Views
Timestamp with your local time NOT user's time zone Community Resources	7	1084	May 21, 2021
Submission time Ask for Help	13	564	September 4, 2022
Work around for timezones Ask for Help	0	472	February 9, 2021
Is Date Time Stamp - Local Time only? Ask for Help	9	882	May 26, 2020
🆕 "Respect time zone" support for Date & Time column in Glide Tables & Airtable Community Resources	17	1899	September 24, 2025

Set column - Time zone

Related topics