How do I remove duplicate entries on a form?

  • Profile Image
    shaun351
    Asked on January 25, 2021 at 09:18 AM

    Hi, I want to keep track of assets by location.
    Each asset is barcoded; the form includes the barcode scanner, and a drop-down box for location.

    This data is collected to a table.

    For example

    24/01/2021 #1221 - Truck 1
    24/01/2021 #1232 - Truck 2
    24/01/2021 #1206 - Truck 3

    25/01/2021 #1221 - Truck 2
    25/01/2021 #1232 - Truck 3

    I want the table to only show the most recent entry for that serial number, and remove all older entries; in the instance above, I would see:

    #1221 - Truck 2
    #1232 - Truck 3
    #1206 - Truck 3

    (this can be multiple sheets on the same table)

    **The ideal situation is that once the barcode is scanned, the form references the table and will display the current location; this can then be updated - I have no idea whether Jotform is able to do this.

    Any thoughts on either solution would be greatly appreciated.
    If you need more info, let me know.

  • Profile Image
    Carlos_C
    Answered on January 25, 2021 at 11:24 AM

    Hello There!

    Thank you for your message.

    At the moment you can create a filter in your table, so you can hide the unnecessary fields.


    1611591604_600eefb4e232c_

  • Profile Image
    shaun351
    Answered on January 25, 2021 at 12:44 PM

    Thank you; but I cannot find how to filter duplicate entries.

    (I want to see the latest occurrence of each serial number and remove / hide all older / duplicate entries. As far as I can tell, your suggestion will show me all of the duplicate entries for a serial number at once)

  • Profile Image
    Sonnyfer
    Answered on January 25, 2021 at 03:53 PM

    You can click on a table column's dropdown and select either Ascending or Descending to re-order the filtered submission to your liking.

    1611607987_600f2fb3c3b30_

    Please do give it a try and let us know if you need further assistance.

  • Profile Image
    shaun351
    Answered on February 05, 2021 at 09:26 AM

    Once again, I understand how to sort ascending and descending, but I am asking how to filter duplicate entries.

    https://eu.jotform.com/tables/210354162100032?st=WjRVWE8zaFV5cGxtN0dmcFQ5bGJUREhtS0RXUUFDdm5aSkhQQTl4UXVpcjlNa3Fac09JU0poQXd2dzhGVmdSc0RBeFQ0R3k5S0R4RFBCeldHOC9GbXc9PQ==

    This form has 2 columns : day and number
    For the sake of simplicity, duplicate days show a number 2.

    Friday 1
    Tuesday 1
    Friday 2
    Wednesday 1
    Tuesday 2
    Monday 1

    If I sort the data ascending, it appears like this:

    Friday 1
    Friday 2
    Monday 1
    Tuesday 1
    Tuesday 2
    Wednesday 1

    (I can create a similar list with a descending sort)

    I want to FILTER the data, so it removes any duplicates.

    I want it to look like this:

    Friday 1
    Tuesday 1
    Wednesday 1
    Monday 1

    (It has removed the second duplicate entry)

    Friday 2
    Wednesday 1
    Tuesday 2
    Monday 1

    (this would also be fine - this time it has removed the first duplicate entry)

    Please can you explain how I achieve this?
    Thank you.

  • Profile Image
    Gaetan_B
    Answered on February 05, 2021 at 10:35 AM

    Hello,

    Thank you for the example.


    I am not aware of a way to do this directly on the Table at the moment (please note that the product is still young and our developers are adding new features on a regular basis).

    Excel and Google Sheets are capable of this natively, and on our end, we have tools that would remove (not filter) duplicate entries: https://eu.jotform.com/apps/duplicate-submissions-terminator


    This app will have a top to bottom approach and will remove the oldest duplicate data.

    Just to keep you safe, I would recommend you back-up your submissions by downloading them firsthand as an Excel File for instance, so if things are not working exactly as you wanted to, you will always have your data: https://www.jotform.com/help/44-how-to-export-form-data-to-excel


    Hope this helps.

    Do not hesitate to reach out if you need further assistance