How to Show Clients Only Their Own Airtable Records

Last updated: 21 August 2026.

You’ve got one Airtable base holding every job, case, or account. A client logs in to check on their own, and for a second you’re not sure: can they see anyone else’s information too?

Airtable has a native way to show each logged-in user only the records assigned to them. It uses a user field and a current user filter.

Here is exactly how to set it up, what it does, and what to watch out for when you have multiple clients using the same interface.

What do you need in place before you can filter records by client?

Before the filter can work, Airtable needs to know who the person viewing the interface is.

That means the client needs to access the interface as a logged-in Airtable user rather than through an anonymous public link.

You also need a user field on the table you want to filter. This is a specific Airtable field type that stores an actual Airtable user, rather than a text field containing someone’s email address.

For example, you might have a Client user field in your Projects table. Each project is assigned to the client who should be able to see it.

Once that is in place, Airtable can compare the logged-in user with the user stored on each record.

How do you set up a filter so each client only sees their own records?

There are two ways to configure this, depending on whether you want to filter an entire interface page or a specific element.

Option A: Filter an entire interface page

1. Open your base and click into Interfaces.
2. Open the page you want to restrict.
3. Click near the page title to open the page properties.
4. Under Data, find Filter by and click the cogwheel icon.
5. Select + Add condition.
6. Under Where, choose your user field.
7. Set the user to Current user.
8. Publish the interface.

Airtable will then show each logged-in user the records where they are included in that user field.

Option B: Filter a record list element

If you only want to apply the rule to a particular list or grid:

1. Select the record list element on the page.
2. Open its settings in the sidebar.
3. Set the element to Viewer’s records.

This uses the same basic idea: Airtable matches the logged-in user against a user field on the record.

You don’t need to create a separate interface for every client.

What plan do you need, and who can turn this on?

The Current user / Viewer’s records functionality is part of Airtable’s Interface Designer. Airtable’s current documentation lists Interface Designer across all plan types, although sharing an interface separately from the underlying base is restricted to paid plans.

You’ll also need the appropriate Owner or Creator permissions to configure the interface. Airtable recommends that creators use Preview or View as to test what other users can see before sharing an interface.

On Business and Enterprise Scale plans, Airtable also supports user groups, which can be useful when the same records need to be visible to several people rather than one specific user.

Does this work with a public link, or only with a logged-in user?

The Current user filter depends on Airtable knowing who is viewing the interface.

A public interface link does not give Airtable a logged-in user to match against, so Current user filtering isn’t supported for publicly shared interface pages. Airtable specifically warns that publicly shared interfaces can potentially expose data when this type of filtering is involved.

So if you need Client A to see Client A’s records and Client B to see Client B’s records, use authenticated access rather than a public link.

What does the filter actually do?

The filter controls which records are shown to the logged-in user on that interface page.

For example:

What you’re trying to control	Does the current user filter handle it?
Client A only sees Client A’s records	Yes
Client B only sees Client B’s records	Yes
Different pages have different filters	Yes, but each page needs to be configured
Which fields appear in a record detail page	Separate interface setting
Anonymous visitors using a public link	No

Airtable’s interface permissions also let creators control which fields appear in record details, so don’t treat the record filter as the only access setting you need to check.

For a broader explanation of Airtable’s permissions and where they become difficult to manage, see our guide to Airtable permissions: what they can and can’t do.

How do you test that the filter is actually working?

Don’t just trust the filter panel.

Test the interface as an actual client or test user.

Airtable itself recommends using Preview or View as to check the sharing flow before giving users access.

Check three things:

1. The client only sees the records assigned to them.
2. They see the fields you actually want them to see.
3. The same access rules work on every page they can reach.

That last point matters because Current user filtering is configured at the interface-page level. Setting it up correctly on one page does not automatically configure every other page in your interface.

What happens if a client is assigned to multiple records?

That’s exactly what this setup is designed for.

If the same client is assigned to 20 projects in your user field, the Current user filter can show that client all 20 projects.

You can also use different filter operators when a user field contains multiple users. For example, Airtable supports conditions such as is any of or has any of, depending on how the user field is configured.

Be careful with broader matching rules, though. If several users are assigned to the same record, more than one person may be able to see it.

Test those cases before giving clients access.

When does this become difficult to manage?

Current user filtering can be a simple way to give clients access to their own records.

The challenge is that you need to keep the access rules correct as the interface grows.

Imagine you start with:

• 10 clients
• One project page
• One user field

Then your operation grows and you add:

• A project dashboard
• A document page
• A requests page
• An invoices page
• Contractor access
• Internal team pages

Now there are more pages, more user types, and more rules to check.

The problem isn’t that Airtable can’t filter the records. It’s that external access has become a bigger part of the workflow.

That’s where teams can start looking beyond a filtered interface.

If you want to understand the separate problem of duplicating interfaces for different clients, see How to stop duplicating the same Airtable interface for every client.

What if clients need to do more than view their records?

Sometimes the requirement starts simply “I want each client to see their own projects.” Then it grows into “I also want them to submit requests, upload documents, see project updates, and work with our team.”

At that point, you’re no longer just filtering an Airtable interface. You’re managing what different people outside your company can see and do.

For example, a client might need to see their projects, submit a request, upload documents, and track progress. A contractor might need to update only the jobs assigned to them. Your internal team needs access to everything.

You can keep adding filters and access rules inside Airtable as these needs grow. Or you can keep Airtable as the place where your data lives and give each external user a dedicated portal to work from.

With Noloco, you can build a client portal on top of your Airtable data, so each client sees the records, pages, and actions relevant to them. Instead of sharing your internal Airtable setup with external users, you give them a place designed around what they actually need to do.

This can be useful when clients need to:

• See only their projects, jobs, or accounts
• Submit requests or update information
• Upload and access documents
• Track progress without asking your team for updates
• Work across several parts of a process in one place

Your team can continue using Airtable behind the scenes while clients, partners, or contractors get their own experience on top of the same data.

Final thoughts

Airtable can genuinely show each logged-in client only their own records: add a user field, assign each record to the right user, and filter the interface by Current user.

It’s useful for simple client-facing setups, and you don’t need to duplicate an interface for every client.

Just remember that the filter is configured per interface page, and it doesn’t apply to anonymous public links. Test the experience as an actual client before sharing it.

If clients eventually need to do more than view their records (submit requests, upload documents, track work, or interact with your team), you may outgrow a filtered interface and need a dedicated client portal instead.