Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Feb 15, 2021 08:48 AM
Are there any automations where I can get the timezone output in a column (EST,PST,MST,CST) based on another column (city input)?
Feb 15, 2021 09:00 AM
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:
Feb 15, 2021 09:20 AM
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?
Feb 15, 2021 09:31 AM
We already have that - based on lat/lng, you can always know the local time and use an offset to get the time zone.