Forum Discussion
JeffPeterson1
2 years agoQrew Captain
Here is a simple way to do this:
Have a multiple-choice dropdown called [Location] that holds your locations (Location A, Location B, etc).
Then a formula-text or formula rich-text field called [Location and Timezone]:
var text timezone = Case([Location],
"Location A", "Timezone A",
"Location B", "Timezone B",
"null");
"Working in "&[Location]&" in timezone: "&$timezone
When the user chooses a location, this would give you some text like this:
'Working in Location B in timezone: Timezone B'
------------------------------
Jeff Peterson
------------------------------