Skip to main content

Control access per record

Create record-level access rules so that the people selected in a member field, or the person who created a record, get access to just that record.

Written by Leo

A record-level access rule gives people access to individual records based on the data in the record. For example, a rule can say that anyone selected in the Assignees field can edit that record. As soon as someone is added to the field, they get access, and when they're removed, the access goes away.

You can use record-level access for many things, including:

  • Letting every salesperson work on their own deals, based on a Deal owner field.

  • Giving each applicant's interviewers access to that applicant's record only.

The Record-level access section in the Share menu of a database app with Add a new rule

Note:

  • Rules work on database apps. You find them in the Share menu of the database, not in form or dashboard apps.

  • Rules never let people create records. They give access to existing records only.

  • Rules add access. They don't take away access that someone already has from the database or the workspace.

Who can use record-level access?

  • Record-level access is available on all plans: Free, Plus, and Premium. See what each plan includes on our pricing page.

  • To add or change rules, you need Full access or Can share for the database app. Without it, Add a new rule is disabled.

  • You can set a rule's level up to your own level, not higher.

Add a rule

To create a rule:

  1. Open the database app and select Share in the top bar.

  2. On the Share tab, find Record-level access and select Add a new rule.

  3. Under Select member field, select one of the database's member fields, or select Created by.

  4. Open the level dropdown below the fields and choose a level. It starts at Can edit. A rule for a member field can give Can edit, Can comment, or Can view. A rule for Created by can also give Full access or Can share.

  5. Select Create rule.

Each member field and Created by can be used in one rule. Fields that already have a rule aren't offered again. If nothing is left, Tape shows No available fields. Learn more about member fields →

The Select member field popover with Asset manager, Deal team, Created by, the access level, and the Create rule button

If you add the first rule while the app is set to Invite only, Tape asks Show shared records in this app? and gives you two choices:

  • Anyone with shared content: people who get access through the rule see their records in this database.

  • Invite only: people who get access through the rule are only notified about their records.

Select Continue to save your choice, or Cancel to stop. You can change it later with the footer setting of the Share menu. Learn more about shared records →

Selecting Share, then Add a new rule, choosing the member field Deal team, selecting Create rule and Continue, and the Deal team rule appears under Record-level access

Tip: When you switch on Allow all members for a member field of a database app that has no rule yet, Tape asks What access level should members have?. Choose Can edit or Can view and select Create a record-level access rule to add the matching rule for you. Choose No additional access and select Don’t create a record-level access rule to skip it.

Let's look at an example

Let's say your real estate team wants every agent to see only the listings they handle. Here's how:

  1. Add a member field called Agent to your Listings database app.

  2. Open the Share menu of the database. Select the row of your workspace, for example Everyone at Real Estate Investment, to show Workspace members. Set the levels for Workspace members and Everyone at Acme Inc. to No access.

  3. Under Record-level access, select Add a new rule, then select Agent under Select member field.

  4. Keep the level at Can edit, then select Create rule.

From now on, an agent who is selected in Agent on a listing can open and edit that listing. Apart from Workspace admins, nobody else can.

Change or remove a rule

  • To change a rule, open its level dropdown and select another level.

  • To remove a rule, open its level dropdown and select Remove permission rule. People who only had access through the rule lose it.

  • When you edit a member field that a rule uses, the field settings show a hint such as Anyone selected in Agent can edit this record.

The Share menu of a database app in Accounting with the record-level access rule Assignee and its level dropdown open with Can edit, Can comment, Can view, and Remove permission rule

A database app can have only a limited number of rules. When you reach it, Add a new rule is disabled.

How people see their records

If you chose Anyone with shared content, people who get access through a rule see their records in the database app itself. When they aren't in the database's workspace, the database appears in the Shared section of their sidebar. With Invite only, they're only notified about their records.

In the Share menu of a record, the database's rules are listed read-only under Record-level access. If your own access comes from a rule, the top of that menu ends with via Record-level access.

Learn more

FAQs

Can an automation change who has access?

Yes. Access follows the member field of the rule, so an automation that changes this field also changes who has access. For example, use the action Update record with Add people or Remove people on the member field when a deal moves to a new stage. Learn more about updating records with automations →

Can I give access based on a group?

No, rules use Created by or a member field. If the field contains people, they get access. To give a group access, share the app or record with the group. Learn more about groups →

Do rules apply to existing records?

Yes. A rule looks at the field in every record of the database app, so existing records are covered as soon as you create the rule.

Can I use more than one rule?

Yes. A person gets the highest level that any rule or share gives them for a record.

Can the people in a rule see the whole database app?

No, they see the records the rule gives them. With Anyone with shared content, those records also show in the database.

Can I give a person access to every record in a database app instead?

Yes, share the database with them. Learn more about sharing an app →

Still have more questions? Find answers and get help from community experts in the Tape community →.

Did this answer your question?