-
tonycrowtherAsked on November 17, 2016 at 7:31 AM
I have a pub table booking form: 'George Reservation Time Slots' from which I would like to automatically extract three fields to a spreadsheet, 'first name' 'surname' and 'email address', but I would like to add a tick box saying "remove this tick if you would NOT like to receive our newsletters - thus NOT automatically extracting the data from that form submission. How can this be achieved?
-
BorisReplied on November 17, 2016 at 8:59 AM
To answer your first question, yes, you can extract your form submissions into Excel. You can do this in several different ways:
https://www.jotform.com/help/101-How-to-Create-an-Excel-Report
https://www.jotform.com/help/44-How-to-Export-Form-Data-to-Excel
https://www.jotform.com/help/73-How-to-Download-Form-Submissions-as-Excel-CSV-PDF
For the second part, about filtering these submissions to only those that have left the "remove this tick if you would NOT like to receive our newsletters" checkbox ticked, you can simply filter for it on your submissions page:
https://www.jotform.com/help/269-How-to-View-Form-Submissions
Simply enter the text from that Check Box option into the Search bar of your submissions, and it will display only those submissions where that text was selected (1):
When your submissions are filtered, simply click on the Excel button and it will export only those search results / filtered submissions into your Excel file.
Please try it our and let us know should you need further assistance.