Dabble DB makes it easy to create views and forms that give different users access to different data with fine-grained control. Using a few key features, you can instill ownership of data and ensure that users can only view and/or edit the data that “belongs” to them.
Adding users
Access control only works for “pages-only users”. Users with access to the full database will be able to see all data.
Marking ownership
The first step to access control is to add a Dabble User field to the entries in the category to which you want to restrict access. A user field contains a single value, a username, which you can use to denote ownership of each entry.
Default ownership for new data
If you give the user field a default value of me, the system will automatically put the current username into the field when someone creates a new entry.
Assigning ownership to existing data
If you already have existing data, you may wish to assign ownership to a set of entries. The easiest way to do this is to create a view filtered to the set of entries you want to assign to a particular user, and then use the Actions menu to change the user field value for those entries.
Creating restricted-access views
Only Pages can offer restricted access to data. To create a view that shows only entries belonging to a particular user, add a filter for the user column. For dynamic access, give the filter a value of me. This means that the system will show only entries that “belong” to whoever is currently logged in.
After adding this filter, you will want to share the view as a page. Click Share and create a new page. In the Page settings, you will want to ensure that only registered users can access the page. Or you may choose to restrict the page to a particular list of users.
Edit and delete access
Pages created from a view only have read-only access by default. To allow users to create or edit data, add a form on the Edit Form tab of the page builder, and drag fields onto the form that you want users to be able to edit.
Check one or more of Create entries, Edit entries and Delete entries to control what permissions users of this page have.
If you want some users to be able to only view data and others to be able to edit, you need to create two separate pages.
