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:
- 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).
- In the field customization menu, turn on the “Only include records which match certain conditions” toggle.
- 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.
Ah, I see this is rather recent feature to Airtable.
this only allows me to draw from records foreign table on foreign table’s condition.
But I want to draw records from foreign table on current table’s condition.
Is it possible to do that?
so for example
I have organization table and individual table. and the individuals are linked to the organization.
Both have their own address, but many of the individual follows organization’s address in my case.
So what I’m trying to do is, I want to make conditions of “leave the individuals address empty” and when the individual’s address is empty, “lookup from the organization’s address”.
Right now, I cannot get what I want, the condition of when “field” is empty only applies to foreign table, not the current table.
it would be great if Airtable listens to me, or anybody who knows how to solve this problem leave their opinion to me.
Thanks!
Ah, I see this is rather recent feature to Airtable.
this only allows me to draw from records foreign table on foreign table’s condition.
But I want to draw records from foreign table on current table’s condition.
Is it possible to do that?
so for example
I have organization table and individual table. and the individuals are linked to the organization.
Both have their own address, but many of the individual follows organization’s address in my case.
So what I’m trying to do is, I want to make conditions of “leave the individuals address empty” and when the individual’s address is empty, “lookup from the organization’s address”.
Right now, I cannot get what I want, the condition of when “field” is empty only applies to foreign table, not the current table.
it would be great if Airtable listens to me, or anybody who knows how to solve this problem leave their opinion to me.
Thanks!
This can be handled with a lookup field on the individual table that points to the company address along with a formula field on the same table that checks the address field of the same table to see if it exists. If it does then have it output the address. Otherwise have it use the lookup value (the company address). Hope that helps!
Ciao Katherine,
Can we please have some DYNAMIC options, similar to how automations are configured. The dynamic sub text would read something along the lines of “Use variables from other fields within destination table”
This Addition what facilitate applications similar to the case outlined in the below forum post!
Conditional Linking - Ask the community - Airtable Community Forum
@ScottWorld what do you think?
Ciao Katherine,
Can we please have some DYNAMIC options, similar to how automations are configured. The dynamic sub text would read something along the lines of “Use variables from other fields within destination table”
This Addition what facilitate applications similar to the case outlined in the below forum post!
Conditional Linking - Ask the community - Airtable Community Forum
@ScottWorld what do you think?
Yes, this is one of the most important missing features of Airtable. They’ve already added it to Automations, but they haven’t added it to the rest of the product.
There are an endless amount of scenarios that would benefit from this addition. It would literally elevate Airtable from a “simple database app” to a more robust database app.
The Airtable Team doesn’t read our messages in this forum, so PLEASE be sure to send an email to support@airtable.com with your screenshot above, and let them know how important this feature is to you!
Anyone who wants this feature should email support@airtable.com about this.
This can be handled with a lookup field on the individual table that points to the company address along with a formula field on the same table that checks the address field of the same table to see if it exists. If it does then have it output the address. Otherwise have it use the lookup value (the company address). Hope that helps!
@Simon_B What @Jonathan_Lutz mentions can also be done directly in a rollup field, which gives you the benefits of a lookup and a formula in a single field. The aggregation formula can do a lot more than just the simple examples shown when setting it up. You can put full formulas in there, with the only difference being the addition of the “values” variable to refer to the rolled-up data (and, sadly, no syntax hints). Something like this should work:
IF(Address, Address, values & "")
That will output the individual’s address if they have one; otherwise it will display the rolled-up address from their linked company.
Ah, I see this is rather recent feature to Airtable.
this only allows me to draw from records foreign table on foreign table’s condition.
But I want to draw records from foreign table on current table’s condition.
Is it possible to do that?
so for example
I have organization table and individual table. and the individuals are linked to the organization.
Both have their own address, but many of the individual follows organization’s address in my case.
So what I’m trying to do is, I want to make conditions of “leave the individuals address empty” and when the individual’s address is empty, “lookup from the organization’s address”.
Right now, I cannot get what I want, the condition of when “field” is empty only applies to foreign table, not the current table.
it would be great if Airtable listens to me, or anybody who knows how to solve this problem leave their opinion to me.
Thanks!
I solved this by creating many fields within the current field
- I made lookup field to load every organization’s address
- 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
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
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
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.
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:
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:
Is there an official wish list or feature request process that Airtable read and take notice of?
This would be SUCH useful feature.
@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.
