Transforming option values and pass it to another field

  • Profile Image
    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
    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:


    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.


    Here's the result:


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

    Hope that helps. Thank you.