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 Glide?
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. You will not be able to maintain your owner columns in the data editor separately, but you should be able to set up a custom form to maintain them through Glide.
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 input them.
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 a better way to do it off the top of my head.
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 wizard that can do it for you. But I don’t know enough about Excel, and I know even less about Google.
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 relative is entered into the system, I wanted them to be sharable to other relatives who were also users of the app.
Thank you very much!
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.
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 haven’t touched Excel since that time (or anything MS, actually), and I refuse to. I’m sure it’s a lot better than it was back then, but I’m just not interested. If somebody asks me to work with Excel, I politely say no and refer them to somebody else 
I don’t have that luxury! 
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.
