Have a very crazy amount of columns in the array (like 10 or something), use the old method of setting row owners.
Let people input emails in a text component but you must make sure you either let them separate two emails by (", " or “,”), then use a split text and set that split as row owner. I haven’t actually tried this, just a wild idea.
I suppose you could, but you’d still need to give your columns a header value (I’m not sure if that can be done dynamically in sheets with some sort of horizontal Arrayformula — never tried!).
Actually I guess pre-naming a bunch of columns is easier than creating all the separate fields in Glide, so this might end up quicker/easier as long as all the emails are separated properly in the first column using a common separator.
Guys. Thanks so much for the rapid input. This was of interest in particular:
So I guess I need to somehow create a mechanism that will dynamically populate an array column of emails. As I understand it, you can’t do this in the data editor (a relation is computed). You also can’t do it in a Google Sheet because you’d need to specify the column name “in advance” i.e. Email 1, Email 2 etc.
To back up @ThinhDinh’s idea, I believe it’s true that you can add additional columns to an array without having to touch the app builder, and glide will recognize it automatically. They just need to be consecutive and next to each other. In situations like this, it’s best to put the arrays as the last columns to allow for growth. Don’t hold me to it though. I kind of remember trying it a year or so ago.
hey @ThinhDinh - I’m checking out your sheet. Any specific reason a new name doesn’t populate unless a new value is added to row 4, not 2 or 3? Does this formula have a max? I can see that w/o column A it stops at 11 items.
@ThinhDinh how strange - a copy of this sheet was behaving differently (PM’d you a link). This one works. Thanks for concocting this!
@V88 have you put this to test? How’s your admin assigning? It a nice solution when you’re working with a manageable number of row owners, switching on/off row ownership manually, and duplication is not a concern. Something to build on for sure.
Is there any way to now do this via native Glide features?
I have items that I would like to assign to groups of users using row owners (for security purposes), but the groups will change dynamically. Ie. Users can add remove viewers of the item.
For now I have just removed row owners in my sheet and am filtering the item view based on whether the logged in viewer has permission. But I understand this isn’t secure nor speedy if the item list gets long?