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

[Katherine_Duh]

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.

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.

[Simon_B]

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]

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]

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.

[Karlstens]

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]

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

This would be SUCH useful feature.

[ScottWorld]

@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.