Filter based on related record or calculated field

Mods, Tips, Tricks, and Support for Zulu
Posts: 49
Joined: Fri Feb 27, 2009 2:49 pm
PostPosted: Tue Apr 23, 2013 6:06 am
I would like to filter based on a field in a related record. Basically the name of the location where the event in the event table is occurring. Does this value have to be in the event table, or can it be 1 or more relationships removed? Or calculated?

Thanks,
Darren Burgess
Posts: 49
Joined: Fri Feb 27, 2009 2:49 pm
PostPosted: Tue Apr 23, 2013 6:18 am
Nevermind! Seems to be working.
SeedCode Staff
SeedCode Staff
Posts: 691
Joined: Mon Feb 28, 2011 2:47 pm
PostPosted: Tue Apr 23, 2013 9:07 am
Hi Darren,

Technically, you can use a Related Record as the filter, but I would advise against it. If the event is moved from one calendar to another in iCal, then the value in the RELATED record and not the event record will be changed and that could be disastrous. If you're doing Read-Only subscriptions, then it's probably ok.

All Zulu fields need to be editable so you can't use a calculation field for this, but an auto-enter calc in the event table, or a field populated by a script trigger is the way I'd go.

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: