How to prevent duplicate Airtable form submissions

I have “Watch Responses” module that triggers on new form submissions. But sometimes the same form is submitted twice.

Is there a way through which I can prevent this duplicate submission? Like it will at first see if a similar response exists or not and then proceed.

2 Likes

Hi @Automate_with_Rezwan

Before creating a record, you can use search module with a filter to check if the record exist or not. Then add a filter to create a record only if the record doesn’t exist.

Best regards,
Msquare Automation
Platinum Partner of Make
@Msquare_Automation

1 Like

@Automate_with_Rezwan
Search for the record with some unique data:

Add a filter to check if the record does not exist ad then create a record:

Best regards,
Msquare Automation
Platinum Partner of Make
@Msquare_Automation

2 Likes

@Msquare_Automation In the case of the form submission, sames emails or other information is available for multiple records

Is it possible through any other unique id or hash?

Hi @Automate_with_Rezwan

If there is a unique value in your data (such as any IDs), you can use that as a key to identify and search for records.

Alternatively, you can configure a filter in the search module to check if all the fields from the form submission match an existing record in Airtable. This means the record exists if search module returns a record. Else, it indicates that the record does not exist.

Best regards,
Msquare Automation
Platinum Partner of Make
@Msquare_Automation

2 Likes