Sorting Events in FileMaker

How is the calendar sorted?

In most views, events will display with all-day events first, followed by events in chronological order. Sorting will primarily affect events that are either all-day or occur at the same time.

For events that are either all-day or simultaneous, DayBack renders them in the order they are returned from the query. Since this query is executed within a FileMaker script, you can customize the sort order directly in FileMaker.

Adding a Custom Sort

To implement your custom sort, you'll need to edit the "Find Events - DayBack" script and add the highlighted lines where indicated. Be aware that adding a sort may slow down the calendar, especially if you're sorting by unstored fields.

For WebDirect users, you'll also need to adjust the SQL query used for sorting. The highlighted lines show how to achieve this with an "ORDER BY" clause.

Sorting by Resource

If you need to sort events by a resource, such as an artist, room number, or truck, consider using the calendar's schedule views. These views allocate a separate column for each resource, reducing the need for sorting. You can learn more about using resources here: resources.

Additionally, the Horizon view offers a "Breakout By" option, which is very useful for grouping events.