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

Nevermind! Seems to be working.

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