portal filtering: help with an IsEmpty calculation
Products is a table in my database and Designer is a field in that table. From my Products table I have a portal to another TO of Products, Products2.
I'd like to filter out the records from this portal that have a blank Designer field, so only the related records with text entered in the Designer field appear in the portal.
Can someone help me with the calculation to achieve this? I'm assuming it has something to do with the IsEmpty function, but I can't quite figure it out.
Thanks so much!
I can only assume you have a workable relationship between Products and Products2.
Layout is based on Products and Portal is based on Products2?
If so, Not IsEmpty ( Products2::Designer )
should filter out all related records where the Designer field is empty.