Select timezone for each record

[Nat8100]

Hello,
I’ve got a table set up which is to hold flight data. So I have airport from, to and date/time fields. I would like to have the timezone listed in the time field as it is always local to the origin or destination. Is this possible? When I select show timezone it appears at GMT automatcially but I can’t then change it.

Thanks

[ScottWorld]

Welcome to the community, @Nat8100!

This is very tricky in Airtable because the timezone would need to be in another field, but you can get the results you’re looking for.

Check out my sample time zone base & its accompanying training video. It’s pretty complex, so take some time to digest it all:

Airtable

Time Zones: Working with multiple different time zones in Airtable - Airtable...

This Airtable base solves the problem of events taking place in different time zones, and users wanting to know what time those events are taking place in...

[Nat8100]

Thanks for your reply. I’ve downloaded your table so will see if I can make something work with that.