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

    Hidden Fields

    Asked by gsmcclellan 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? 

     

    hidden excel office create
  • Profile Image
    JotForm Support

    Answered by david 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:

    https://www.jotform.com/blog/57-Google-Docs-Integration-Send-Responses-to-Google-Spreadsheets-Instantly-