Repeating Events in FileMaker

Each repetition in the calendar is its own event record. These records are all tied together with a shared event id in the field "SampleEvents::DBk_Repeating_id". You can script a find on this field to bring all the repetitions of an event into the found set.

Once repetitions are created, the individual events can be edited, moved, or deleted without affecting other events in the repetition.

If you want to change all the repetitions of an event at the same time--or delete them all--click n an event in the calendar view and then click the "repeat" button on the "Event Detail" layout. You'll be offered an option to see the repetitions of that event in a list.

From there you can there use the Replace Field Contents command from FileMaker's Records menu to apply changes across the found set. (Put your cursor in the field you wish to edit- and perhaps make your edit- before selecting "Replace Field Contents" from FileMaker's Records menu.) You can also perform a find on the event's DBk_Repeating_id field, as that is the key that binds repeating events together.

Note:  In order for the "repeat" button to work, you must arrive at the "Event Detail" layout from the calendar, as we show in our video above.

Using repeat functionality manually

Out of the box, the repeat scripts expect details on your source's field mapping to be set by DayBack in the $$DBk_Values variable, but you can set this manually. This will allow you to use the repeat scripts when opening your event detail layout from a custom button action or elsewhere.

Keep in mind that the new events aren't actually created until the "Close And Update Event - DayBack" script is run. So, you'll either need to run that script after creating the repeat rule or trigger the event creation yourself by pulling the relevant script steps out of that script.

Here's an example script that sets the $$DBk_Values global variable with the necessary field mapping information for the repeating scripts to work. Be sure to replace the SampleEvents_DayBack fields in this script with the appropriate fields in your event table.

I can't seem to create repeating events past 2029, is there a limit?

Yes. To prevent the accidental creation of millions of records, the calendar's repeating events script has both a date limit and a number-of-repetitions limit. You can change both of these but they default to a date limit of no repetitions past Jan 1 2030 and a limit of 500 repetitions per event.

Change these by altering the first two variables declared in the script "Build Repetition List ( Repeat_StartDate ; Repeat_Rule )"