When someone links a record, Tape lists the records of the linked database app. With a filter, you decide which of them appear. A dynamic filter compares them with values in the record the person is working on. For example, a task can only be linked to projects that belong to the same client. This is meant to help you keep links accurate.
Note:
Empty fields in the current record skip a condition. If a condition uses a field of the current record that has no value, Tape ignores that condition. Turn on
Hide when emptyto show no records instead. Its tooltip says: "If this filter references another field that has no value, no records will be shown."The filter limits what people can choose. It doesn't remove links that already exist.
Who can use dynamic filtering?
This feature is only available on the Premium Plan. Learn more about plans →
You need
Full accessto the database app and a desktop or tablet.
Add a filter to a relation
To filter the options:
Open the database app, open the app menu, and select
Customize record layout.Click the drag handle (
⋮⋮) of the relation field, then selectEdit field.Under
Related to, open the menu of the linked database and selectFilter. The first rule appears, starting withWhere.In the first dropdown, choose a field of the linked database.
Choose how to compare it, for example
Is,Contains, orIs not empty.Choose or enter the value.
To remove the whole filter, select Delete below the rules.
Choose a value from the current record
The value list is grouped:
Options: a fixed option of the field you compare.Users: people.Records: specific records.The fields of the current record, listed under the app's record name (for example
Task). This is what makes the filter dynamic.General: values such asCurrent date. For dates, you can add an offset withPlusorMinus, followed by hours, days, weeks, or months.
Combine conditions
Select Add filter rule to add another condition. The first rule starts with Where, every further rule with And: a record must match all rules to appear. Use the menu ••• of a rule to Duplicate or Remove it.
Once a rule is complete, the menu of the linked database also shows Hide when empty. Turn it on if no records should appear while a field the filter uses is empty in the current record.
Example
Say each task belongs to a client, and you only want tasks linked to projects of that client:
Add a relation field
Projectthat links to theProjectsdatabase app.Open the
Filterof the linked database.In the first rule, choose the field
Clientof theProjectsdatabase.Choose
Is, then select the fieldClientunder the task's record name.
The next time someone links a project, the list only shows the projects of the task's client.
FAQs
Why does my relation list show no records?
Why does my relation list show no records?
This can happen when Hide when empty is on and a field of the current record that the filter uses is empty. Fill in that field, or turn off Hide when empty. It can also happen when no record of the linked database matches all rules.
Can I use more than one condition?
Can I use more than one condition?
Yes. Select Add filter rule. The rules are joined with And, so a record must match all of them. Choosing Or isn't possible.
Can I filter by a date?
Can I filter by a date?
Yes. Use Current date under General, and add an offset with Plus or Minus if you need one.
Does the filter change existing links?
Does the filter change existing links?
No. It only limits the records people can choose from.
Do I need a filter if I only want to use a view?
Do I need a filter if I only want to use a view?
No. You can limit the options with a View of the linked database app without a filter. Learn more about the relation field →
Are there other field types?
Are there other field types?
Yes! Database apps have fields for text, numbers, dates, members, files, relations, calculations, and more. See every field type in Intro to fields →
Still have more questions? Find answers and get help from community experts in the Tape community →.
