- 200clubmarketingAsked on November 16, 2016 at 05:34 AM
I am in the process of completing a scholarship application form. Upon completion of the form, can the responses be populated in an excel document? Our goal is to be able to extract data for all applicants into a simple sheet for us to view them all. We are trying to eliminate manually copying and pasting data.
Also,is there a way to set up an alert to designated email addresses when a form is submitted?
- JotForm SupportemilyAnswered on November 16, 2016 at 06:19 AM
You can integrate your form with Google Spreadsheet.
I created an example form with the fields you can see below. To integrate your form with Google Spreadsheet, kindly click on Integrations button.
Choose Google Spreadsheet and approve authentication.
When you make submissions, they will be shown in the spreadsheet. You are able to see the submission date, the fields in the form, IP address and submission ID.
For further information please have a look at the user guide below.
I moved your second question to a new thread. Your question will be answered there.
If you have any question, please let us know.
- JotForm SupportemilyAnswered on November 17, 2016 at 07:58 AM
In addition to the solution above, you can download your submissions as excel files. However, since the fields will not be automatically updated after each submission, you will need to download it after each submission.
Please have a look at the user guides below for further information.