Transforming option values and pass it to another field

  • okcommerce
    Asked on August 9, 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. 

  • John_Benson
    Replied on August 9, 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 Screenshot 10

    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 Screenshot 21

    Here's the result:

    1565369004calcvlae Screenshot 32

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

    Hope that helps. Thank you.