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 …

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 …

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, s…

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 mech…

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…

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	454	February 6, 2022
How to make multiple row owners? Ask for Help	16	1113	April 7, 2023
Unable to set array as Row Owner Ask for Help	3	335	November 24, 2022
Unable to set an Array column as row owner Ask for Help	7	444	July 26, 2022
Can't Make Array a 'Row Owner' Ask for Help	11	705	October 27, 2022

Row Owners via Dynamic Array

Related topics