This is my example. I have Height_Relation, which is used by Support_Post_Interval as a lookup value reference. I then use Support_Post_Interval in a Math formula in a different column (“plus 10” in example). I want to prevent other users from accessing the Support_Post_Interval column, but still be able to display the calculated column.
What do you mean by "access"m. Do you mean hide from view on the screen? How are you displaying it on the screen? You can add, remove, or modify any commitments in the screen any way you wish.
When watching one of the glide guide videos, I remember them saying “Filter is not a security measure. The users may not be able to see it, but the data is still downloaded onto their device.”
Based on this I assumed that it works the same way with these columns — just because I don’t display it on their screen, the data might still be downloaded onto their devices. I want to prevent this. I don’t want this “confidential” data to be downloaded by end users.
Each of the columns shown in your screen shot is a computed column. Computed columns are evaluated locally on each users device. In order for those calculations to work, the source (non-computed) data that is referenced by those computed columns must be present on the users device.
The only way to get around that would be to store the data elsewhere, and use API calls to fetch the results.
2 Likes