Sep 20, 2022 07:26 AM
Here’s the scenario:
Can anyone help with a more efficient way to do this?? Having 64 conditional action steps seems absurd. I’ve read through tons of articles online and there is no workable solution. Help is much appreciated!
Sep 20, 2022 09:10 AM
Welcome to the community, @Clyde_Yelverton!
Automations only allow a grand total of 25 actions (including conditional actions), so you wouldn’t be able to create an automation that handles that many combinations.
It sounds like you’re looking for an “upsert” command, which either creates or updates data with just one unified command. Make.com offers a built-in “upsert” command for Airtable, and doesn’t require any knowledge of programming code. Make also allows for an unlimited number of conditional paths (called “routers” in Make). There is no limit to the number of routers you can have in a scenario.
Sep 20, 2022 09:49 AM
Thanks for the guidance! We already use Zapier so I guess I could create a similar workflow with this, would just prefer to use direct webhook integration with Airtable instead of sending through Zapier first.
Sep 20, 2022 10:18 AM
I am not a fan of Zapier for a variety of reasons, but for your needs, note that Zapier also has a very low limit for the number of conditionals you can have. I think it’s even lower than Airtable’s limit.
Sep 20, 2022 11:48 AM
Please clarify what combinations do you mean. example?
Sep 21, 2022 02:27 PM
The solution I’ve come up with is to do multiple automations, each updating a separate table. The difficult part was getting multiple webhooks.
It’s for customer data so basically all deal information, customer contact information, marketing campaign information, and offer/transaction information was coming in the same webhook. I was trying to conditionally create/update each table based on if the data was present already or not. This got tricky trying to account for 4 different tables due to automation conditional path constraints, so worked out to split it up into different automations.