If you have a distributed team, you’re painfully aware that there is no built-in support for switching time zones in FileMaker. There’s easy way to have your time fields translate themselves into a different time zone.
DayBack changes that.
By default, DayBack shows events on the calendar at whichever time is entered into your time field. But you can mod the calendar so users can select the time zone in which they want to view their schedule. Edits made in this mode are saved adjusting for the time zone they’ve selected. The mod takes advantage of a Moment.js enabled selector in a web viewer, along with some field and script changes. Detailed instructions and an example file follow below.
Here’s a video of the mod switching time zones in FileMaker:
How It Works
The most important thing to understand when implementing something like this is that the records will need to be saved in a specific “reference time zone”.
In an ummodified calendar, no matter where you are located, when you schedule an event in DayBack for 12:00 PM, that field will be saved as 12:00 PM in the record. A “reference time zone” is your team’s agreement as to what that “12pm” means. For SeedCode, we have users in multiple time zones, but our reference time zone for events is Pacific. The users living outside of the Pacific time zone have just had to manually adjust their events accordingly… until now! Most teams already have such a reference, even if it’s only in your head. In this mod, you’ll make it explicit.
After implementing this mod, if you are in Pacific time and your “reference time” is in Eastern, the field on your event record will actually be saved as 3:00 PM. =)
There’s a bit of work to implement this into your calendar, but you should be able to get there by following these instructions closely. If you run into any issues, please reach out to us.
Downloading the Example File
First, download the example file, try it out, and see if this time zone behavior is right for yout team: DayBackTimeZones
You’ll copy a few things out of this example and paste them into your file following the instructions below. You’ll add a new web viewer selector, a layout, scripts, and some DBk_WebViewerSource calculation additions to your file.