Thanks Scott!

I’ll have to mull over this to see how I want to implement it into our workflow. I know that the person that sets up these schedules is on the East Coast, and I want to make it:

• 
  

  easy for her to enter the time.

  
  


• 
  

  Display the other timezones(PST and GMT)

  
  

Show up on the Calendar with only one timezone, the user’s time zone.(not sure how this will work)

You’re welcome! Glad I could help!

Question on that marvelous table!

So you have



Official Time of Event listed first, and it’s set to GMT to on. and then you have Actual GMT of Event, then user’s Local Time of Event.

the first field confuses me, as I’m trying wrap my head on how I’d do the same thing for listing our three different time zones for our own table for the one course, and not in different locations as yours show.

I have the training date, without a time in there, and then the three different timezones as real times. but I’d want to make those the calculated formulas, correct? and then each field directly minus the offset(so I’d have to have an offset field, right)

Sorry, just trying to wrap my head around this.

Thanks!

Here’s the tricky thing to keep in mind: Whenever you turn OFF that GMT button, Airtable will ALWAYS translate the time to your own local time zone.

So, whenever you want to see a STATIC TIME that doesn’t change, you always have to turn ON that GMT button — even if you don’t plan on using GMT time.

So then, it’s just a matter of creating formulas (with that GMT button turned on) to display the static time that you want to see.

In your case, since you already know in advance the 3 different time zones that you want per record, you could just go as simple as typing in the official GMT time of the event (with GMT turned on) into a normal Date field.

Then, just create 3 simple formula fields that simply add or subtract the appropriate number of hours from the Date field. You will use the DATEADD function to do this. Make sure that all 3 of these formula fields have GMT turned on.

So, in your case, you don’t even need to get involved with the SET_TIMEZONE function. You can just keep it very simple by creating 3 simple formulas.

YES! Thank you! That makes sense. I was getting co fused as I’ve seen there are Locale formulas as well. So would the “user” then just enter the GMT time and then Id have formulas for the east and west coast?

Thanks again for your help.

Sean

Here’s the tricky thing to keep in mind: Whenever you turn OFF that GMT button, Airtable will ALWAYS translate the time to your own local time zone.

So, whenever you want to see a STATIC TIME that doesn’t change, you always have to turn ON that GMT button — even if you don’t plan on using GMT time.

So then, it’s just a matter of creating formulas (with that GMT button turned on) to display the static time that you want to see.

In your case, since you already know in advance the 3 different time zones that you want per record, you could just go as simple as typing in the official GMT time of the event (with GMT turned on) into a normal Date field.

Then, just create 3 simple formula fields that simply add or subtract the appropriate number of hours from the Date field. You will use the DATEADD function to do this. Make sure that all 3 of these formula fields have GMT turned on.

So, in your case, you don’t even need to get involved with the SET_TIMEZONE function. You can just keep it very simple by creating 3 simple formulas.

Yes, that’s what I would do! Make sure all fields have GMT turned on.