Creating a doc to be used by me and someone in another timezone. The entire point of it is time tracking/scheduling, so it’s especially important that I be able to test and/or troubleshoot as if I were in her timezone (I can ask her to do some, but it’d be 100000% easier on everyone if I could do it myself mostly.
I’ve tried a couple different ways to make my browser think I’m on Central Time (gleaned from an internet search) & so far none seem to convince Coda.
I could of course set my whole OS to Central but…the idea of doing that over & over (not to mention throwing off any scheduled anything) is decidedly unappealing.
There seems to be a Coda setting for timezone, but tbh the way timezones are handled in the first place confuses me, so I’m not sure if this is the right way to go about this? (And if so, is it okay to be changing it back & forth as I work? Will that mess with existing docs? Is there a limit to # of times I can change it?)
I’ve been working with time zones forever and I manage a remote team.
At a high level, here’s what I would do:
Create a Users table with a time zone column. That gives you the time zone for the user. When they login, you can easily lookup their time zone based on User().
Anywhere you have a date/time column, create a second column called Date Time in Local Time Zone which uses my pack to convert to the current user’s time zone.
You can set YOUR time zone in the Users table to pretend like you are in THEIR time zone.
For display displaying times, use the Date Time in Local Time Zone column.
When you are “pretending” to be in their time zone, you can see how it looks for them.
I’m happy to jump on a Zoom if you’re interested in a clearer overview.
Thanks! I had been using your pack, but couldn’t figure out quite how to make that work re: the “spoof”, so that’s good to know. I’ll probably try it out when I have a little time, see if I can make your text instructions work for me, then let you know if I have trouble?