Filtering Filters
Posted:
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
Posted:
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