I have a scenario where an “admin” within the app would like to assign multiple users as row owners in a specific sheet. The number will vary so I cannot use the Email 1, EMail 2, Email 3 approach as suggested in the past by the likes of @ThinhDinh, @Jeff_Hager and @Robert_Petitto. Has anybody come up with an approach that solves this one yet? Thanks all.

I think you have 2 ways to deal with this: 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 don’t think your 2nd point will work: [image] new Security Center Announcements You cannot assign computed columns as Row Owners yet—only basic columns of emails, or arrays of emails.

Can’t you use Google sheets to do the split?

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.

I’ve tried it for some other purpose not emails. It’s making an array + split function. Only caveat is the number of emails can’t exceed the planned array columns.

I’d be interested to see it in action if you get it working. Post some screenshots afterwards. Could be helpful for others too.

[image] kyleheney: 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!). We can do it, I have done this before.

Guys. Thanks so much for the rapid input. This was of interest in particular: [image] new Security Center Announcements You cannot assign computed columns as Row Owners yet—only basic columns of emails, or arrays of emails. 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. So … it can’t be done?

It can be done. I have done the “column name in advance” part before. Let me find it and send back to you.

Here you are. The formula inputs new column names in an array style when new values are added that increases the max number of columns required. Thinh Dinh's lab V2.0 Robert Test Project,Task,Project,Task,Combined A,siLxzsQURZK3QGl0Zhqg7w, yLz8ofPiQrC8Y6BYfpm.CQ,A,siLxzsQURZK3QGl0Zhqg7w,A - siLxzsQURZK3QGl0Zhqg7w jRzXZcVgQruv37w-gFQ6Kg, zp5bp3uIQoWwJYAH0a-vgQ,yLz8ofPiQrC8Y6BYfpm.CQ,...

Row Owners via Dynamic Array

Ask for Help

kyleheney October 1, 2020, 10:11am 3

I don’t think your 2nd point will work:

Topic		Replies	Views
Row Owners and Dynamic Arrays Ask for Help	10	519	February 6, 2022
How to make multiple row owners? Ask for Help	16	1183	April 7, 2023
Unable to set array as Row Owner Ask for Help	3	373	November 24, 2022
Unable to set an Array column as row owner Ask for Help	7	483	July 26, 2022
Can't Make Array a 'Row Owner' Ask for Help	11	817	October 27, 2022

Row Owners via Dynamic Array

Related topics