Prevent Duplicates During Automation

[worsin]

I am pulling in data from a webhook to create entries.  I need to prevent entries from being created if they already exist.

Is there a way to use the Find Records and Conditions to prevent this from happening?

If so perhaps there is a guide somewhere?  This is a very confusing part of Airtable imo.

[TheTimeSavingCo]

Yeap, just use a "Find Records" action to see if a record already exists with that data, then have a conditional that'll create a new record if it can't find anything.  It'll look something like this:

And this is how the conditional's set up:

Link to base

[Darren_Kowitt]

Is there any way to prevent the new record from being committed in cases where there is already a value for the index field?

[TheTimeSavingCo]

Hmm, sorry, I don't understand the question.  Does "committed" mean "saved" in this context?  What's an "index field"?  Are you also creating records with data from a webhook?

[Darren_Kowitt]

Yes, indexed is a field that must be unique within the table and it speeds up retrieval substantiallyl.

See https://www.linkedin.com/pulse/what-indexing-types-rdbms-nishchal-vaishnav-yewxf/

[Darren_Kowitt]

And, no I'm not creating records using webhooks. Just manually in the user interface.