Hey @Darren_Murphy, thanks for your reply.
I just found some time to play around with it and managed to make it work for the Private App with Roles. However, I it is a bit tricky to achieve something similar with the clients app which is public with required signed-in.
Image that a user from the public app becomes a customer of the Company from the private app. Then the customer invites their colleague to the public app so they sign up and they should be able to have the same access to the Company data as the person who invited them. The number of users that can be invited is not know upfront so this should be dynamic.
I searched the community a bit and found that @ThinhDinh has a neat solution for this. In this the array formula is used in a very smart way and I believe the same logic applies to this example too. I sort of get how the array formula works, but what I am struggling with is where the data is being pulled from.
For example, let’s say that the user’s table there is a row with user-A.
- User-A invites user-B by zapier or integromat and a new row is created for user-B in the user’s table. Row owner is currently set on Email only so each user has access to their own data only.
- User-B joins and they have access to their own data too.
- Assuming now that the row owners array column is set up, how can I tell the array column that user-A and user-B should see the same data?
What else should I do when inviting users to build the relationships so the array column can work as expected? I know that computed columns are being calculated after all the data is downloaded so in this case this won’t work.