Hi -
I have a data table for Projects and a data table for Members. One Project is connected to many Members.
I want to be able to see who the individual members are working with on projects. So, as an example, I want to be able to tell that Frank has worked with Mary 13 times, Bob 5 times, and has never worked with Paul.
Essentially, I want to be querying the Member field of my Project data table for a specific Member, then when found, splitting the results by the separator (in this case a comma), and then counting the resulting unique values and displaying them. So, on my Member Page for Frank, I want to display the following:
Member Detail (Frank)
Mary 13
Bob 5
(Note: I do not want to display all Members Frank has never worked with)
I am not sure how to manage this within Tadabase. It seems like I need a cross between a rollup and a custom equation but I haven’t been able to find a similar use case. Any ideas appreciated.