Hi Mathias,

Thanks for your note! This is something that we do have plans to support and are actively discussing internally. If you’re open to it, I’d love find some time to learn more about your use case here, as part of the research process for this feature.

In the mean time, you can achieve most of what you describe using Zapier/triggering on unique views for each ‘update action’ (though at the moment, a Zap can trigger only once per record per view).

Cameron

Hi Cameron

That’s so great to hear! I would be happy to talk to you about the use case

I’d also be willing to talk about our use case! This would be HUGE. I’m currently looking into Airtable and the lack of automation when it comes to things like Mathias is talking about is a bit of a let down for me . I like the vision and overall the app is great, but every business needs automation to make their processes more efficient!

In case you need some more scenarios to study, I’d also be quite willing to share: we are a film school and use Airtable for our internal project documentation. There is a lot of per record (= one record, one project, with dependent data in extra tables) status changes going on which should by rights trigger adjustments in related data or action steps, but currently don’t without manual intervention. The kind of business logic automation (hooks) this is hinting at would be a leap forward for us, and I’d be happy to share how and why.

And yes, we could achieve a lot of that with an automation service (we use Integromat), if only Airtable provided webhooks for record creation, modification and deletion.

Thanks for the enthusiasm, all. I’ll be reaching out next week to set some time up!

Cameron

I wonder if my request is similar (or if there already exists a solution):

Can we use IF THEN rules to basically automate the population of records across tables in a base? (other than when it’s an explicitly linked record)?

I’m trying to build out a base to contain all my sharable music/writing content. I currently have one table for the Content Title (i.e. “Come Together”), then a separate table for Platforms (YouTube, Facebook, Vimeo, Spotify, etc), and a third junction table to join Content + Platform together for the purpose of listing specific links. Everything is linked together. Meaning, on the Content table, there’s a column for linked record to corresponding platforms.

I wish this could all happen cohesively in one table, but I can’t figure that out. So the next best thing would be a junction table (I think).

So my third, junction table has Linked record columns for both Content and Platform, and the main field is a formula for Content + Platform. Thus, each record in that first column of the junction table follows the format of “Come Together - Facebook” etc. And then I can add a column for specific link to that piece of content on that specific platform.

The problem is that I have to manually link the records in the Content and Platform columns when on the junction table. Would there be a way to just have those automatically populated as soon as I fill them in on either the Content or Platform tables?

Anyway, the original reason I got into this whole mess is just because I wanted to have a multiple select column that listed various platforms, but then when I separated it out into views, I couldn’t see the platforms separately. I just wanted to see all my Facebook content together, then all my YouTube, etc, even if much of the content titles were duplicated, rather than all the different specific combinations of platforms thereof.

Thanks for any help! I’m really not great at this yet, so if I made a glaring oversight, let me know!

Any updates here?

I moved to airbase from another platform, I just build a base for our company but I just noticed I have to rely on moving projects and assignments along manually?

This was a HUGE advantage from the other platform.

Have you guys at least figured a way around in the meantime?

Please help

Jimmy!

Hi there,

are there any updates on this? Zapier is fine but it’d be great if we can apply rules without the need of it.

Thanks!

Definitely need this feature! It’s completely hamstringing our ability to use this platform for event attendance tracking as we’ve got 3 tables that need to talk to each other, ex. Volunteer table w/ names, Events table w/ attendance field and host field, and Attendance table w/ check boxes for if someone’s a host, if they attended/said no/no showed. Right now I can have the event table have a name as the host, but that can’t check boxes off on the attendance sheet and only can link to the volunteers sheet.

Right now we’re just using the events=>volunteers path for host, but I’d rather have it connect all three tables, and be able to just have the person checked off on the attendance table and it show up on the event table and the volunteers table.

This was recently implemented in Asana as “Rules” - with ‘Triggers’ and ‘Actions’ - and it makes the product that much more powerful.

Their first implementation is simple but very empowering. Would love a similar execution in Airtable.

Has there been any update to this? I am particularly in the use case above of simple auto-population of fields between tables. I.e. If Field X in Table 1 is [f], then Field Y in Table 2 should be [g]. or the like. This would really be an exceptional add that should be relatively achievable. Thanks.

@Colleen_Hoy Check out Airtable’s Automations, especially the “when a record matches a condition” trigger and the “update record” action.

@kuovonne Thanks for sharing tip on automation.

I tried doing it.

My use case: I am building a sales funnel tracker. I have two columns (Status & Progress Stage) ‘single select’ field type. I want to use the record entries in ‘Progress Stage’ to update ‘Status’.

How should it look like ?

Under ‘Status’ - I have three options - cold lead, warm lead, hot lead.

Under ‘Progress Stage’ - I have three options - RFP released, Bid Submitted, Bid under evaluation.

What is my end goal ?

If I select ‘Progress Stage’ to be ‘RFP Released’, then ‘Status’ should automatically update to ‘cold lead’

My experience with trigger & action -

I am able to set the trigger but unable to get the desired action (the three options under status does not auto populate)

@Cameron_Deleone - am I doing something wrong here

@Sanat_Mohanty Welcome to the Airtable community!

This sounds like a straight forward automation:

• trigger: when the record meets the condition of ‘Progress Stage’ being ‘RFP Released’


• action update the record to set the ‘Status’ field to ‘cold lead’ (simply type the desired single-select choice)

Can you share screen shots of your automation and of the fields?

@kuovonne Thanks for being so responsive.

Below is the screenshot - I guess I have enter the record ID under ‘action’

Yes. Click the plus in the blue box to insert the record ID of the triggering record. Otherwise the Automation doesn’t know which record to update.

@kuovonne thanks for responding. It worked.

Just a quick follow up question - incase we want to create similar automation for, lets say, all 6 records, then do we need to set up individual automation for each record OR can we set up a bulk automation rule for all records in one shot ?

If all six records in the table meet the triggering condition, then the automation will run six times—once for each triggering record. Note that you did not hard-code the record ID. You told the automation to use the record ID of the triggering record, so in other runs it will use the record ID of whatever record triggered the automation.

Note that you must turn on the automation before the records meet the condition. Then the change that makes the record meet the conditions of the trigger must occur. If the record meets the conditions of the trigger before the automation is turned on, the automation will not run for that record.

If you want an automation to be triggered by only one record and run only once, but affect six records, you will need a Scripting action. (But it doesn’t sound like this is what you want.)

are these if then rules working yet? I would love to use them!