How to filter the linked records field?

I want to limit the linked field to only show records that are related to the logged-in user.

Updated over a week ago

You can filter the linked records using these options in the field settings.

The filter can be applied to linked records in 2 locations:

1. Record Finder

By default the filters apply to the list of records shown in the linked records selector (which you might have chosen to hide on your form).

2. Selected Records

When this option is enabled (Apply filters to already selected records) the filter will also apply to the records that already exist in the cell. They will be hidden if they do not pass conditions. However, it doesn't apply on newly created records on the form via Create New.

3. Personal Records

There's also an option to limit the selectable records to only records that are linked to the logged-in user and hide the ones that are not connected to the logged-in user. You'd find it under "Choose Records to Display" and it would only be available if:

a. The login feature is turned ON.

b. The table of the linked records field contains a linked field to the users table.

*This toggle would only show up for linked records fields in the child form, not the parent form. This will only affect the records that is showing up in the Record Finder, not the existing values.

Example

If Table 1 represents a user table, and it has a linked records field connected to Table 2. In Table 2, there is another linked records field that connects to Table 3. Suppose you want to apply the filter to Table 3. In that case, Table 1 and Table 3 must have a direct connection to each other.

Related

Did this answer your question?