Command or Formula to Identify duplicate entries in submission table

  • uniaosul_aspa
    Perguntado em 30 de janeiro de 2024 às 07:44

    Olá, tem algum comando ou formula para identificar algum nome repetido em uma coluna?

  • Jefferson Jotform Support
    Respondido em 30 de janeiro de 2024 às 09:58

    Hi financeiroaspa,

    Thanks for reaching out to Jotform Support. Unfortunately, our Portuguese Support agents are busy helping other Jotform users at the moment. I'll try to help you in English using Google Translate, but you can reply in whichever language you feel comfortable using. Or, if you'd rather have support in Portuguese, let us know and we can have them do that. But, keep in mind that you'd have to wait until they're available again.

    Now, let me help you with your question. If I understand you correctly, you would like to know if there is a command or formula to check for duplicated entries in your submission form. Unfortunately, there is no yet formula/command to do that, but you may use our search bar to check for duplicates. Check the sample below:

    Command or Formula to Identify duplicate entries in submission table Image 1 Screenshot 20

    However, since this task is quite tedious, you can also download your submissions as an Excel file and find and highlight the duplicates. Please refer to the guides I have provided below.

    Guides:

    https://www.jotform.com/help/73-how-to-download-form-submissions-as-excel-csv-pdf

    https://www.excel-easy.com/examples/find-duplicates.html

    We currently don't have a feature that allows you to prevent duplicate submissions based on submissions data present in your account. However, you can use the Unique Question or the Unique Submission option to prevent duplicate submission on a specific form. 

    Let us know if you need further assistance. Thank you.