Filters

You can point the existing filters at any fields in your events table that you'd like. Mapping filters to fields is done in the "Load Calendar Settings - On Startup..." script you edited as part of your [[integration]].

Filters are available on the Filters tab in the left hand status area. SeedCode Calendar ships with three filters in place already: title, status, and resource. To see how this works, select an item in the status filter and you'll see the calendar change to show just the items of that status. Note that you can select more than one status in the filter.

Now click "Omit" beside the filter and you'll see everything ''except'' events of the status you've selected.

The title filter works the same way: type in "Call" and you'll see all the events where a work in the Summary begins with "call". These filters works just like the "constrain found set" find request you're already familiar with in FileMaker.

Sure. Let's say you wanted to add a filter called "Staff" so you could see just the events for one or more staff members (for just you, or for the members of your team). Here's how you'd do it...

-> '''1.''' Create a staff name field in the events table.

-> If you don't already have a field in your events table for the staff member's name, create one. For the sake of this example we'll use the staff member's name as the filter, but you could use their ID, etc.

-> '''2.''' Create a value list for staff names. Then create a global text field in the CalendarInterface table called FilterGlob_4

-> '''4.''' Duplicate (copy and paste) one of the existing filter fields on the layout and then switch this field to be FilterGlob_4. Format this field to use the value list you created in 2 above; format it as checkboxes if you'd like to support multiple selections.

-> '''6.''' Still editing the Filters tab of the Calendar layout, duplicate the "clear", "include", and "omit" buttons, placing them next to your new filter and change the script's script parameters for each of these buttons to use the "number" of the field ("4" in our example). Edit the conditional formatting for each of these to use the new filter number ("4" in our example).

-> '''7.''' Finally, edit the script "Load Calendar Settings - On Startup..." and find the comment "Maps filters to fields". Create a new SetVariable line for your new filter ($$sc_FilterField4 in our example) and, using your new field for the GetFieldName (GetFieldName ( SampleEvents::StaffName) in our example ).

-> '''8.''' Enter browse mode and run the Upon Opening script again and you're done. If you've added more than 5 filters, edit the script "Apply Filter to Found Set" and change the first variable there to be the number of filters you now have.

-> '''6.''' Still editing the Filters tab of the Calendar layout, duplicate the "clear", "include", and "omit" buttons, placing them next to your new filter and change the script parameters for each of these buttons to use the "number" of the field ("4" in our example). Edit the conditional formatting for each of these to use the new filter number ("4" in our example).

-> '''6.''' Still editing the Filters tab of the Calendar layout, duplicate the "clear", "include", and "omit" buttons, placing them next to your new filter and change the script parameters for each of these buttons to use he "number" of the field ("4" in our example). Edit the conditional formatting for each of these to use the new filter number ("4" in our example).

-> '''8.''' Enter browse mode and run the Upon Opening script again and you're done.

-> '''2.''' Create a value list for staff names

-> '''4.''' Duplicate (copy and paste) one of the existing filter fields on the layout and then switch this field to be FilterGlob_3 (if you've already used that field create a global text field in the CalendarInterface table called FilterGlob_4). Format this field to use the value list you created in 2 above; format it as checkboxes if you'd like to support multiple selections.

-> '''5.''' Edit the script trigger for this field, keeping the script the same but changing the parameter to be the "number" of the field ("3" in our example).

-> '''6.''' Still editing the Filters tab of the Calendar layout, duplicate the "clear", "include", and "omit" buttons, placing them next to your new filter and change the script parameters for each of these buttons to use he "number" of the field ("3" in our example). Edit the conditional formatting for each of these to use the new filter number ("3" in our example).

-> '''7.''' Finally, edit the script "Load Calendar Settings - On Startup..." and find the comment "Maps filters to fields". Create a new SetVariable line for your new filter ($$sc_FilterField3 in our example) and, using your new field for the GetFieldName (GetFieldName ( SampleEvents::StaffName) in our example ).

Filters are available on the Filters tab in the left hand status area. SeedCode Calendar ships with two filters in place already: title and status. To see how this works, select an item in the status filter and you'll see the calendar change to show just the items of that status. Note that you can select more than one status in the filter.

-> '''4.''' Duplicate (copy and paste) one of the existing filter fields on the layout and then switch this field to be FilterGlob_3 (if you've already used that field create a global text field in the CalendarInterface table called FilterGlob_4. Format this field to use the value list you created in 2 above.

-> '''6.''' Still editing the Filters tab of the Calendar layout, duplicate the "clear", "include", and "omit" buttons, placing them next to your new filter and change the script parameters for each of these buttons to use he "number" of the field ("3" in our example).

-> '''7.''' That' it.

- '''7.''' That' it.

-> '''3.''' > > Continue...

-> '''3.''' > > Continue...

-> '''3.''' Create a Staff field.

-> If y

Now click "Omit" beside the filter and you'll see everything ''except'' events of the status you've selected.

Sure...