-
okcommerceAsked 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.
Page URL: https://form.jotform.com/92065821602149 -
John_BensonReplied 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:
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.