I have a table with an email column set as the row owner.
I want the user to be able to add a guest to a second column that is also set as the row owner.
Will that work? Or can this only be configured via the data editor?
Example
Customers table has a customer email and guest email fields.
However, in the cars table there is a relation to the customers table based on the customer email (Christina in my screenshot). Then I use a lookup to get the guest email (bobby in my screenshot). However, I cannot set that column as a row owner.
This post might have part of the answer but not 100% sure how to apply it.
Data structure is:
Users > Cars
I want to add a guest (another user) who has access to the same cars as User.
It will work, but you can’t use a computed column as a row owner.
So the guest email will need to be written to a non-computed column, and that column can be a row owner.
What if I want to add the row owner to multiple tables?
Conceptually I want a user to add a guest to their account (by updating a row owner column in the users table) and then that guest to access everything the user can access.
I thought of having a second role called “guest-[rowid of user]”/
not sure if that will work.
Yes, you can do that.
This is a different kettle of fish. You can pretty much do whatever you want with Row Owners when adding rows, but users cannot add or modify the roles of other users. The only way you could get that to work would be using the Glide API.