Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jan 31, 2024 09:58 AM
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.
Jan 31, 2024 09:16 PM
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:
Mar 11, 2024 05:15 PM
Is there any way to prevent the new record from being committed in cases where there is already a value for the index field?
Mar 11, 2024 06:44 PM - edited Mar 11, 2024 06:44 PM
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?
Mar 14, 2024 10:03 AM
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/
Mar 14, 2024 10:03 AM
And, no I'm not creating records using webhooks. Just manually in the user interface.