I’m on the struggle bus with time zones in a booking system. It hasn’t clicked. And I’m pretty novice with formulas in Airtable in general. I started off “wrong” so I’m trying to adapt formulas in a system that’s already live. I can’t simply start over. Basically, I’ve got folks from all over the …

Welcome to the community, @susanesny ! Time zones are nearly impossible to work with in Airtable, as @Cherry can testify to! :wink: I see that you downloaded my time zone base to use as your starting point, but you might have missed the training video that goes along with it. If you hover over the…

I see the "i"s and I did watch the video. Did I mention I’m on the struggle bus? In the Official Time of Event column, I don’t have a “GMT” option to turn on, per se. Are you saying I have to use GMT - period? I can’t simply adapt the formula to convert from America/New_York? [nogmt] Actual and …

In your example, is Official Time of Event in Official Time Zone or GMT? I’m so confused. If I turn my Official Time to GMT that will change all my times? I’m so confused.

[error] Why? Do people drink while they Airtable?

Hi Susan, Timezones are a joy in Aritable! Here’s a video to help you normalize this a little: The Problem with Time & Timezones - Computerphile - YouTube As for your issue in Airtable, who is actually using your base? Just you or also the people around the world who are also booking calls with yo…

Here is how I deal with time zones. For date/time fields, have Airtable show the local time and display the time zone. In some cases it makes sense to have Airtable always display the time in a particular timezone. Date only fields always have a time of GMT midnight when used in formula fie…

I’m using a form to collect times for people who do not have access to the base. My form doesn’t display the time zone at all – despite the fact that I’m pulling the information of available time slots. [times-no zones] I could just say all times are Eastern, but then the math is on the user – and…

[image] susanesny: Why? Do people drink while they Airtable? Lol! it’s highly possible! :clinking_glasses: [image] susanesny: In the Official Time of Event column, I don’t have a “GMT” option to turn on, per se. Are you saying I have to use GMT - period? I can’t simply adapt the formula …

p.s. In general, I’m not 100% convinced that Airtable is the world’s best system to use for handling events that need to be accessed by users across multiple time zones. Time zones were handled much more elegantly in FileMaker, but that is a full-blown programming language that requires working with…

[image] susanesny: I’m using a form to collect times for people who do not have access to the base. My form doesn’t display the time zone at all – despite the fact that I’m pulling the information of available time slots. It can sometimes be easier to use an online appointment scheduling cale…

Please talk me through time zones sllllloooooowwwwwwwly

Airtable Questions

ScottWorld July 5, 2023, 4:57pm 19

Great, @darragh! I see you created your post here:

Topic		Replies	Views
Is there a way to add Time, without date, field option Airtable Questions	2	386	March 18, 2023
Formatting a date field as text Airtable Questions	2	207	March 15, 2023
Helping Airtable team to add AI features - AI code suggestions 😁 Show and Tell	16	816	April 1, 2023
promptGPT() Sadly Doesn't Exist Scripting	22	767	April 19, 2023
Ultimate solution to converting number into international format Fields and Formulas	5	292	February 26, 2023

Please talk me through time zones sllllloooooowwwwwwwly

Related topics