Forum Discussion

BhargaviKatepa1's avatar
BhargaviKatepa1
Qrew Member
2 years ago

How to give Location and TimeZone of the user on a form

Hello,

I got the requirement like we need to show the current user location and time zone on a form, it shouldn't be a auto filled, it should be like a dropdown value with only their specific location they can select, and they can change it to other if they want, without creating a Master table could it be done? If anything related have done earlier, request your help here.



------------------------------
Bhargavi Katepalli
------------------------------
  • JeffPeterson1's avatar
    JeffPeterson1
    Qrew Captain
    2 years ago

    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
    ------------------------------