We’re running a virtual conference. Our schedule (and spreadsheet settings) is set to Eastern Standard Time. People are going to be logging in from all over the United States. I would like for the scheduled events to adjust to the User’s time. That way, someone in the pacific time zone will know that the welcome starts at 9am while someone in the east coast will see the welcome starting at 12pm to account for the timezone difference.
As of now, what is displayed on the schedule is the date/time in eastern time as it is entered that way into the google sheet.
This might help. You can create a template column with the date/time and “GMT-4” or or possibly EST or ET appended to the end. Then use that template column as your calendar date and I believe it should adjust accordingly for each user.
Or you can adjust your time to GMT time and then calculate the user offset automatically and adjust the time with some date math. This is what I do in this example.
Adding to Jeff’s answer, if you ever want to have those being able to be submitted by people from any timezones (not just GMT-4), then you can calculate their offset in the user profiles sheet and submit that info alongside the new event when someone adds to that Sheet using a form in the app.
Glad you got it to work! Just some advice, which I’m sure you realized in my app, is that you probably could have avoided any temporary columns in the google sheet itself. If you know your times are always going to be based on EDT, I think you could have simply created a template column in the glide data editor to join the date column and EDT. The template column would be your your date source for the calendar in the app. The glide calendar is incredibly flexible at interpreting text based dates and times in a variety of formats. Maybe you have reasons for doing it the way you did. Nothing wrong with how you did it, but just something to keep in mind for the future.