Can data in drop down fields be returned comma delimited in the Excel download? In the screenshot attached, you can see that grades 2 and 8 were selec

  • Profile Image
    Asked on August 08, 2019 at 01:43 PM
  • Profile Image
    Answered on August 08, 2019 at 02:52 PM

    You can only achieve this, if you assign calculation values to your multiple choice field options and pass the selected option to the Form Calculation widget. Then you can display the Form Calculation widget with selected options instead of the multiple choice field in your Excel reports.

    How to Assign Calculation Value

    The Multiple choice field should be set as String (A-Z) inside of the Form Calculation widget.

    Let us know if you need any further assistance.