Second filter

Mods, Tips, Tricks, and Support for Zulu
Posts: 18
Joined: Sat Jul 12, 2008 9:09 am
PostPosted: Mon Oct 31, 2011 5:41 am
Hi,

Can I add a Second filter? I currently have a filter that cuts calendar items down to 400-500 items (Status "Not Done"). I'd like to have a second filter (Department Name or Project Manager) that I could apply. In that case I could create a new TO of the table and apply the second filter and have a calendar to each Department or Project Manager. Possible?
SeedCode Staff
SeedCode Staff
Posts: 2764
Joined: Thu Nov 20, 2003 11:01 am
PostPosted: Mon Oct 31, 2011 6:53 am
Hi,

Zulu only supports one filter, so you'd want to create an auto-enter calc that returned the Department Name or Project Manager if the status was "Not Done", combining your two criteria into one filter so you get one calendar for each Department / Manager.

Hope that helps,

John
John Sindelar
SeedCode
Posts: 18
Joined: Sat Jul 12, 2008 9:09 am
PostPosted: Mon Oct 31, 2011 8:24 am
Thanks John,

I saw something in the help docs about avoiding calculated fields. I'll run with this.
Happy Halloween
SeedCode Staff
SeedCode Staff
Posts: 691
Joined: Mon Feb 28, 2011 2:47 pm
PostPosted: Mon Oct 31, 2011 9:14 am
Hi Martin,

Auto-Enter Calculations should be ok, just not calculation fields, as the filter field needs to be writable. You may want to check this video out as it looks at filtering and auto-enter calcs:

http://www.youtube.com/watch?v=jfgYnHzakvA

hth,
Jason

Return to Zulu: iCal Server for FileMaker

Who is online

Users browsing this forum: No registered users and 2 guests

(855) SEEDCODE
[email protected]
Follow us: