If you're using Quickbase's new sidebar navigation, some parts of this article might not match what you see in the product today. We appreciate your patience while we make updates. Learn more about new navigation.
Access to this feature can change based on your Quickbase plan. Learn more about feature availability and plans in Quickbase capabilities.
You may want a user or group of users to only view and edit those records created by someone in their own group. For example, maybe a department manager should edit only those records created by members of her own department. You can impose such a restriction using the "Group's Records" setting within roles.
Note: "Group's Records" permissions is a special setting within Roles that limits group members to seeing and/or editing only those records a member of their own group has created. If you want to organize users in groups so you can control permissions that do not hinge on who created certain records, you shouldn't be reading this topic. To set up permissions using groups, you create a group, then share your application with that group, assigning to the group whatever role grants the desired access. If an existing role doesn't fit the bill, create a new role. (Read more about this process in the What is a Group? topic.)
Assigning "Group's Records" permissions requires some preliminary setup. Before following the steps below, you'll need to create a group containing all members of the department (if it doesn't already exist). Next, you'd follow the steps below to configure access permissions for the role the department manager (or the entire group, depending upon whose access you want to control) uses to access the application. When doing so, you'd specify a Group's Records level of access for Modify permissions (detailed instructions below). The last step is to specify the target group whose records this setting affects.
To create Group's Records permissions:
-
In the App bar, select the application you want, click Settings, then click Roles.
-
Do one of the following:
-
To create a new role, click New Role at the top of the list of roles, enter a role name and description, then click OK.
-
To modify the permissions of an existing role, choose the role from the list on the Roles page, then click the Permissions tab.
-
-
On the Permissions tab, locate the name of the table to which you want to control access.
-
From the dropdowns in the View and Modify columns, select Group's Records.
-
Repeat Step 4 for each table you want to control access to.
-
Click Exit Settings. You can now assign the group records permissions that you created to users.
-
From the table bar, select Users.
-
Choose a user's role using the dropdowns in the Role column.
-
Click the link in the Target Group column to set or change a target group. Only users in the role you edited have this link, which appears only as a result of a Group's Records selection you made in Step 4.
-
The Select a Group dialog opens.
-
Select the group whose records the user can access and click Done. The target group for that user will be shown in the Target Group column.