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

  • Profile Image

    Answered by joe2037 on May 04, 2017 at 07:43 PM
    ** Save the Date
    Wednesday May 10 @ CHS
    ------------------------------------------------------------
    Teachers, Students, Staff and Residents. Please join us at the Clifton High School Auditorium this Wednesday. Nia Gil, Sheila Oliver and Tom Gibblin will be coming to a Town Hall meeting to discuss the funding concerns that we have.
    ** What is a Town Hall?
    ------------------------------------------------------------
    A Town Hall is a public meeting elected officials attend so that the public can inquire about topics and get answers. Legislators don't know how you feel unless you tell them. The squeaky wheel gets the oil!
    This town hall provides the setting for the conversations to take place.It is encouraged to come with examples on how the lack of funding has effected you so that we can make the case on our funding needs.
    Sign the Petition! (http://djjoeyc.us5.list-manage2.com/track/click?u=420bd31132f3dd40279a23f6e&id=9c9d2be4d1&e=bbf4d5e79c)
    Please make the time to come to this event. If many people from Clifton's community come out to raise the concerns of our funding situation, we can show how importain this issue is to us and make a diference! Without funding, more cuts will occur, our taxes will continue to raise and our childrens future will be at risk. We cannot allow this to continue. Please cone out and let your voice be heard!
    Sincerely,
    Joe Canova
    ============================================================
    ** (http://djjoeyc.us5.list-manage1.com/track/click?u=420bd31132f3dd40279a23f6e&id=ffb9b03db3&e=bbf4d5e79c)
    ** (http://djjoeyc.us5.list-manage.com/track/click?u=420bd31132f3dd40279a23f6e&id=915a26d1d3&e=bbf4d5e79c)
    ** (http://djjoeyc.us5.list-manage1.com/track/click?u=420bd31132f3dd40279a23f6e&id=d225609d06&e=bbf4d5e79c)
    ** (http://djjoeyc.us5.list-manage.com/track/click?u=420bd31132f3dd40279a23f6e&id=f64be1f4b0&e=bbf4d5e79c)
    Copyright © 2017 Support Clifton, All rights reserved.
    You are receiving this e-mail because you either signed the petition at http://www.supportclifton.com or you are employed by Clifton schools.
    Our mailing address is:
    Support Clifton
    Hudson Street
    Clifton, NJ 07011
    USA
    Want to change how you receive these emails?
    You can ** update your preferences (http://djjoeyc.us5.list-manage.com/profile?u=420bd31132f3dd40279a23f6e&id=86da90bea1&e=bbf4d5e79c)
    or ** unsubscribe from this list (http://djjoeyc.us5.list-manage2.com/unsubscribe?u=420bd31132f3dd40279a23f6e&id=86da90bea1&e=bbf4d5e79c&c=74f1046046)
    Email Marketing Powered by MailChimp
    http://www.mailchimp.com/monkey-rewards/?utm_source=freemium_newsletter&utm_medium=email&utm_campaign=monkey_rewards&aid=420bd31132f3dd40279a23f6e&afl=1
    ...
  • Profile Image

    Answered by joe2037 on May 09, 2017 at 11:43 PM
    ** Wednesday May 10
    7pm at CHS
    ------------------------------------------------------------
    Please come out to show your support and express your concerns to the legislators. I realize that many events are planned for this date so we are encouraging to divide and conquer. Bring your kids to the event if needed. The more people we have at this event, the larger the message we send to them that underfunind will no longer be acceptable to us.
    NIA GIL
    SENATE PRESIDENT PRO TEMPORE
    THOMAS P. GIBLIN
    DEPUTY MAJORITY LEADER
    SHEILA OLIVER
    SPEAKER EMERITUS
    What questions should I ask?
    Does it need to be a question?
    Anything you want! For this forum we are being asked to write our questions on an index card to prevent inappropriate language. When your index card comes up and approved, you will be handed the microphone to ask your question. Some examples of questions are:
    * What is being done about the funding issue?
    * How will funds be appropriated to fix the issue?
    * Which plan(s) are our guests backing to fix the issue?
    * Why has this gone on for so long without resolution?
    * Why should we vote for them if they have let this go on for so long?
    * What will be done about the current SFRA, Adjustment Aid and Hold Harmless Aid?
    * Why has the funding been split up without adhering to the formula?
    * What is your view on Christie's $6,600 per child proposal?
    * What is your view on Sweeney's 5 year plan to redistribute the funds from the overfunded areas to the one's in need?
    * What is your proposal and how will it be funded considering NJ is broke?
    * When is the last town hall you attended in Clifton and when will the next one be scheduled?
    * What will you be doing to advocate for our town?
    No! You could make a statement that you feel paints the picture of how we are being treated. Some examples are:
    Parents:
    * My child is not getting the attention they deserve because there are no librarians, old textbooks and remedial has been cut due to the funding issue.
    Teachers
    * I find it difficult to teach my class with all of the cuts we have been enduring. I used to provide materials to show children how to do xxx and now that has been taken away and their grades have dropped in that area.
    Staff
    * There are many manual process we are dunning since we do not have funds to research systems to automate them causing us to focus less on the larger issues at hand.
    Residents
    * The State is not funding the schools correctly which is causing us to fund almost half of the tab for schooling. Inclusive, the declining schools are driving away potential businesses and young couples from coming to town.
    Sign the Petition! (http://djjoeyc.us5.list-manage.com/track/click?u=420bd31132f3dd40279a23f6e&id=35c9d3ef2d&e=bbf4d5e79c)
    The purpose of this town hall is to understand where the legislators stand and paint the picture of what is occurring in our town. Ask yourself the question, how has this underfunding affected you, your town and your children? Ultimately, if you don't feel that they are representing our district effectively, you have the power to vote someone else in office.
    Please make the time to come to this event. If many people from Clifton's community come out to raise the concerns of our funding situation, we can show how importain this issue is to us and make a diference! Without funding, more cuts will occur, our taxes will continue to raise and our childrens future will be at risk. We cannot allow this to continue. Please attend our town hall and let your voice be heard!
    Sincerely,
    Joe Canova
    ============================================================
    ** (http://djjoeyc.us5.list-manage.com/track/click?u=420bd31132f3dd40279a23f6e&id=6e780a3f86&e=bbf4d5e79c)
    ** (http://djjoeyc.us5.list-manage.com/track/click?u=420bd31132f3dd40279a23f6e&id=3c6f9ec3ef&e=bbf4d5e79c)
    ** (http://djjoeyc.us5.list-manage.com/track/click?u=420bd31132f3dd40279a23f6e&id=8d84840147&e=bbf4d5e79c)
    ** (http://djjoeyc.us5.list-manage.com/track/click?u=420bd31132f3dd40279a23f6e&id=fc297f7668&e=bbf4d5e79c)
    Copyright © 2017 Support Clifton, All rights reserved.
    You are receiving this e-mail because you either signed the petition at http://www.supportclifton.com or you are employed by Clifton schools.
    Our mailing address is:
    Support Clifton
    Hudson Street
    Clifton, NJ 07011
    USA
    Want to change how you receive these emails?
    You can ** update your preferences (http://djjoeyc.us5.list-manage.com/profile?u=420bd31132f3dd40279a23f6e&id=86da90bea1&e=bbf4d5e79c)
    or ** unsubscribe from this list (http://djjoeyc.us5.list-manage.com/unsubscribe?u=420bd31132f3dd40279a23f6e&id=86da90bea1&e=bbf4d5e79c&c=ca1f5e1c1c)
    Email Marketing Powered by MailChimp
    http://www.mailchimp.com/monkey-rewards/?utm_source=freemium_newsletter&utm_medium=email&utm_campaign=monkey_rewards&aid=420bd31132f3dd40279a23f6e&afl=1
    ...