Multiple FileMaker Sources

"A man with two watches never knows what time it is." - Chinese Proverb, (and a great reason to get all your dates in one calendar).

How can I show records from more than one FileMaker table in the same calendar?

Traditionally a FileMaker portal can only show records from one table occurrence, though it can include fields from other table occurrences.

DayBack, however, can include events from completely unrelated tables--each of which becomes a "source" for the calendar. In this way, you might have an events table holding things like followup calls or meetings, and have a second table for your jobs. Both of these tables could become separate calendars in DayBack and you could view them separately or both at the same time. (DayBack for FileMaker comes with two sources as examples: "Sample Events" and "To-Do List".)

You can even have multiple sources from within the same table: if, for instance, you had a job due date in your jobs table and a followup date in your jobs table, you'd create those as two separate sources.

You can see a list of your available sources on the "Calendars" tab in DayBack's left-hand sidebar. And administrators can create new sources on Admin Settings / Sources.

How does the calendar decide which source to use for a new event?

There's a setting for your default source and if that source isn't visible, DayBack will suggest the first editable source. You can read more about that here: creating events.

Creating a new FileMaker source

First, you'll need to add DayBack's six required fields to the table(s) whose dates you'd like to see in your calendar. You'll copy these fields from DayBack's example table: SampleEvents_DayBack.

Once you paste the fields into your file, a few of the calcs require some editing: you'll find instructions here: Copy & Paste Six Required Fields

Administrators can click on "Administrator Settings" on the Settings tab of the calendar's sidebar. Once on the admin screen, they'll see "Calendar Sources" on the left-hand side: click "FileMaker Server" to see the source(s) you've already created and reveal a button to create a new one.

Then follow the on-screen instructions to map your new source to DayBack just as you did when you first integrated the calendar.