How to avoid duplicates in create record in Airtable

How To
1

Hi everyone.

Can someone giving me a tip on how to avoid duplicates in this scenario?

image
image1700×428 53.3 KB

Basically, I’m getting some files from a Google Drive Folder and I want to add the file_id to an Airtable column.

It works, but when I run again the scenario, it adds new rows again with the same file_ids.

I have added a filter where the logic is this:
Video ID column in airtable: {{238.ID video (da Google Drive)}}
Does not contain
File ID from Google Drive: {{236.id}}

But it keeps adding them.

image
image1415×702 71.2 KB

Also did something similiar, but with Google Sheet and it was working perfectly.

Don’t know why it is not working with airtable.

1 Like
2

Hi Ionut,

Please clarify what formula you have in the Search Records module. Do you search for an existing file?

image
image406×261 15 KB

Can you send the screenshots of the scenario executions for a Search module input/output and filter after the Search module?

3

Hi @ponvaskon

I’m not actually using any formula on this, cause I want to get all the records in that table so I can see if the record is already in that video ID column

image
image931×859 67.4 KB

1 Like
4

@Ionut_Tudorache, does one Airtable column contain multiple file IDs?

1 Like
5

Hi @Ionut_Tudorache
You can search for VideoId within the search module in the formula field, as shown in the screenshot. If no results are found, you can add a filter where the total bundle of operations equals zero before creating a record. This will help prevent duplicates.

image
image1042×770 74.1 KB

image
image800×589 53.6 KB

Best regards,
Msquare Automation
Platinum Partner of Make
@Msquare_Automation

5 Likes
6

No, it doesn’t.

image
image1567×448 9.2 KB

I should have just 1 video ID per column (that is the single file ID in the G Drive folder)

1 Like
7

@Ionut_Tudorache, in this case, you should use the search formula as @Msquare_Automation suggested and only proceed if the record ID doesn’t exist.

2 Likes
8

Hi @Msquare_Automation

It works perfectly.

Thank you!! I’ll remember this!

2 Likes
9

Yes, tested it and it works perfectly!

Thank you!!

2 Likes
10

Hi @Ionut_Tudorache

Glad to know that your issue is resolved now. Feel free to reach out if you have further queries.

Best regards,
Msquare Automation
Platinum Partner of Make
@Msquare_Automation

3 Likes