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

    Is there a way to display "Text" field content, in the excel document?

    Asked by juliasimmons on May 16, 2017 at 09:14 PM

    hi, 

    I am setting up an observational study. In my form I include a description of a location, and then ask two questions about the location. I then repeat this pattern.  

    I have inserted a description of the location as 'text' in the form as the person filling out the form reads it and doesn't need to add information,. I have used drop down menus for the associated questions. This works well, however when i download the responses there is not text descriptor included.

     

    Is there a way to include the text descriptor in the downloaded excel document response file? What if I download a different type of file?

  • Profile Image
    JotForm Support

    Answered by ashwin_d on May 17, 2017 at 01:15 AM

    Hello juliasimmons,

    If I understand your question correctly, you want to show the content of "Text" field in integrated google spreadsheet or downloaded excel file. Is that correct?

    Please note that the content of text field is not saved in submission. Its a static content which remains same for all users/submissions. Unfortunately it is not possible to include the "Text" field in the submission excel file but with a little workaround, it is possible to achieve your requirement. Here are the steps you need to follow:

    #1. Add a hidden textbox (Short Text Entry) or textarea (Long Text Entry) field in form.

    #2. Copy the content of your "Text" field and set the "Default Value" of in textbox or text area.

    #3. The same steps needs to be followed for all the "Text" field you have in your form.

    Please check the screenshot below:

    Once this is done, every time you download submission excel, it will include the columns for the hidden textboxes.

    Hope this helps.

    Do get back to us if you have any questions.

    Thank you!