Filter Zulu on two fields?

Mods, Tips, Tricks, and Support for Zulu
Posts: 4
Joined: Fri Aug 31, 2012 10:56 am
PostPosted: Tue Sep 11, 2012 5:58 am
Is it possible to setup two zulu_filterkeys for a Calendar? I have it Filtering by user, this works well. I would like to add a separate calendar based on the same table that Filters by user and status. So that the user see all of his items that are late.
SeedCode Staff
SeedCode Staff
Posts: 691
Joined: Mon Feb 28, 2011 2:47 pm
PostPosted: Tue Oct 09, 2012 10:58 am
Hi Bruce,

Sorry for not responding to this post earlier. We had some trouble with our mail notifications that new posts came in, and a few got by us :shock:

Unfortunately you can't do this. One possibility is to use a multi-line value in the filter field and search on it that way, i.e. concatenate the user and status into a single value.

hth,
Jason
Posts: 8
Joined: Sun Sep 21, 2008 10:49 am
PostPosted: Wed Oct 24, 2012 6:19 am
I'm using a multiple-value filter with good results. Created an auto-enter calc field that concatenates the results of two other calculations. One has to force that calc to fire of course. For each record in the zulu calendar list, I fill in the staff ID, the bar separator (which is in my auto-calc), and the desired value of the second filter.

One could do this with as many values as you wanted; but rather than do that, I've combined multiple tests into the second underlying calc and specified a binary result, so that the desired filter is always of the form nnnn (staff ID) bar 1.
Brian W. Smith
Winslow Tech
SeedCode Staff
SeedCode Staff
Posts: 691
Joined: Mon Feb 28, 2011 2:47 pm
PostPosted: Wed Oct 24, 2012 7:07 am
Thanks Brian,

Good stuff!

Return to Zulu: iCal Server for FileMaker

Who is online

Users browsing this forum: No registered users and 3 guests

(855) SEEDCODE
[email protected]
Follow us: