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

  • Profile Image
    juliasimmons
    Asked 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
    ashwin_d
    Answered 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!