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

In 2020 we’ve seen a very noticeable uptick in Airtable staff’s presence in the forums, and much more frequent feature releases. Things like the scripting contests give us a chance to flaunt our stuff, and give AT a chance to learn how power-users test and use the new tools, presumably to help focus new improvements down the line.

I’d kill for a product release roadmap and things aren’t perfect, but we would be remiss not to mention the recent changes as though AT has made no effort at all to engage with us.

3 Likes

Yes, I do agree that 2020 has seen gigantic improvements so far! They’ve been rolling out big new features at a steady pace! :smiley: I’m so excited to see what the future holds for Airtable.

That’s also great to hear that you’ve seen an uptick in Airtable’s presence in the forums — that’s precisely what I was asking for. :slight_smile: That was essentially my entire point.

I totally love Airtable, and I’m in it for the long haul. :slight_smile: My interest is in seeing the platform grow & DOMINATE in this category of low-code/no-code cloud-based database platforms!

My only concern was that many of us here have so much in-the-field knowledge about how the product can improve in the best ways possible to really NAIL our clients’ needs. So, if we had more dialogues between Airtable staff & us (maybe even a few focus groups with us), we could help prevent losing Airtable customers like that one customer who I referenced above. Knowing that a new feature is coming down the line, or that Airtable has prioritized a new feature for the future — can help us plan for the future, attract new customers, and retain Airtable customers. Even receiving simple confirmations from them like, “Yes, we hear you — we agree that this is a really important feature” or “We’ve thought about that internally, and it’s not a high priority for us right now because of XYZ” would go a long way.

I am extremely enthusiastic & upbeat & positive about Airtable (and I am an extremely positive person in general). My only concern was more communication & engagement, please. And it sounds like they’re moving in that direction, which is absolutely fantastic! :smiley:

Oh, and better documentation. :wink: Lol.

But overall: Airtable for the win! :blush::trophy::1st_place_medal:

1 Like

I don’t remember the name of the person I was in touch with but I used this directly in the Base:
image

Maybe this has been answered before, but I’m wondering if these new features will help with an issue I’ve been trying to solve. If I have a Client Orders table I use to generate invoices, can I use the new features of the Count field to increment invoice numbers for particular clients. So that I can autogenerate order numbers such as: Client A Order 1001, Client A Order 1002, Client B Order 1001, Client C Order 1001, Client B Order 1002? It seems like it should be simple, but keep running into self-referential field problems.

The new features listed here probably won’t help with what you want. However, this setup that I outlined a while back probably will:

This is super super helpful!! Great job Airtable!

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”

image

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?

1 Like

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.

1 Like

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

1 Like

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

1 Like