Page 1 of 1

Filtering Filters

PostPosted: Wed Dec 12, 2012 4:14 pm
by wbullard
In Load Calendar Settings On Startup, I have set $$scFilterField[4] to SampleEvents::ProjecRecordID, but I only want my active projects to show up in this filter as opposed to all projects. How can I do this?

Thank you for answering yet another silly question,
Will

Re: Filtering Filters

PostPosted: Thu Dec 13, 2012 2:19 pm
by John Sindelar
Create a relationship from CalendarInterface to Projects that is true only for active projects. Then use that relationship in the "Projects" value list instead of the way we have the value list now (showing all projects).

To make the relationship, you may want to create a calc field in CalendarInterface equal to "Active" or whatever is in the field in your projects table that indicates active.

Hope that helps,

John