Automation to create new records only if condition does not exist

Video until 1:40 shows the context of what we’re trying to accomplish. After 1:40, shows the details of how we tried to set up our automation.

We already have a “Zap” set up through “Pabbly Connect” where all new orders create a new record in our ORDERS table. We want a Airtable automation that looks at the records in our PLAYERS table and checks to see if the user that created the order, already exists (based on the phone number being the unique identifier).

Consider that phone numbers have been entered in a variety of formats.

Please see the linked video to see exactly how we’ve set up the automation… but we can’t get it to work.

Any suggestions?

Hmm, your automation in the video looks fine to me; I may be missing something though.

Could you create a read-only link and DM me it so I can try to troubleshoot it?

I only need the Players and Orders table, as well as maybe two example phone numbers, so please feel free to delete everything else

1 Like

Did you retest your trigger after you added or changed the formula field? If not, you need to retest the trigger.

Does the formula field give the result you want?

Did you use the same formula field in both the [ORDERS] table and the [PLAYERS] table? And are you doing the matching on the formula fields?

1 Like

I’ve stripped all the content from my original base and created this one that you could take a look at…

@kuovonne nailed my problem when she asked…

I have since gone back and updated my automation in my real base, and in this example base (linked above, for community reference) and it’s now working.

Before (not working)

After (working)

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.