Give Time zone based on city input

[Chris_Finck]

Are there any automations where I can get the timezone output in a column (EST,PST,MST,CST) based on another column (city input)?

[ScottWorld]

If you know all the city inputs in advance, you could write a formula to do that for you. If you don’t know all the cities, or if you want to incorporate that into an automation, you would need to write a custom JavaScript for something like that — and it would probably need to include the help of an external API that translates cities into time zones.

For a deep dive into Airtable time zones, you can check out my training video & sample base here:

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...

[Chris_Finck]

This seems like a good start. I mean theoretically I just want to set myself up for a scalable solution so that when new cities are added they are already geocoded for a specific time zone. Are there any blocks that can work with Googles Time Zone API?

[Bill_French]

ScottWorld:

it would probably need to include the help of an external API that translates cities into time zones.

We already have that - based on lat/lng, you can always know the local time and use an offset to get the time zone.