If your app is on a paid plan you can now use protected columns. Protected columns allow you to add an extra layer of security to your data. How does it work? Mark a column as protected and Glide will hide it, making it impossible to be loaded inside your app or the Data Editor.
Letâs say you want to onboard users, asking for sensitive data, but you donât plan on using the data in your app (SSN, Address, etc). This info can still be collected in the spreadsheet without using it in the app.
Or, if youâre using a massive spreadsheet filled with lots of unneeded data for the app, make all those protected and Glide wonât download the data theoretically making the app lighter?
Yup. I see that. Just watched @JackVaughan video too. Quite useful. Letâs see how this all pans out but it seems a very positive step in the right direction.
To clarify, Glide can read (and write) everything in your Google Sheet, even columns you mark as protected. When you mark a column as protected, Glide prevents apps from reading that column.
Glide is the thing that protects Protected Columns, so in other words, it controls them. Google Sheets would have to offer a Protected Columns feature itself, if your goal was to prevent Glide from reading the data entirely.
We will make this clearer in the documentation and video.
So just to be clear, this is purely a security feature and has no incremental performance benefit, correct? I.e., not intended to âprotectâ computed columns to speed up an app.
If the app is using Glide Tables only, is there a way to prevent local instances of a public app from downloading certain tables that arenât used for the interface? In my case I made a custom form with user specific columns and am writing a name and email address to a separate Glide table. Now my concern is that this table gets downloaded to everyoneâs device when opening the app.
Iâm thinking that through Zapier I can write these details to a Google sheet that isnât used by the app, instead of the Glide table, but Iâd much rather just mark the Glide table as âprotectedâ to prevent the data download. Of course, I donât want the cells obscured thoughâŚ
Could you use Row Owners for this purpose? This way, only the rows with the individualsâ email address would be downloaded to their device. You could also add another column that is a Row Owner and add in an administratorâs email address so that they can maintain access to all rows of data.
I tried this just now - I made an âAdminâ column in the table I want to protect, put my email address in it, and made it Row Owner, but suddenly the data disappeared from the cells, except for the RowIDâs. This seems like itâs okay, except when I change the âviewing asâ to my email the data doesnât reappear. I need to test this againâŚ