Skip to main content

Airtable has two nice features:

  1. In Interfaces you can launch a “Create Record Form” from an existing record and it will pre-populate the “parent” record value in the appropriate field.
  2. In Data Tables when using a Link field (to another table) you can specify a filter, to limit which records are displayed. 

However, these two features do not appear to be compatible 🙁

 

Worked Example:

  • I have a Team Placement table, which links People records to Team records.
  • I have an interface which lists the current Teams, from the record view I can launch the “Create Team Placement” form and the Team field is pre-populated.
  • However, I want to have a filter on the table level to only allow “Active” Teams to be selectable. When I add this filter at the table field level and then re-launch the “Create Team Placement” form, this time the Team field is pre-populated with "Unnamed team” - even though the Team that should be pre-populated is “Active”.

 

Has anyone else encountered this issue? More importantly, has anyone found a workaround for the issue?

 

When I have a filter on the Team field ...
… the Team field is pre-populated with “Unnamed team” :(
When I remove the filter ...
… the Team field is correctly pre-populated.
To confirm the Team is “Active”, so does meet the table field filter criteria.

 

Hey ​@GrahamPorter! Thanks for submitting such a great question! Because your question hasn't yet received an answer/solution from the Community, we've created s support case on your behalf with our Airtable Expert Team to get you the quickest response possible. Please check your email for follow-up and your case reference number—and continue to follow this thread as new community members tend to share answers and add knowledgeable responses regularly.

Terms & ConditionsAccessibility statement