Discussions

Expand all | Collapse all

Choose Meeting Time Zone & Display Current Time Zone

  • 1.  Choose Meeting Time Zone & Display Current Time Zone

    Posted 12-17-2019 16:01
    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 entered on the form for 1 pm CST in a date field but next to that display 2 pm EST so that our internal staff are aware of both times. I think my dilemma is that my application is set to EST, so I'm not sure if that means our staff would have to enter our current time zone then expect to see the other time zone displayed...I'm not sure the best approach or how to accomplish this.

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


  • 2.  RE: Choose Meeting Time Zone & Display Current Time Zone

    Posted 12-17-2019 19:09
    This might be able to be done, but you would need to have a table of users where the userid is the Key field and another field in the table for the offset from Eastern which is the time zone for the app.

    Then set up a relationship between that table and the data entry table(s) based on the reference field on the right side of the relationship being [Current User] which would be a formula user field with a formula of 

    User()

    Now every record knows the local user's offset, say 2 hours for a staff member in Mountain Time Zone.

    Then you would have to decide how the data is being entered.  It most straight forward to enter it in Eastern, but if you want to enter it in local time, then you can have a field  for entry call time in local time zone,  and have a formula calculate what that is in eastern, and then have a form rule maintain the field called Eastern Time.

    So user enters into a field called [Local Time], and the form rule populates the data entry field called [Eastern Time] 


    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 3.  RE: Choose Meeting Time Zone & Display Current Time Zone

    Posted 12-18-2019 13:56
    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
    ------------------------------



  • 4.  RE: Choose Meeting Time Zone & Display Current Time Zone

    Posted 12-18-2019 14:21
    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
    ------------------------------



  • 5.  RE: Choose Meeting Time Zone & Display Current Time Zone

    Posted 12-18-2019 15:52
    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
    ------------------------------



  • 6.  RE: Choose Meeting Time Zone & Display Current Time Zone

    Posted 12-18-2019 19:28
    Do you keep a client table?

    ------------------------------
    Jason Johnson
    ------------------------------



  • 7.  RE: Choose Meeting Time Zone & Display Current Time Zone

    Posted 12-19-2019 15:44
    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
    ------------------------------



  • 8.  RE: Choose Meeting Time Zone & Display Current Time Zone

    Posted 12-19-2019 16:53
    Danaya,
    Can you contact me off line and I will do a quick screen share to see if we can get this working.
    Mark

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 9.  RE: Choose Meeting Time Zone & Display Current Time Zone

    Posted 12-19-2019 19:11
    Danaya, I've done this so much but  you have this fun twist that I had never worked on. I went and made an app with 3 tables Meetings, Users and Clients. Then I made a field called Meeting Time/Date and put it together so that it accommodates the user and client times zones along with daylight savings down to the day. I think it is finished but my brain got a little tired during testing.  Anyway I have an app and can give you access to it as an admin where you can see test it and learn how it is put together so you can replicate it yourself.  All I need is an email address so I can add you.

    ------------------------------
    jason johnson
    ------------------------------