Save as PDF

When to Use Drop-Downs as Answer Types in Excel

Overview

If you respond to a question which has choices, and respond only in a column or cells which have a predefined drop-down fields, select drop-down as the answer type.

There are two options for the drop-down answer type:

  • Normal:
    mceclip0.png
  • Predefined: The application automatically identifies these.
    mceclip7.png

Select the applicable tab for your edition of Responsive.

  • Using Normal Drop-Downs

    1. Select the answer column and map it with ANSWER from the right menu options.
    2. Change the Answer Header as Response.
    3. Select the Answer Type as Dropdown. 
    4. Enter values in the Value in File and Value in UI fields.
      Note: Values in the UI must be unique; same values are not accepted.
    5. Click Add Answer Option to add more values; then click Save.
    6. The Answer Configuration pop-up displays. Click Save.
    7. Click Import to import the file.
    8. In the Answering Page, click Select the value and choose a value from the drop-down.
    9. Answer the questions and export the responses in the source. You can find the responses in the exact column.

    Using Predefined Drop-Downs

    1. Click the auto-identify drop-down icon; then select the answer column and map it with ANSWER from the right options menu.
    2. The Answer Configuration pop-up appears. 
    3. Click Auto-Identify drop-downs. The Select Answers pop-up appears.


    4. Select the checkbox to change the answer header (if required) and then click Apply.
    5. Click Save and then Import.
    6. In the Answering Page, answer the questions and export the response in the source file.


      The exported file displays as shown below:

  • Essentials features are subscription-based and may not be available for all users. Contact your account manager, or accountmanagers@responsive.io, for more details.

    Using Normal Drop-Downs

    1. Select the answer column and map it with Answer from the left menu options.
    2. Change the Answer Header as Response.
    3. Select the Answer Type as Dropdown. 
    4. Enter values in the Value in File and Value in UI fields.
      Note: Values in the UI must be unique; same values are not accepted.
    5. Click Add Answer Option to add more values; then click Save.
    6. The Answer Configuration pop-up displays. Click Save.
    7. Click Import to import the file.
    8. In the Answering Page, click Select the value and choose a value from the drop-down.
    9. Answer the questions and export the responses in the source. You can find the responses in the exact column.

    Using Predefined Drop-Downs

    1. Click the auto-identify drop-down icon; then select the answer column and map it with ANSWER from the right options menu.
    2. The Answer Configuration pop-up appears. 
    3. Click Auto-Identify drop-downs. The Select Answers pop-up appears.


    4. Select the checkbox to change the answer header (if required) and then click Apply.
    5. Click Save and then Import.
    6. In the Answering Page, answer the questions and export the response in the source file.


      The exported file displays as shown below:

Was this article helpful?

/