Transforming option values and pass it to another field

  • Profile Image
    okcommerce
    Asked on August 09, 2019 at 11:41 AM

    Can you set up text transformations on options in a Multiple Choice question? Example: Forms displays "[checkbox] Option Alpha", but returns "Opt. A" in the cell when exported to a spreadsheet. 

  • Profile Image
    John_Benson
    Answered on August 09, 2019 at 12:44 PM

    You can assign a value for each option in the Multiple Choice field. This value can be used to populate another field. So the idea is to pass the assigned value to another field so that once you exported it in Excel file, a column cell of the assigned value will be created. Here's a guide: How-to-Assign-Calculation-Value.

    Here's an example of assigning a value:

    1565368874assgn.png

    After that, you can use the Update/Calculate Field condition to copy the value of the Multiple Choice field to another field. Here's a guide: How-to-Insert-Text-or-Calculation-into-a-Field-Using-Conditional-Logic.

    1565368888cond.png

    Here's the result:

    1565369004calcvlae.gif

    Please take note that you can hide the field if you like to.

    Hope that helps. Thank you.