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

  • Profile Image
    joe2037
    Asked 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
    jonathan
    Answered 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
    joe2037
    Answered 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
    Chriistian
    Answered 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
    joe2037
    Answered on April 12, 2019 at 04:43 PM
    This Tuesday evening please vote!!
    ** Mark Your Calendars
    School Board Election
    THIS TUESDAY
    1:30PM - 8PM
    ------------------------------------------------------------
    ** Joseph Canova
    ------------------------------------------------------------
    Ballot Position #3
    This Tuesday April 16th
    * 38 - Born and raised in Clifton
    * Founder of supportclifton.com bringing $13.5M to Clifton
    * Advocated for Music Programs in all Schools
    * Daughters attending Clifton Schools
    * In attendance at BOE meetings for the past 3 years
    * Sr. Director in Berkeley College IT Department
    * Create Policies/Manage Budgets
    * Awarded with the 2018 Leadership Award for the College
    * Actively involved in the HSA
    Hello, and thank you for supporting Clifton in our efforts to obtain the funding we have been lacking from the state over the past 11 years. Since our efforts in Trenton, we were able to provide $13.5M in Clifton Schools to date!
    As you may know, I have been attending the Board of Ed meetings for the past 3 years and decided to run for a seat as a commissioner for the Board of Ed. This will allow me to make a difference in our community by continuing the fight in getting the State funding that we deserve.
    When people are considering to move they consider both the safety of the town and the quality of the schools. One of the biggest tasks facing our new Board will be to appoint a new Superintendent. This individual will set the vision for our schools future. Even if you don't have children in the school system, it is imperative that you get out to vote as this decision will directly impact you as a homeowner and taxpayer.
    ** Your Vote = Your Voice
    ------------------------------------------------------------
    I ask that you please come out this Tuesday and cast your vote for me (#3 on the Ballot) for a 3 year term. Click below to:
    * View My Website (https://www.JoeCanova.com/?utm_source=Support+Clifton&utm_campaign=b0a4284548-EMAIL_CAMPAIGN_2019_04_12_07_52&utm_medium=email&utm_term=0_86da90bea1-b0a4284548-131589197)
    * View My Facebook Page (https://www.facebook.com/joecanova/?utm_source=Support+Clifton&utm_campaign=b0a4284548-EMAIL_CAMPAIGN_2019_04_12_07_52&utm_medium=email&utm_term=0_86da90bea1-b0a4284548-131589197)
    * View Clifton's Election Video Coverage (https://videoplayer.telvue.com/player/xAkU_1Eb4e9C1-YCioqZmvaGx4GumMyB/playlists/5435/media/462770?sequenceNumber=1&autostart=true&showtabssearch=true&utm_source=Support+Clifton&utm_campaign=b0a4284548-EMAIL_CAMPAIGN_2019_04_12_07_52&utm_medium=email&utm_term=0_86da90bea1-b0a4284548-131589197)
    ============================================================
    ** (http://www.facebook.com?utm_source=Support+Clifton&utm_campaign=b0a4284548-EMAIL_CAMPAIGN_2019_04_12_07_52&utm_medium=email&utm_term=0_86da90bea1-b0a4284548-131589197)
    ** (http://www.twitter.com/?utm_source=Support+Clifton&utm_campaign=b0a4284548-EMAIL_CAMPAIGN_2019_04_12_07_52&utm_medium=email&utm_term=0_86da90bea1-b0a4284548-131589197)
    ** (http://www.instagram.com/?utm_source=Support+Clifton&utm_campaign=b0a4284548-EMAIL_CAMPAIGN_2019_04_12_07_52&utm_medium=email&utm_term=0_86da90bea1-b0a4284548-131589197)
    ** (http://mailchimp.com?utm_source=Support+Clifton&utm_campaign=b0a4284548-EMAIL_CAMPAIGN_2019_04_12_07_52&utm_medium=email&utm_term=0_86da90bea1-b0a4284548-131589197)
    Copyright © 2019 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 (https://djjoeyc.us5.list-manage.com/profile?u=420bd31132f3dd40279a23f6e&id=86da90bea1&e=bbf4d5e79c)
    or ** unsubscribe from this list (https://djjoeyc.us5.list-manage.com/unsubscribe?u=420bd31132f3dd40279a23f6e&id=86da90bea1&e=bbf4d5e79c&c=b0a4284548)
    .
    This messages was paid for by Joe Canova for Clifton BOE
    ...