Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Launched: conditional relational fields (lookup, rollup, and count)

cancel
Showing results for 
Search instead for 
Did you mean: 
Katherine_Duh
Airtable Alumni (Retired)

You can now add custom filter conditions to lookup, rollup, and count fields to limit which records are included in the results. Here’s how to do it:

  1. Create a valid lookup, rollup, or count field (if you don’t already have one in your table, you’ll need to create a valid linked record field first).
  2. In the field customization menu, turn on the “Only include records which match certain conditions” toggle.
  3. Specify the relevant filters for your use case.

Screen Shot 2020-04-28 at 10.50.22 AM Screen Shot 2020-04-28 at 10.51.19 AM

This also means that if you have been using helper formula fields as a workaround to achieve this same functionality, you can transition off those fields for a cleaner, clearer base! 🌅

Learn more about this new feature with the conditional counts, lookups, and rollups support article.

36 Comments
Simon_B
4 - Data Explorer
4 - Data Explorer

I solved this by creating many fields within the current field

  1. I made lookup field to load every organization’s address
  2. I made another if formula field, and set if the individual’s address is blank get organization’s address, if not blank, get individual’s address
    So, I have 3 different set of address field, 1. Individual’s address, 2. Organization’s address, 3. formula address.
    I found out that I needed another field anyway and It solved it. I leave my solution, If anyone is interested.

Anyways, thanks for your reply @Justin_Barrett I will try using roll up field next time

Andrew_Davies
7 - App Architect
7 - App Architect

Quick question - is it possible to pull in the value of a record into the condition?

ie - instead of
“Where item type is any of chair, desk” etc - can I have
“Where item type equals the contents of the field called type”

Hope that makes sense?
Andrew

Allen_Moldovan
7 - App Architect
7 - App Architect

WE WISH!

In addition to look/roll ups, it would be great to dynamically filter linked record options . Akin to excel’s cascading drop downs.

image

image

Karlstens
11 - Venus
11 - Venus

Yah, I too vote for dynamic lookups that limit returns depending on a related field value. It’s such a massive limitation and all the workarounds stink. Surprised that this hasn’t been implemented yet. :thinking:

Andrew_Davies
7 - App Architect
7 - App Architect

Is there an official wish list or feature request process that Airtable read and take notice of?

This would be SUCH useful feature.

ScottWorld
18 - Pluto
18 - Pluto

@Andrew_Davies @Karlstens @Allen_Moldovan

Yeah, this is the BIG BIG BIG missing feature that prevents Airtable from being a truly powerful database tool. Be sure to email support@airtable.com about this feature request, since Airtable employees unfortunately don’t typically read our posts here.