this could be simple, my brains is just blocked late at night I have a column in Google Sheets with words separated by a comma example 1: Admin, Main Admin, Accountant example 2: Admin example 3: black no data How can I make these 3 words or 4 words or sometimes 1 word only row owners in Gli…

Here you go. Formulas are marked in light red. Demo Array Demo Array Row Owners,Access/Row Owner 1,Access/Row Owner 2,Access/Row Owner 3,Access/Row Owner 4,Access/Row Owner 5,Access/Row Owner 6,Access/Row Owner 7,,,,,,,,,,,, Admin, Main Admin, Accountant,Admin,Main... …

Since computed columns cannot be row owners, you will have to modify your data in your Google Sheet to be multiple columns. Name the columns something like “Owner 1” “Owner 2” “Owner 3” Owner 4" and so on. Glide will pick them up as an Array Column, and you can make that Array Column a Row Owner. …

Thank you David. Yes I’m aware of what you mentioned. I’m just confused how do I modify data in such a column. Keep in mind, although most fields have 3-4 words, there is no constant length one field can have 100 words separated by a comma. I also have tens of thousands of rows, cannot manually i…

Although you will see the columns as an array in the Data Editor, you can still address the columns individually with a Set Column Values action. So you could have an Edit Form with a whole bunch of text input components, each addressing one of the Owner columns. Pretty awful, but I can’t think of…

[image] rayo: one field can have 100 words separated by a comma. I also have tens of thousands of rows, cannot manually input them. Well, here’s where a spreadsheet expert could help. You shouldn’t have to split the fields into multiple columns manually. There’s probably a spreadsheet wizar…

[image] Darren_Murphy: So you could have an Edit Form with a whole bunch of text input components, each addressing one of the Owner columns. That’s exactly how I did it in one of my apps. It really wasn’t that bad (I only had eight potential owners). It was for a genealogy, and once a relat…

Please note that you should put these at the very right end of your data so that when it grows, it has space to grow, and you won’t accidentally put a column between the generated columns.

[image] ThinhDinh: Demo Array - Google Sheets I really like this, @ThinhDinh ! I am more of an Excel user because of circumstances (I’m old), but I am growing to enjoy working with Google Sheets also.

The company I used to work for was an early adopter of GSuite in Asia back in about 2008. We pushed really hard at the time to get the whole company (about 1000 employees) off MS Office and on to GSuite. It was hard work and took the best part of a year, but once it was done we never looked back. I…

[image] Darren_Murphy: If somebody asks me to work with Excel, I politely say no I don’t have that luxury! :sweat_smile: :rofl: :joy:

Google Sheets Row Owner

Ask for Help

ThinhDinh September 28, 2022, 1:07am 7

Here you go. Formulas are marked in light red.

Glide security with data visibility in community app

Topic		Replies	Views
How to make multiple row owners? Ask for Help	16	1114	April 7, 2023
Row Owners via Dynamic Array Ask for Help	20	1997	April 17, 2021
Unable to set an Array column as row owner Ask for Help	7	445	July 26, 2022
Row Owners vs. Filters Ask for Help	16	973	January 14, 2022
Row Owners / Allowable Column Types Ask for Help	3	327	February 22, 2023

Google Sheets Row Owner

Related topics