I have two tables in my app that are related. The ACCOUNTCARD table has one or more related ACTIVITIES. As a result, the ACCOUNTCARD table has a virtual column called “Related Activities” that is a List type, with the following formula:
All works great as the Accounts detail view shows the “Related Activities” records as a table. But what I really want is to only show the “Related Activities” records where State=“Open”.
So… Is is there a way to modify the above REF_ROWS formula to select only records where State=“Open”, or do I need to add another virtual column to Filter or Select from the “Related Activities” list?
I cannot seem to get the syntax right for either option so some example syntax would really help.