Jan 18, 2018 09:55 AM
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!)
Jan 19, 2018 05:15 AM
A ugly hack may be to use a Zapier to create a Zap and update the record according to the desired timezone you want…
Jun 15, 2018 09:50 PM
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:
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