Hi, I have read several posts about this but they skirt around the actual issue I need to know about. In SQL, if you do a query, the result set is only the records you specified. I was thinking of filters that way as well. But I saw one post that alluded to the fact that ALL records are sent to t…

As far as filters are concerned, everything is done client side. About the only client/server interaction is to synchronize data changes between glide’s copy of the database and the client’s copy of the database. Row Owners are a security feature which restricts which data is sent to the client in…

So, I had a “share with” column where they could enter comma-delimited email addresses. I was using a filter. I’ve now set up an “Owner” array in my Google Sheet. Is there any way to “split” the one field into the Glide “Owner” array, or would that be considered a computed column? Also, I have a…

I am really not understanding how the Glide editor uses these Google Sheet “arrays”. I removed the “owner 1, owner 2”, etc. and added “row owner 1, row owner 2”, and now I see the array, but none of the individual columns are available in the Glide editor to modify. They can only be modified in th…

[image] It wasn’t working with your first setup because you have two “Owner 2” columns here. As long as you put “Owner 1”, “Owner 2”, “Owner 3” etc next to each other in the sheet then you should have an array. If I recall right, you’re correct that there’s no way to modify it using the data view…

[image] ThinhDinh: If I recall right, you’re correct that there’s no way to modify it using the data view, but if you want your users to modify it, you can just add email entry columns in the edit screen of each row. Yes, I did notice that. My question then, is can I have them enter the valu…

[image] David_Gabler: Hmmm, and I can see them as selectable when I add an Text Entry component, but since I cannot modify them in the data editor, I cannot change their “type” to “email”. [image] Did you add Row Owner 4 through 9 via the Glide Data Editor? The reason they are not the corre…

[image] David_Gabler: Yes, I did notice that. My question then, is can I have them enter the values comma-delimited in one field and “explode” it out into the array instead of having 5 or 6 different entry fields? That’s an interesting challenge. I think it would be possible if you were usin…

[image] Darren_Murphy: The reason they are not the correct type is most likely because they are not part of a single contiguous block of columns, Thanks, I found they were not the correct type because they had no data in them. Once I added email addresses to the first row, they were found t…

[image] Darren_Murphy: If you were using a native form, then I think the only option would be to manipulate the data in the Google Sheet, using a bit of apps script or an arrayformula. I guess it’s not worth the time for a custom form. This particular app feature is for the benefit of the en…

Actually, the first option that I described (split text/single values/set column values) might work as an On Submit action with a native form. Not something I’ve tried, so I can’t say for sure. But probably worth a try.

Thanks. I’ll try it after I get rid of some of the glitches I introduced by having to make true row owners instead of filters (and moving to a google sheet at the same time). I’ve made too many changes in two days! LOL!

Row Owners vs. Filters

Ask for Help

Darren_Murphy January 14, 2022, 4:37am 17

He means Google sheets. This might help with the terminology.

Topic		Replies	Views
Applying "Row Owner" to Array columns in Glide Pages? Ask for Help	7	605	December 20, 2021
Unable to set an Array column as row owner Ask for Help	7	444	July 26, 2022
Row Owners Array Help Ask for Help security , row-owners	10	766	August 13, 2023
How to make multiple row owners? Ask for Help	16	1104	April 7, 2023
Row Owners from Array Ask for Help	7	305	May 25, 2023

Row Owners vs. Filters

Related topics