Time Zones - Travel App

Good Day from Japan,

I would love some help. ChatGPT and I are crushing the development of a travel app but I am running into a time zone issue.

I am working with multiple schools who send students to multiple timezones. The big desks at the school want a dashboard showing them what everyone is doing right now. The times I have put into the itineraries are all local for the participants based on the time they will need it.

Here are my issues.

  1. If I use the calendar it is off because it is set to my timezone. (Ok I can give that as a grid).
  2. Admin won’t get a live view as the times in the grid are only right for the user in their timezone.

I have played with Google Timezone API to get the timezone based on the coordinates. I can do the math to get UTC time but how do I show that on the calendar view? Is there something that I am missing that would make this so I can use the calendar view?

Thanks!

Dan

Hi Dan,
for each event you could have a local time field (which you have already), then a ‘global’ time field, that calculates the time in your global time by adding or subtracting hours depending on the timezone. On your global calendar views you show the global time, on the local / user views you show the entries in theor local time.
And if you haven’t done it already I’d have the timezone as a connected table (rather than a multiple choice field), with a column for the hours to add / subtract. This will give you more options down the line as the app grows.
Hope that helps / answers your queries.
Hugo

Hugo, thanks. I will give this a go. Appreciate your help!!