Page 1 of 1

Filter based on related record or calculated field

PostPosted: Tue Apr 23, 2013 6:06 am
by darrenburgess
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

Re: Filter based on related record or calculated field

PostPosted: Tue Apr 23, 2013 6:18 am
by darrenburgess
Nevermind! Seems to be working.

Re: Filter based on related record or calculated field

PostPosted: Tue Apr 23, 2013 9:07 am
by JasonYoung
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