# Event timetable - across multiple timezones **URL:** \ **Category:** Ask for Help\ **Created:** [February 21, 2022, 8:31pm UTC](https://community.glideapps.com/t/event-timetable-across-multiple-timezones/38798 "2022-02-21T20:31:28Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![sammyj242](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sammyj242/32/58750_2.png) [@sammyj242](https://community.glideapps.com/u/sammyj242)\ **Post date:** [February 21, 2022, 8:31pm UTC](https://community.glideapps.com/t/event-timetable-across-multiple-timezones/38798/1 "2022-02-21T20:31:28Z")
Hi there, - We’re doing a two-day world record-breaking “zoomathon” attempt to aid the charity Hands Across the Water helping underprivileged kids in Thailand find homes, get access to technology and education. - We’re using our Glide App for the timetable (and later on to store the replays). We have over 4000 people registered and we’re closing in on our target of $150k raised. - As event hosts, we are located in Australia, but there are hosts and guests from around the world - New Zealand, Nth America, the UK and SE Asia (Thailand, of course!). Think Live Aid, but instead of musicians, it’s real estate agents trying to do good and build homes. - The event program in our Glide App - images attached - shows AEDST - but there are even 3 timezones in Australia at the moment. Because the event is over two days (and starts tomorrow) there is probably no point in putting every session into Addevent - Is there a “Construct URL” type way to convert timezones around the world on the fly? Or is the only way to add a heap of timezone columns in my sheet and then get the user to select their closest timezone? Any hints will be gratefully appreciated while I work on my opening remarks for tomorrow (nothing like putting pressure on myself!!) ![IMG_2217](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/9/2915d7d142ecd18367224104a1a46677a31bb17b.jpeg) ![IMG_2218](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/3/c3b31c33205eebfc9a5cf762ef1e891bf180a4e0.jpeg) ![IMG_2219](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/e/3ecce05dd1a457c9ad9ec8a446b821b635aca621.jpeg) ---
**Author:** ![SantiagoPerez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/santiagoperez/32/16807_2.png) [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)\ **Post date:** [February 21, 2022, 8:44pm UTC](https://community.glideapps.com/t/event-timetable-across-multiple-timezones/38798/2 "2022-02-21T20:44:25Z")
This may give you an idea. > [@clock3 System/GMT Time - Solved!](https://community.glideapps.com/t/system-gmt-time-solved/27524): > > This is an extension of the request for [System Time, please](https://community.glideapps.com/t/system-time-please/26837). There’s been a lot of questions for a while about how to get a universal time that can be shared for multiple users across multiple time zones. Most of you will know that any time your get a date/time from one of the glide special values, it will always be the user’s local time. But if you don’t know which time zone they are in, then you have no easy way to convert that date/time into something standard, like Greenwich Mean Time, to… ---
**Author:** ![sammyj242](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sammyj242/32/58750_2.png) [@sammyj242](https://community.glideapps.com/u/sammyj242)\ **Post date:** [February 21, 2022, 8:53pm UTC](https://community.glideapps.com/t/event-timetable-across-multiple-timezones/38798/3 "2022-02-21T20:53:08Z")
Thanks @SantiagoPerez , I did look at that yesterday - but that all seemed way too much to decipher in a couple of hours and felt extremely complex for the job. And without seeing what dates/times were being returned I didn’t feel confident that everyone would get the right time and I don’t want anyone missing out!! (or the support calls from frantic users) I’m really looking for something like - has someone integrated Glide into something like [timeanddate.com](http://timeanddate.com) using a construct URL of some kind - or was thinking about hard coding columns with specific timezones myself (not ideal and time consuming) ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [February 22, 2022, 12:41am UTC](https://community.glideapps.com/t/event-timetable-across-multiple-timezones/38798/4 "2022-02-22T00:41:28Z")
I would seriously take another look at the solution @SantiagoPerez pointed out. You can copy the app if you haven’t already. It might seem overwhelming, but there is probably more in there than you need. If you look at the data table, pay attention to the first 4 columns. A lot of the other columns are just to show the offset value a certain way on the screen, values to control the clock on the screen, and just some other random stuff I was testing. The first 4 columns are the most important. But, I think you could get away with a similar but much simpler approach. If all of your event times are going to be based on your local time of AEDST, then I would create a template column that joins the event date and either `AEDT` or `+11`. You end up with something like this: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/b/3b08e983a59450ba513df956cbfae59aaf701969.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/2/82cb4ee2045f43d809e10526020b3834d2147744.png) When you set that template column as the source of your date setting for the calendar list, it does the automatic conversion to your local timezone. So your event that starts at 9AM on the 23rd, would start at 10PM on the 22nd GMT time, and for me it works out to 4PM on the 22nd for my personal local time since I’m 6 hours behind GMT time. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/5/55c8d3a16b6dd0f3cfdb236b457c664cdb5679de.png) That way, each user will see the correct time because you used the template column to specify that the event time is in your specific AEDT or +11 timezone instead of an ambiguous datetime. I’ve updated the example @SantiagoPerez shared, so if you copy it again, you will see the new columns at the end. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [February 22, 2022, 1:01am UTC](https://community.glideapps.com/t/event-timetable-across-multiple-timezones/38798/5 "2022-02-22T01:01:52Z")
> [@sammyj242](#): > > We’re doing a two-day world record-breaking “zoomathon” attempt to aid the charity Hands Across the Water helping underprivileged kids in Thailand find homes, get access to technology and education. That’s awesome 👍 ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [February 22, 2022, 1:08am UTC](https://community.glideapps.com/t/event-timetable-across-multiple-timezones/38798/6 "2022-02-22T01:08:22Z")
> [@Jeff\_Hager](#): > > When you set that template column as the source of your date setting for the calendar list, it does the automatic conversion to your local timezone. That’s even more awesome. I thought we can only use a sheet column and let Glide convert it using a date/time column. ---
**Author:** ![sammyj242](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sammyj242/32/58750_2.png) [@sammyj242](https://community.glideapps.com/u/sammyj242)\ **Post date:** [February 22, 2022, 1:42am UTC](https://community.glideapps.com/t/event-timetable-across-multiple-timezones/38798/7 "2022-02-22T01:42:26Z")
You never know we might be encouraging the next generation of no-code glide awesomeness in some way…!! 🙏🏻 ---
**Author:** ![sammyj242](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sammyj242/32/58750_2.png) [@sammyj242](https://community.glideapps.com/u/sammyj242)\ **Post date:** [February 22, 2022, 1:48am UTC](https://community.glideapps.com/t/event-timetable-across-multiple-timezones/38798/8 "2022-02-22T01:48:02Z")
OK @Jeff_Hager you win… I’m going back in there. Wish me luck! ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [February 22, 2022, 1:50am UTC](https://community.glideapps.com/t/event-timetable-across-multiple-timezones/38798/9 "2022-02-22T01:50:14Z")
When I started writing this out, I was thinking of converting everything to GMT time first, but then I remembered what you had mentioned in the past about setting the timezone directly to the datetime. That ended up being a much quicker method. I think the same way that a date column can interpret almost anything as a date (tomorrow, 3 months from now, etc.), the calendar interprets dates the same way. You can feed it text and it will figure it out magically. The only downside is that you can’t work with the template column as a date. Also, can’t apply any filtering against that template. You can sometimes pull off formatting by using it in a math column, but you have to first use a real date column to get the formatting options to show up, then switch it to the template column and the formatting options should stick. Also, you can’t do any date math on the template. I think you would have to first go through the work to figure out the offset number, and then do the math against the original date using that offset. Doable but with some additional work if you still need the resulting date to be treated as a date everywhere.