Required Fields in DayBack for FileMaker

Backup your file before continuing. These instructions are pretty easy to follow, but having a backup means you can take more risks and easily undo your work if you need to. All the pros backup frequently: it's a great habit to get into.

Copy & Paste Six Required Fields

DayBack can display multiple calendars simultaneously, with each calendar sourced from one of your FileMaker tables (in addition to Google, O365, or Basecamp calendars you may have access to).

For each table you want to display on the calendar, DayBack requires six fields that you probably don’t already have. These fields are found in the SampleEvents_DayBack table included with DayBack Calendar. Copy these fields and paste them into any table you want to use as a calendar source. Some fields will need slight modifications once they’re added to your table, so be sure to read the notes below.

These fields only need to be added to the tables that serve as the source for a calendar, where your dates are stored. They are not needed in related tables, like contacts.

The Required Fields

  • DBk_Expression
  • DBk_JSON
  • DBk_JSON_ListOf
  • DBk_Repeating_id
  • DBk_TimestampStartCalcNum
  • DBk_TimestampEndCalcNum

Notes

  • DBk_Expression
    • This is a simple text field defined with global storage.
    • No changes are necessary once you add it to your table.
  • DBk_JSON
    • An unstored calc defined as Evaluate ( DBk_Expression )
    • Set the "Evaluate this calculation from the context of:" dropdown to the same table occurrence you'll be using for DayBack.
  • DBk_JSON_ListOf
    • A summary field that creates a List of DBk_JSON.
    • No changes are necessary once you add it to your table.
  • DBk_Repeating_id
    • A text field to support repeating events; please add this field even if you don't plan to use repeating events.
    • No changes are necessary once you add it to your table.
  • DBk_TimestampStartCalcNum
    • A calculation that must be defined to return a number.
    • This field will likely be commented out when you paste it into your file, meaning it will be surrounded by /* comment tabs */ .
      • Remove the comment tags from the beginning and end of the calculation and replace "DateStart " and "TimeStart " with the relevant fields from your table.
      • Set the "Evaluate this calculation from the context of:" dropdown to the same table occurrence you'll be using for DayBack.
      • If you don’t have some of the fields referenced (like an end date or time fields), it’s best to add them to your events table, regardless. This simplifies the integration and allows for multi-day events should your needs expand. (You can enforce single-day, time-free events by using auto-enter calculations to keep these fields blank.)
  • DBk_TimestampEndCalcNum
    • A calculation that must be defined to return a number.
    • This field will also likely be commented out when you paste it into your file, meaning it will be surrounded by /* comment tabs */.
      • Remove the comment tags from the beginning and end of the calculation and replace the fields referenced with the relevant fields from your table.
      • Set the "Evaluate this calculation from the context of:" dropdown to the same table occurrence you'll be using for DayBack.

Other Fields You May Want

The following fields aren't required but can simplify the integration process. These fields are included in the SampleEvents_DayBack table provided with DayBack Calendar.

  • DBk_ColorCalc
    • Your events in DayBack are color-coded based on their status or any field you map to "Status." If you'd like these colors to be visible on other layouts outside of DayBack, this text field can help. It reads the status colors configured in DayBack and displays them on your FileMaker layout. You can see this in action on the "Event List" layout in DayBack.
    • This field may be commented out when you paste it into your table. Remove the /* comment tags */ and replace the reference to "Status" with the field you've mapped to Status in your table.
    • Set the "Evaluate this calculation from the context of:" dropdown to the same table occurrence you’re using for DayBack.
  • DBk_EventSummaryCalc
    • This calculated field formats how your events appear in the calendar before you click on them. Refer to the example in DayBack's SampleEvents table. This is the field you'll customize if you want to add icons or other details to your event summaries.
    • Set the "Evaluate this calculation from the context of:" dropdown to the same table occurrence you’re using for DayBack.

Auto-Enter Options for Time Fields

    • The TimeStart and TimeEnd fields in SampleEvents_DayBack have auto-enter calculations that you may want to apply to your time fields. These are particularly useful for handling times that fall at midnight, making time management easier in your records.