Filtering Filters

Support for our integrated Contact Manager, Calendar, and Project Tracker.
Posts: 35
Joined: Tue Nov 25, 2008 11:49 am
PostPosted: Wed Dec 12, 2012 4:14 pm
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
SeedCode Staff
SeedCode Staff
Posts: 2764
Joined: Thu Nov 20, 2003 11:01 am
PostPosted: Thu Dec 13, 2012 2:19 pm
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
John Sindelar
SeedCode

Return to SeedCode Calendar

Who is online

Users browsing this forum: No registered users and 1 guest

(855) SEEDCODE
[email protected]
Follow us: