-
gsmcclellanAsked on May 27, 2016 at 11:12 AM
Hello - can I create hidden fields that won't show up to the person filling the form out, but will be part of the form when we download as an excel file? We would use these for inter-office notes, etc...for each response we get, but not sure if I can add hidden fields.
Also, as we receive new responses to our form, is it possible to download them in a way that will just add to our existing excel file? Or can we only download each response as its own excel file?
-
David JotForm SupportReplied on May 27, 2016 at 11:51 AM
The following thread describes how to set up an approval type workflow:
https://www.jotform.com/answers/401633-How-can-I-create-approval-workflow-in-JotForm
It uses a form collapse in conjunction with show/hide conditions to hide an approval section from the user filling out the form:
http://www.jotform.com/help/196-Hide-or-Show-Multiple-Fields-at-Once?updatemessage=892245969
When exporting your data to Excel, all submissions currently shown in the submission view for your form will be included in the spreadsheet:
http://www.jotform.com/help/44-How-to-Export-Form-Data-to-Excel
Submission data can be filtered and then exported.
If you would like a dynamically updated spreadsheet, you can integrate your form with a Google docs spreadsheet: