Can I label individual questions so that it shows up in excel files as a certain title?

  • HannahAsh
    Asked on July 13, 2018 at 9:22 AM

    Can I attach labels to individual questions so that in data analysis the columns will be labeled? 

  • Jan
    Replied on July 13, 2018 at 11:51 AM

    Unfortunately, the Single Choice field (Radio Button) does not have a sub-label feature. The idea is to put the main title in the label and then the question in the sub-label. However, there is no sub-label for the Single Choice field.

    As a workaround, you can try this long method:

    1. Insert a Short Text Entry on each question. Put your preferred title in the label of the Short Text Entry.

    153149683407 13 pdyao Screenshot 10

    2. After that, assign a calculation value to each option in the specific question. Here's a helpful guide: How-to-Assign-Calculation-Value.

    153149685507 13 wucgv Screenshot 21

    3. Create an Update/Calculate Field condition that passes the value to the Short Text Entry field. Here's a guide: How-to-Insert-Text-or-Calculation-into-a-Field-Using-Conditional-Logic.

    153149687307 13 mklnl Screenshot 32

    4. After that, you can hide the Short Text Entry field so that it will not appear in the live form.

    Here's a screen capture of how it works:

    1531496703passvalui Screenshot 43

    5. In the Submissions page, you can just filter the fields before exporting it into an Excel file.

    1531497092subis Screenshot 54

    Hope that helps. Thank you.