Hey Glide enthusiasts! I’ve found a super useful ArrayFormula in Google Sheet that mimics a template column but with a twist. It is stored in a basic column, so it works perfectly with Row Owners! Here is the magic formula: Edit: [image] ThinhDinh: ={"Admin Access";ARRAYFORMULA(IF(A2:A <> "",…

I usually do it like this. ={"Admin Access";ARRAYFORMULA(IF(A2:A <> "", "Admin", ""))} This is assuming you will always have data in column A.

Be careful not to allow a user to delete that first row through the app interface. :stars:

Actually, no cell in that column should be removed: [image] [image]

Constant Role Assignment That Works Like a Glide Template Column!

MaximeBaker November 20, 2024, 2:59am 5

Actually, no cell in that column should be removed:

Yet another permissions / roles questin

Topic		Replies	Views
Can't Make Array a 'Row Owner' Ask for Help	11	779	October 27, 2022
Row Owners and Dynamic Arrays Ask for Help	10	491	February 6, 2022
Best Practice for creating a single value Role Column? Ask for Help	6	507	October 14, 2022
Admin Row Owner Ask for Help	12	617	December 8, 2021
Admin Access Using Glide Tables Only Ask for Help	3	348	July 13, 2021