SeedCode Support Forum

Hi,

Is there a way I can have the events in the Month view sorted by Resource (or a separate Sort Field I create) and then Chronological order, have searched throughout the database, but I must confess the inner workings of this area leave me totally confused (to say the least!).

Many thanks

Crispin

The sort is controlled in the script called "Sort FileMaker Records --- Edit Sort Orders Here ---". This is one of the two configuration scripts you visit when you integrate the calendar with your work.

But I'm not sure you'll be able to do this. Events have to be sorted by chronological order first in order for us to write the calendar. AFTER the chronological sort, you add any criteria you'd like (I'd make sure that you're sorting on indexed fields unless you want to see a real performance hit).

So if you don't have times for your events, then just adding a Resource sort after the date/time sort that is there should work great: for all events of the same date they'd sort by resource.

But if you do have times then I'm afraid that won't work since it will sort by date/time first and only events with the same time will be sorted by Resource.

You could try branching this sort script so that you leave out the time when sorting on the Month view. The If() test would be $$sc_Mode = Month

Then you could have the month just sort by Date then Resource, having all other views sort by Date/Time. Don't know if that will work for you, but it's worth a try.

Many thanks John, will give this a try...