Hey all, I’m trying to follow the instructions in this guide (see example 3) and this guide that show how to protect row contents by making an Array column for row-owners. Basically what I’m trying to achieve is this: The signed in user can access this row’s data So can anyone with the role ‘Adm…

Ah, I didn’t know that was the case. I thought you were creating the rows in glide. So, yeah, I’m not sure how you have it set up to feed stripe data into glide, but I think you have the right idea to just make it part of the API request. Fill one column with the email address, and fill another c…

I think what might not be clear in those guides is that the columns have to be structured with sequential numbering in a Google Sheet. It’s a very specific method. There is a reason that you can’t assign row owners to a column the way you are trying to do it. In glide, any computed column is actu…

I should also mention that an array created from sequential numbering in a google sheet may work in airtable and excel as well. I haven’t tried it though to say for sure.

This makes 100% complete sense, thanks for explaining that! I really, really wish the multiple guides on this topic mentioned that - since that’s a big limitation that I couldn’t have possible figured out myself. For your solution, is there a great way to make default-values in Glide? For example …

Are you able to see this post? [image] Row owners and roles in the same time? Ask for Help Hi guys, Can I have roles and row owners in the same time ? For example I would like to have all the users have their email address as row owners so the data is secured and also …

Yes! I saw that post, but admittedly it’s still not clear for me on the Stripe API → Pushing details into a new row (let’s say in a Stripe glide table). Ideally there would be a column where every new entry just had the text “Admin”. I guess I could use something like Zapier in-between to add that,…

Basically you just need two columns. One to hold the user’s email, and one to hold the Admin role value. Both columns can be row owner columns. I’m not sure if you need an admin row owner in the user profile. If so, you would probably need an onboarding process where the user performs an action …

Gotcha. How would that work with data being pulled into a glide sheet from an API? So for example each time someone makes a purchase through Stripe, it feeds into a Glide sheet into a new row. But most of these purchases aren’t tied to a user in my tables. So when it comes in, it wouldn’t have any…

Awesome - thanks Jeff! :pray: Glide team - please clear this up in the guides if possible. I was pounding my head against my desk trying to figure out what I was doing wrong here.

@JackVaughan may need to clarify that in the docs that array columns derived from sequentially numbering columns can only happen in external databases.

Completely agree we need to update this. Sorry for your trouble @Justin_V and thanks as always @Jeff_Hager . I’ll get this one bumped up the priority list.

Can't Make Array a 'Row Owner'

Ask for Help

Jeff_Hager October 26, 2022, 11:57pm 5

Are you able to see this post?

Topic		Replies	Views
Unable to set array as Row Owner Ask for Help	3	334	November 24, 2022
Row Owners Array Help Ask for Help security , row-owners	9	767	August 13, 2023
Unable to set an Array column as row owner Ask for Help	7	444	July 26, 2022
Applying "Row Owner" to Array columns in Glide Pages? Ask for Help	6	606	December 19, 2021
Row Owners and Dynamic Arrays Ask for Help	10	454	February 6, 2022

Can't Make Array a 'Row Owner'

Related topics