User Listing Setup

In this guide, we will cover how to create and set up an Airtable listing for displaying records that belongs to an end user using linked records.

As an example, we will use the following Employee Directory Airtable base where we will create a listing that displays the department from the Departments table that belongs to an employee (app user).

Creating a Airtable Listing for Users

Click on the Add Section button or hover over an existing section to reveal the Add Section button.

Select Listing, Grid or Table under Data Blocks and choose a layout.

Hover over the section and click on the Edit Listing button

Select the option My Users. This option creates a listing for displaying information that belongs to a user only. Looking to create a general listing? i.e. a listing that’s the same for everyone? See here.

This will now take you to the listing editor where you can set up your data source (Airtable), permissions, views, filters and search settings.

Connecting Airtable

In Data Source:

Select a table for your listing. Only tables with linked records to your Users table will appear.

Select a field to lookup by to return records that belongs to a user.

E.g. if we look at Brooke Khan from the Airtable above, she belongs to the Sales department.

Permission Settings

Adding permissions will prevent the public or the wrong user group from accessing your listing. To update permissions:

1. Select the Permissions tab to control who can view, create, edit and remove records from the listing. By default, no one will be able to view this listing.

View Only Permission

To grant a user group View Only permission:

Click on Add Access Rule

Choose a user group E.g. Employee

Select what permissions this user group has. E.g. View Only (we do not want the employee to update their department information)

Create Only Permission

To grant a user group Create Only permission:

Click on Add Access Rule

Select a User Group e.g. Employee

Select the option Create Records

Edit Only Permission

To grant a user group Edit Only permission:

Click on Add Access Rule

Select a User Group e.g. Employee

Select the option Edit Records

Grant All Permissions

In some cases, you may want to allow a user group like Admins to create, edit or remove records from a listing. To set up this permission:

Click on Add Access Rule

Select the user group Admin (Learn more about user groups)

Select Create Records, Edit Records, Remove Records.

View Settings

Updating view settings determines how data should be filtered and displayed.

Switch to View Settings

Displaying records using an Airtable View or sorted alphabetically by a field.

How many records to paginate records by.

Filter Settings

Creating filters enables your users to narrow down results by selecting options from either dropdown menus or tags.

Select the Filters Settings tab to generate filters for your listing.

The easiest method is to use the Single or Multiple select fields options. This will turn the field options into filters automatically.

Search Settings

Select the Search Settings tab to set up the search bar.

Determine which fields are searchable. E.g. Name, Team

Once card view and detailed view is set up in the editor, you should be able to view as Brooke Khan (bkhan@example.com) which will return the Sales department.

💡

Next up: Creating Card View