Forum Discussion
MarkShnier__You
Qrew Legend
6 years agoThis 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
------------------------------
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
------------------------------