Sorting Events in FileMaker

How is the calendar sorted?

On most views events will show with all-day events first and then in chronological order, so adding a sort will really only apply to events that are either all-day or happening at the same time.

For those events that are all day or happening at the same time, DayBack renders the events in the order they're returned from the query. This means that, in FileMaker, since the query happens in a FileMaker script, you can specify a sort order for these events.

To add your own sort, edit the script "Find Events - DayBack" and add the following highlighted lines in the spot highlighted below. Note that sorts will slow the calendar down slightly... or not so slightly if you choose to sort on unstored fields.

If you're using WebDirect, then you'll also need to modify the SQL query that's used for this. The highlighted lines below show how to accomplish this with "ORDER BY".

If you're looking to sort events by a resource (by artist, room number, truck, etc.) you may want to check out the calendar's schedule views as they give each resource their own column, making sorting less necessary. More on using resources here: resources.

Additionally, the Horizon view has a Breakout By option that is very useful for grouping events.