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

tonycrowther

Asked 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.
tonycrowther

Replied 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?
Ashwin JotForm Support

Replied on November 30, 2016 at 1: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!
tonycrowther

Replied on November 30, 2016 at 1: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

...
Support_Management Jotform Support

Replied on November 30, 2016 at 4: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.