Roles of users for the data in the database

I use something like this example a music studio to sign up students for recitals (it helps build a recital program from the entries). Every teacher can input entries, but they can only edit their own:

https://anvil.works/build#clone:KKP7UJHIW2OSSFMD=BHBZCQVOISPTOA3QCWOWWDM4

Something I do is create a separate app for admin, using the data table shared from some app like the one above. It’s important to know that when you share data tables between apps, the form permissions are per app (you can keep your data tables locked down in the app above, but make them fully editable from front end code in the admin app). That makes it really easy to create a simple CRUD admin panel that allows users of that second app to change anything in the database, using something like these examples:

2 Likes