The Access Rights to your sheet determines the group of users that can view, modify, and add to the data on your database sheet.
Here is a comparative table for each of these assigned rights can do:
| Setting | View | Create | Modify | Description | Level |
|---|---|---|---|---|---|
| No Rights | Nothing | No | No | Will not be able to see this sheet at all. | |
| Survey User | Entries created by yourself or assigned to you | Yes | Entries created by yourself or assigned to you | Will be able to create, view and edit their own entries, won't be able to see other entries. Additional "no create" or "no edit" options can be set. | ** |
| Viewer | All entries | No | No | Will be able to view all entries and entry details, won't be able to edit or create new entries. | *** |
| Bulletin User | All entries | Yes | Entries created by yourself or assigned to you | Will be able to create and edit their own entries, and view all other entries. Won't be able to edit entries that they don't own. Additional "no create" or "no edit" options can be set. | **** |
| Admin | All entries | Yes | All entries | Will be able to create, edit, and view all entries in the sheet. | ***** |
Having different access rights are useful for different user groups to see different versions of the same sheet. You can create multiple versions of the same sheet, and assign different rights to each version.
You can create your own user groups if necessary.
By default, the account owner is granted SYSAdmin rights, which is slightly different from the access rights in the table above, as a system administrator has access to change the design of all the forms. To give other users this privilege, you will have to add them to the SYSAdmin group in their user page under Ragic Groups. Alternatively, you can also assign users to become SYSAdmin for certain tabs.
You can configure the access right settings for each user group by clicking the hamburger icon on the upper-left of the page, and select Access Rights under User Access.
If a user is in multiple groups, they will access the form with the group that grants them the most privilege.
Exceptional case: If an "internal user" is in multiple groups with Survey User access right (can create and edit their own entries, can't see other entries) and Viewer access right (cannot create entries, but they can view all entries), system will grant the user the Bulletin User access right (can create and view all entries, and can only edit their own entries) automatically.
If a user still cannot see the data after you grant them the privilege, ask them to log out and log back in to refresh their access right settings.
You can change the access right settings on your sheet by going to the Design Mode. You will find the Access Rights tab under Form Settings.
All of the user groups in your account will be listed here, as well as an additional group Everyone, which represents everyone, including the users who haven't logged in, or individuals who are not a user in your account.
You can set the access rights for every group of users listed here for this sheet. The access privileges that are being set is specified on the configuration interface. If a user is in multiple groups, they will access the form with the group that grants them the most privilege.
Remember to save the form design after you change the access right settings. You do not need to set this to both listing page and form page, the access right is applied to all pages of a sheet.
If a user still cannot see the data after you grant them the privilege, ask them to log out and log back in to refresh their access right settings.
Additional access rights settings can be set for user groups that have the "Bulletin User" or "Survey User" access rights for a more fine-tuned control from the Access Rights tab in your design mode.
The "No create" and "No edit" checkboxes will be displayed when a user group is set to either "Bulletin User" or "Survey User".
You can configure in global access rights panel.
You can also adjust additional access right in design mode.
Below are the edited settings if options are selected:
| Setting | Additional Settings | View | Create | Modify | Description |
|---|---|---|---|---|---|
| Survey User | No create | Own entries | No | Own entries | Will be able to edit their own entries, won't be able to see other users entries or create new entries. |
| Survey User | No edit | Own entries | Yes | No | Will be able to create new entries, won't be able to edit previous entries or see other users entries. |
| Survey User | No create, No edit | Own entries | No | No | Will be able to view previously created or assigned entries, but won't be able to edit them or create new entries. |
| Bulletin User | No create | All entries | No | Own entries | Will be able to edit their own entries, and view all other entries. Won't be able to edit entries that they don't own, or create new entries. |
| Bulletin User | No edit | All entries | Yes | No | Will be able to create their own entries, and view all other entries. Won't be able to edit entries. |
| Bulletin User | No create, No edit | All entries | No | No | Will be able to view all other entries. Won't be able to edit entries or create new entries. |
You can create a public database sheet in Ragic by setting the correct access rights.
Navigate to the database sheet you want to make public.
Click on Change Design to go to the Design Mode.
Navigate to Form Settings and Access Rights
Set the default user group "Everyone" to viewer level access right.
This method will allow anyone to see your database entries. The best way to display your public database is through the web embed option, where you can embed your database as a list of entries, database search options, or a form that will populate your database when filled on your website.
You can create a public database form that anyone can save entries, in Ragic by setting the correct access rights.
Navigate to the database sheet you want to make public.
Click on "Change Design" to go to the Design Mode.
Navigate to Form Settings and Access Rights
Set the default user group "Everyone" to survey user level access right.
This method will allow anyone to create records in your database. For others to fill out this form, you can embed it with the web embed option, as a form that when saved, will automatically populate your database.
You can also send the URL of your form page instead of embedding your form.
