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.