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 ownerfield.Giving each applicant's interviewers access to that applicant's record only.
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 accessorCan sharefor the database app. Without it,Add a new ruleis disabled.You can set a rule's level up to your own level, not higher.
Add a rule
To create a rule:
Open the database app and select
Sharein the top bar.On the
Sharetab, findRecord-level accessand selectAdd a new rule.Under
Select member field, select one of the database's member fields, or selectCreated by.Open the level dropdown below the fields and choose a level. It starts at
Can edit. A rule for a member field can giveCan edit,Can comment, orCan view. A rule forCreated bycan also giveFull accessorCan share.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 →
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 →
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:
Add a member field called
Agentto yourListingsdatabase app.Open the Share menu of the database. Select the row of your workspace, for example
Everyone at Real Estate Investment, to showWorkspace members. Set the levels forWorkspace membersandEveryone at Acme Inc.toNo access.Under
Record-level access, selectAdd a new rule, then selectAgentunderSelect member field.Keep the level at
Can edit, then selectCreate 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.
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?
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?
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?
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?
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?
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?
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 →.
