Are there any automations where I can get the timezone output in a column (EST,PST,MST,CST) based on another column (city input)?
Give Time zone based on city input
+35If 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:
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?
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:
We already have that - based on lat/lng, you can always know the local time and use an offset to get the time zone.
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.