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

    How can I collect names and email addresses -and filter out those not wanting to subscribe

    Asked by tonycrowther on November 30, 2016 at 10:36 AM

    A table reservation form for a pub has fields for name (first and last), email address, and a tick box if people don't want to receive our newsletter. I want to 'harvest' these names and emails IF they leave the tick box unticked.  How do I filter out those not wishing to be involved?

    Also, when I view the form submissions list, the first and last names have been joined into one single field, whereas I want to export them as separate, thus ending with an excel file which has three fields (first name, last name, email address) but to exclude those who ticked the 'anonanimity' tickbox.
    Page URL:
    http://georgeatburpham.co.uk/reservations.html

    subscribe and email collect
  • Profile Image

    Answered by tonycrowther on November 30, 2016 at 10:48 AM

    Another small point on this form:  I want a simple tick box. The standard widget offers three 'Options' for this tick box. If you delete all text for these three options, the form ignores this and adds the three options and text back in. The only way I found to reduce it to ONE tickbox was to place a fullstop in the options text. But I am not sure it is working at all. How do I get to see if anyone ticked the box when viewing the form submissions?
  • Profile Image
    JotForm Support

    Answered by ashwin_d on November 30, 2016 at 01:18 PM

    Hello tonycrowther,

    If I understand your question correctly, you want to filter submissions based on the answer of some form field. Is that correct?

    Unfortunately it is currently not possible to filer submissions. One way to achieve this is to download your form's submission data in excel and add filter on any column. The following guide should help you how to download your form's submission data in excel: https://www.jotform.com/help/44-How-to-Export-Form-Data-to-Excel 

    You may also like to take a look at our "MailChimp" integration which will allow you to send opt-in email to users. The following guide should help you how to integrate form with "MailChimp": https://www.jotform.com/help/163-How-to-Integrate-with-MailChimp

    I have moved your other question to new thread and you will be answered here:

    https://www.jotform.com/answers/1000888

    https://www.jotform.com/answers/1000890

    Thank you!

  • Profile Image

    Answered by tonycrowther on November 30, 2016 at 01:44 PM
    So, if someone ticks a tickbox, what data is inserted into that field, so that when exported to Excel, it can be used as a filter?

    On Wednesday, 30 November 2016, 18:17, JotForm wrote:

    New response received A new response has been received: Answered by ashwin_d Hello tonycrowther,If I understand your question correctly, you want to filter submissions basedon the answer of some form field. Is that correct?Unfortunately it is currently not possible to filer submissions. One wayto achieve this is to download your form's submission data in excel and addfilter on any column. The following guide should help you how to download yourform's submission data in excel: https://www.jotform.com/help/44-How-to-Export-Form-Data-to-Excel You may also like to take a look at our "MailChimp" integration which willallow you to send opt-in email to users. The following guide should help youhow to integrate form with "MailChimp": https://www.jotform.com/help/163-How-to-Integrate-with-MailChimpI have moved your other question to new thread and you will be answeredhere:https://www.jotform.com/answers/1000888https://www.jotform.com/answers/1000890Thank you! View this thread on browser » Unsubscribe Thread 1480529901

    ...
  • Profile Image
    JotForm Support

    Answered by Jim_R on November 30, 2016 at 04:59 PM

    If someone ticks a checkbox and submits the form, the data you'd get on your Submission would be the selected option on the checkbox itself.

    e.g.

    If you have a Checkbox with 3 options: Alpha | Bravo | Charlie

    And a respondent ticked Bravo, then on the Submission Data, the checkbox filled will appear as Bravo too.

    On the other hand, if someone ticked Alpha and Charlie, then the Submission will show Alpha and Charlie too.