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

  • Profile Image
    HannahAsh
    Asked on July 13, 2018 at 09:22 AM

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

  • Profile Image
    Jan
    Answered 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.png

    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.png

    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.png

    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.gif

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

    1531497092subis.gif

    Hope that helps. Thank you.