See Video Below, its early so sorry for the fumbling of words a bit but I am sure my point is clear…Thank you!

If you want the first Owner column to contain the signed in users email address, use the special User Profile value: [CleanShot 2023-08-13 at 17.06.22@2x] Then use the hidden text input to add the value for the second owner column. That should work - at least it does when I test it. If it’s not…

First and most important thing to understand: Row Owners can only be applied to non-computed columns. So - all the ideas you have about row owners filtering through relations to other tables. Forget about it. It won’t happen. This also means that you can’t create an array column in a Glide Table a…

do you think i can have two email addressess seperated by something in the cell and it make ti the row owner? Or what about if I have mulitple roles? can i have multiple roles for the staff in one cell seperated by soemthing s that multiple role levels have access?

No. Row Owners looks for exact matches to a user’s email or role. Putting multiple values in one column is going to make it not match. The ONLY array that will work is one derived server side from a google sheet with sequentially numbered columns. That’s it. If you need multiple row owners on a…

Using the structure you’ve outlined, how do you then use an ARRAY to auto-add Staff on each row? The documentation suggests this but is very unclear. I’ve tried for weeks adding ARRAYFORMULA columns in Google Sheets but can never seem to work out the exact formula. I’d like the same role applied to…

What does your arrrayformula look like currently?

[image] Cameron_White: Using the structure you’ve outlined, how do you then use an ARRAY to auto-add Staff on each row? You don’t. [image] Cameron_White: The documentation suggests this but is very unclear. I’ve tried for weeks adding ARRAYFORMULA columns in Google Sheets but can never s…

Thanks for the quick response. The text input with the default value is the way to go for sure. However when I do this solely for row owner 2, it stops listing the current user automatically under row 1. Thats cool, so I add two text inputs for owners 1 & 2, then it defaults to the current user for …

Awesome thanks that works :slight_smile:

Row Owners Array Help

Ask for Help

Topic		Replies	Views
Can't Make Array a 'Row Owner' Ask for Help	12	702	October 28, 2022
Unable to set array as Row Owner Ask for Help	3	329	November 24, 2022
Row owner - I don't get it Ask for Help	13	1065	January 17, 2024
How can I use the row owner with multiple emails? Ask for Help	13	520	February 7, 2023
Multi row owners column LIKE ARRAY Feature Requests	19	531	May 25, 2023

Row Owners Array Help

Related topics