When I add the Special Component - Date Time Stamp for a form entry, is there a way to force it to use Universal Time, rather than Local Time? If multiple users from different time zones are using my app, the time stamps that their data entries generate can appear to be in the past or in the future…

I have the same thing. Reverted to Google Action Script setting the current date. (or you can choose to store UTC). Next ‘issue’ is presenting the time back to the users in their local time. I haven’t come up with a clever way,… Since you have local time in the post, and UTC you can get the datedi…

This post may be useful. [image] Converting "-07" text to "-7" number value in google sheets Anyone know how to convert “-07” text to “-7” number value in google sheets? Been hitting a wall with this, can’t find the solution on Google. here’s the error i get [image] …

Another useful post: [image] Timezone Conversion I’ve created an events app that accepts events from different timezones. In my form I capture Date Time of the event and require them to choose their time zone. Each time zone has associated with it the + or - UTM in a sec…

Thanks for the feedback. I’ll have to look into this Google Action Script… what do you use to trigger? onEdit doesnt work with Glide, does it?

onChange will work with triggers from Glide, onEdit doesn’t.

What @ThinhDinh said :stuck_out_tongue:

Script I use. Not the prettiest but functional. var postSheetName = "Posts"; /** * REMARKS */ function updatePostCurrentProfileChallengeID() { var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(postSheetName) var startRow = 1; // First row of data to process var numRows = …

Thanks. I got something working now in my template, similar to this using an onChange trigger, But now the app isn’t duplicating. My first thought was having a script attached to the project was causing the duplication error?

Is Date Time Stamp - Local Time only?

Ask for Help

Jeff_Hager May 25, 2020, 11:06pm 4

Another useful post:

Topic		Replies	Views
Display UTC time in Glide App in users Local Time Ask for Help	11	1290	August 22, 2024
Submission time Ask for Help	12	572	September 3, 2022
Timezone not captured in Date Time component Ask for Help	19	2181	January 6, 2023
Fixing timezones with Google sheets (not glide tables) Ask for Help	6	701	August 19, 2023
Timezone Conversion Ask for Help	3	1095	May 26, 2020

Is Date Time Stamp - Local Time only?

Related topics