How do I choose the desired time zone? (not set it via formula)

[Alan_Lepofsky]

I am trying to create an application for tracking my travel. I would like to have the following fields:
Flight1DepartureDate
Flight1DepartureTime
Flight1DepartureTimeZone
Flight1Airline
Flight1Number
Flight1DepartureCity
Flight1DepartureAirport
Flight1ArrivalCity
Flight1ArrivalAirport
Flight1ArrivalDate
Flight1ArrivalTime
Flight1ArrivalTimezone

allowing me to enter data such as:
Delta 123 leaves Atlanta (ATL) 01/01/2018 9:30am ET arrives in San Francisco (SFO) 01/01/2018 12:30pm PT

Any help would be appreciated. (and I’d be happy to share the app if I can get it working!)

[Andrew_Johnson1]

A ugly hack may be to use a Zapier to create a Zap and update the record according to the desired timezone you want…

[Jeremy_Oglesby]

The SET_TIMEZONE() function just takes a string to set the Timezone, so you could use the appropriate Timezone string in the Arrival Timezone and Departure Timezone fields:

Airtable - Support

Formula field reference

For an overview of formula fields, please refer to the Guide to Formula, Lookup, Count, and Rollup fields. Formulas may involve functions, numeric operations, logical operations, and text operation...

And then interpolate the string into the formula in the main Date/Time Field:
DATETIME_FORMAT(
SET_TIMEZONE(
{Arrival Date},
‘{Arrivale Timezone}’
),
… etc