Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: Give Time zone based on city input

1006 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Chris_Finck
6 - Interface Innovator
6 - Interface Innovator

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

3 Replies 3

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:

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?

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