Forms and Duplicate Entries

claytonrlewis

Hi everyone

Is it possible that when a new Form Row is created that something can trigger it to look for a duplicate row (the same number in the same field) and then remove the old row and let the new row be the current entry?

Andrée Starå

Hi Clayton,

Yes, I think so. You could have a formula to check for the duplicate and then move the earlier row to another sheet if there is a new submission.

Would that work?

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Emerus CCC

Hi there. I have the same question and have already added a formula to search for duplicate entries based on the data. What would the formula look like to move the older row to another sheet?

Thank you.

Mark Salamon

I would be very interested in how this is implemented, as I have not figured out what condition must be met in the automation to move the record.

Also, my preference would be to move the original record, but that likely is not possible.

lilygomesa

Andree is there a formula you can share? I am having the same issue., Is it possible that when a new Form Row is created that something can trigger it to look for a duplicate row (the same number in the same field) and then remove the old row and let the new row be the current entry?

Andrée Starå

Hi @lilygomesa

I hope you're well and safe!

How did it go? Did you manage to get something set up?

I hope that helps!

Have a fantastic weekend & Happy New Year!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

andi.wilson

What is the formula to recognize and possibly delete (or not allow) duplicates?