Filter for making sure duplicate records are not created

Hi there,

Newbie here. I am trying to create a workflow that updates estimates from Quickbooks and creates a record from them Airtable. I have tried many ways for this filter to make sure it does not duplicate records in Airtable. The most common way I’ve seen is the one pictured below. I have also tired a router so I know its definitely the last filter that is problematic. Thank you for your help!

Hello @Christison_Lewis,
As per your attached screenshot, you’ve tried conditions like total number of bundle found from the previous search airtable module.

Now use operator Text operators: Not equal to and compare it with 0(zero).

Let’s try to dig it.
The total number of bundles always returns an Integer(numeric) value. So you can’t compare numbers with text.
Instead of operator Text operators: Not equal to Try Numeric operators: Not equal to
I think that’s all.

Make is very type-sensitive when you use different types of data.
I recommend you try this official course which will help you a lot.

1 Like

You can add 2 route as follows



In this method, a new record will be created if the total number of bundles from the search module is 0; otherwise, the found record will be updated.

Best regards,

Msquare Automation
platinum Partner of Make
@Msquare_Automation

Unfortunately, I have tried that way and many other ways. Right now if I run that automation. It will not make any new record.