Feel I may be hitting a wall with Glide and this query.
I’ve just finished an app I’ve put together for property management that stores assets, tenants and signed agreements. Its pretty simple and neat, makes life very easy.
I assumed via Glide I could market the app with subscribers, adding them as users. Except I’ve realised that none of my columns are custom user. I duplicated my app, redoing all my columns only to discover that new users can still see the data within the tables, the rows are just blank. The blank rows can still be deleted.. which means all data is easily removed and therefore compromised.
Am I missing something or is Glide just a bad interface to be executing this type of app? I’ve spent months getting the app perfect, and it seems the only way to fully allow separate users is by selling the template. Which is fine, but seems a big miss of opportunity.
If each user will have their own rows, then you should be using Row Owners instead of User Specific Columns. Only use user specific columns if multiple users will be updating the same cell in the same row with unique values to each user.
1 Like
That would be a perfect solution but I find that when use this feature, my roll-up columns still counts everything, including data that is greyed out.
OH! Interesting, when I click on layout, it seems to only see the user data… do I just ignore that it appears wrong in the data tables?
Rollups won’t count other user rows in the published app. It only appears that way in the data editor because you can see all rows. Only rows owned by the user are accessible to the app.
2 Likes
Amazing, I’ve been trying to work this out for days. I can’t believe it was that simple - thank you. Final query, when I add users, theres no way for them to gain access to the backend tables etc… they only ever see the published layout app?
Technically a user could gain access to any data not protected by row owners if they know how to do it. The app works by downloading data to the device and only syncs data changes back to Glide. That’s what makes the app so responsive and quick.
If a user should not have access to certain data, then that data should be protected with Row Owners.
1 Like