Skip to main content
Question

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

  • March 28, 2023
  • 0 replies
  • 117 views

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
------------------------------
    This topic has been closed for replies.

    SSNJeffP
    Forum|alt.badge.img+11
    • SSNJeffP
    • Quickbase Alumni
    • March 28, 2023

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

    Terms & ConditionsAccessibility statement