Skip to main content
Question

Need a view that filters based on values in another table

  • January 27, 2026
  • 4 replies
  • 34 views
D
Forum|alt.badge.img+5

I have a table of contacts that includes zip code for each contact. I want to provide a view of contacts for a given county. I can get a list of zip codes for the county, but it's too many zip codes to list each one as a separate condition on a filter.

I thought about setting up a zip code table and using a linked record from the contacts table. Is there a way to create a new linked record field that links based on an existing already-populated column? There are too many records to select linked records manually.

Or, is there a way to create a view with filter criteria that references another table?

Thanks for any suggestions.

    4 replies

    ScottWorld
    Forum|alt.badge.img+35
    • ScottWorld
    • Genius
    • January 27, 2026

    In your “contacts” table, it sounds like your zip code field is just a normal text field.

    You would need to convert your zip code field from a text field into a “linked record” field, which will create a brand new table for you called “Zip Codes”. (Be sure to choose the option to create a new table, and call it “Zip Codes”.)

    Then, in your brand new “Zip Codes” table, add a new field called “County”. Type in the County for each zip code. It might help you to make this field a “single-select” field.

    Back in your “contacts” table, add a “lookup” field which looks up the county based on the zip code.

    Then, you will be able to filter your contacts based on their county.

    To learn more about linked record fields and lookup fields, you may want to take my free Airtable training course, which you can take for free by signing up for a free 30-day trial with LinkedIn Learning.

    Note that my course is very outdated because it was created many years ago in 2020 using one of the earliest versions of Airtable. However, the core concepts of linked record fields and lookup fields remain the same to this day!

    Hope this helps!

    If you have a budget and you’d like to hire the best Airtable consultant to help you with this or anything else that is Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

    Mike_AutomaticN
    Forum|alt.badge.img+28

    Hey ​@DanaBergen,

    You’ll want to ​@ScottWorld instructions above. And honestly.. any other instructions shared by Scott elsewhere lol. The guy knows his way around Airtable. If it solved your issue, you’ll want to mark his answer as the best solution.

    If it helps, you can find a guide on how to set up Lookup Fields here. Hope it helps!

    Mike, Consultant @ Automatic Nation 
    YouTube Channel

    ScottWorld
    Forum|alt.badge.img+35
    • ScottWorld
    • Genius
    • January 27, 2026

    Awww, thanks, ​@Mike_AutomaticN!! You’re the best!! 😎🙌

    And ​@DanaBergen, Mike is one of the other top experts around these parts as well!

    p.s. Mike, it looks like your link to the guide on lookup fields is the wrong link.

    - ScottWorld, Expert Airtable Consultant

    Mike_AutomaticN
    Forum|alt.badge.img+28

    Oh that was just a dirty trick!!! Lol, jk. This is the correct link for the lookups guide. Thanks ​@ScottWorld :D

    Mike, Consultant @ Automatic Nation 
    YouTube Channel 

    Terms & ConditionsAccessibility statement