Hi! Having some issues with an automation.
- Customer ‘Orders’ table
- Customer ‘Leads’ table
- Step 1 (Trigger) : New record is added to Orders.
- Step 2 (Action): Find record in ‘Leads’ that has a matching email address (as the record in Step 1).
- Step 3 (Update): In ‘Leads’, update a field in the record found in Step 2.
When a matching email address is found, everything works as expected
However, when there is no match found:
- Step 2 reports ‘Step Successful’, but returns 0 records found (this is as I would expect)
- Step 3 throws a ‘Received invalid inputs’ error.
I would expect Step 3 to not run at all, if Step 2 doesn’t find any matching records.
So I guess the question is, is there conditional logic built into automations that does something like the following:
- If Step 2 finds record, go to step 3
- If Step 2 doesn’t find record, stop.
Any help appreciated!
Welcome to the community, @Owen_Smith.
Unfortunately, what you have discovered is the way that Airtable has currently setup their automations.
It’s very disappointing, isn’t it? Finding zero records isn’t an error, but Airtable treats it as an error and then sends you an email to let you know that an error occurred.
Even worse, the “Find Records” action step doesn’t work as you would expect, either. It only works as expected if it finds ONE RECORD ONLY.
All of this is to say that Automations are pretty weak at this point.
(Note that I am a professional Airtable consultant and a Registered Integromat Partner, and the Integromat link contains my personal referral code.)
Thanks for the detailed reply @ScottWorld, really helpful!
I was worried that would be the answer
I was excited when Automations was released, we use Zapier a lot (rather than Integromat) so was hoping I could migrate some automations from there into Airtable.
However this won’t possible, at least until some conditional logic and the other issues you explain so well are addressed.
@Owen_Smith Oh, one other thing: Please be sure to email firstname.lastname@example.org about all of this missing/broken functionality in Automations, so they know that it’s important to you that these things be fixed. They don’t spend much time on these forums, and it’s important that they hear from people about this.
This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.
Hi @Owen_Smith I hope 2022 is off to a great start, wanted to follow up on this thread and share that as of today, conditional automations are now available in Airtable. I hope this is helpful and let me know if there are any other questions!