I'm sorry if I am missing something here. I read about app reference filtering and we use it but I still feel it misses some important functionality.
I understand that I can create a view with a static filter like "where status = open". But what if I need a "dynamic" filter like "where company = my currently selected item" ?
E.g. I have a contacts app and a companies app. Every contact belongs to a company (i.e. has a reference) and all contacts are referenced automatically in the connected items. Now in the company app I want to have fields like "CEO" or "sales contact" where I want to reference one of the contacts which belong to this very company. I clearly cannot have a view for every company :)
Another example - we also have an app where all the branch offices are maintained. Each office belongs to a company. Now in the aforementioned contacts app I want to connect the person with the branch office she works at. Here again I want the reference lookup to only show branch offices belonging to the company the person works for.
Any idea how I can achieve this?
Please sign in to leave a comment.