Q&A
we have a lead capture form that feeds into a tinytable. problem is people sometimes submit the form multiple times (double click, page refresh, genuinely submitting twice etc). we end up with duplicate rows in the table
is there a way to check for duplicates before inserting? like "if a row with this email already exists, update it instead of creating a new one"
we tried cleaning up duplicates manually but with 50+ submissions a day its a losing battle
in your workflow between the form trigger and the table insert, add a lookup node that searches the table for existing rows with the same email. then use a condition node:
- if match found: update the existing row
- if no match: insert new row
this is basically an upsert pattern. we use it on all our lead capture forms and havent had a duplicate issue since
this is exactly what i needed. the lookup > condition > insert/update pattern makes total sense. implementing today
we also add a "submission_count" column that increments on each submission. useful for seeing which leads are coming back multiple times vs one-time submitters