What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    Is there a way to remove duplicates from the count of the submitted forms?

    Asked by joe2037 on February 26, 2017 at 08:07 PM
    Is there a way to remove duplicates from the count of the submitted forms? I would like to show both the total submissions and total unique submission if possible
  • Profile Image
    JotForm Support

    Answered by jonathan on February 26, 2017 at 08:17 PM

    The only means to do a data deduplication for your form's existing submission data is to do it outside the Form Builder.

    You can export or download first the data i.e. to an Excel or spreadsheet file. Then you can do data deduplication using the spreadsheet application.

    --

    On the other hand, there is a way for your form to have unique submission data by eliminating duplicate submissions.

    This will only work for new submissions and not for those already existing on the form.

    You can refer to the user guides below on how to have unique submission data on the form.

    #1 How-to-Add-Custom-Unique-IDs-to-your-Form-Submissions

    #2 How-to-set-Form-Limits-Based-on-a-Unique-Question

    Let us know if you need further assistance.

     

     

  • Profile Image

    Answered by joe2037 on February 26, 2017 at 08:46 PM
    I actually want them to send in duplicates though. They should be sending them daily which will Kickoff emails to the legislators daily and get attention to our issue. I just don't want the count to go higher on the submission count or have a separate count for "unique" submission for Analytics.
    Sent from my iPhone
    ...
  • Profile Image
    JotForm Support

    Answered by Chriistian on February 27, 2017 at 01:28 AM

    If you want them to send in duplicates, setting Form limits to eliminate duplicate submissions will not be suitable for you.

    The only work around I can think of is what my colleague suggested, to do data deduplication using the spreadsheet application.

    If you need further assistance, please let us know.
    Regards