Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Give Time zone based on city input

Topic Labels: Automations
268 3
cancel
Showing results for 
Search instead for 
Did you mean: 

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.