Forms and Duplicate Entries

Hi all,

I'm trying to avoid duplicate entries that can be transacted through the form I created. I have several columns but a batch number is a unique identifier for the entire row. Is it possible to delete the duplicate row based on the unique batch # or move it to a different sheet? or trigger a flag on that duplicate entry?

Thanks in advance.

=)

Best Answer

  • Christina09
    Christina09 ✭✭✭✭✭✭
    Answer ✓

    Hi @SIS

    Yes, you can achieve that by adding a helper checkbox or flag column.

    =IF(COUNTIF([batch number]:[batch number], [batch number]@row) > 1, 1)

    IF the column with batch number has more than one of the same number, it will flag/check the box. You can then add automation that triggers if the box is checked, then move to another sheet or send you an alert.

Answers

  • Christina09
    Christina09 ✭✭✭✭✭✭
    Answer ✓

    Hi @SIS

    Yes, you can achieve that by adding a helper checkbox or flag column.

    =IF(COUNTIF([batch number]:[batch number], [batch number]@row) > 1, 1)

    IF the column with batch number has more than one of the same number, it will flag/check the box. You can then add automation that triggers if the box is checked, then move to another sheet or send you an alert.

  • SIS
    SIS ✭✭

    Thanks so much =)