Forum Discussion

dbryant4891's avatar
dbryant4891
Qrew Trainee
6 years ago

Choose Meeting Time Zone & Display Current Time Zone

My use case consists of scheduling meetings/hearings in one time zone and entering it on the form but also displaying my eastern time zone time next to the scheduled.  For example, a meeting is entere...
Formulas and functions
Relationships
JasonJohnson2's avatar
JasonJohnson2
Qrew Cadet
6 years ago
Mark is on the right path. Do any of the workers work in an area that does not observe daylight savings time? In general Hawaii, Alaska, Puerto Rico and Saskatchewan(that one is a headache) do not observe DST.

------------------------------
Jason Johnson
------------------------------
  • dbryant4891's avatar
    dbryant4891
    Qrew Trainee
    6 years ago
    Jason, I wondered about that part as well because we do have clients in Arizona who don't which is why I was thinking along the lines of us entering the meeting time in as the actual time of the client's time zone and it displays to us in a separate viewing field of EST/EDT since this is where we all are internally.

    I might need further assistance in understanding what the steps are here.  So I have an existing table named Users and my key field is [User ID].  The meetings are being entered into a table named "Meetings & Hearings" within the field name [Meeting/Hearing Date & Time]. I anticipate a new field being to the right of that field as a view-only field that will convert any time entered in the [Meeting/Hearing Date & Time] field to an EST/EDT.

    ------------------------------
    Danaya Bryant
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      6 years ago
      Hi Dayana,

      It's Mark
      You would have a formula which calculates the Eastern Time based on the field for the local time  plus the offset.  Then a form rule to change the Eastern to to the formula time, when the local time is not blank.
      If you need to deal with Daylight saving time, then the offset table will need to carry the date when the clock changes to be able to figure that into the calculation of Eastern Time.

      ------------------------------
      Mark Shnier (YQC)
      Quick Base Solution Provider
      Your Quick Base Coach
      http://QuickBaseCoach.com
      mark.shnier@gmail.com
      ------------------------------
    • JasonJohnson2's avatar
      JasonJohnson2
      Qrew Cadet
      6 years ago
      Do you keep a client table?

      ------------------------------
      Jason Johnson
      ------------------------------
      • dbryant4891's avatar
        dbryant4891
        Qrew Trainee
        6 years ago
        Jason, I do, I have a client table that includes their full address.

        Mark, I usually can follow the guidance with responses to others but for some reason I'm struggling a bit here with my own first question. :) I think I"m not making the connection visually.

        ------------------------------
        Danaya Bryant
        ------------------------------