On a multiple choice field, how can the selection show up as just one character when I download the form to excell?

  • Profile Image
    joelrtaub3939
    Asked on January 29, 2019 at 02:52 PM

    On a multiple choice field, how can the selection show up as just one character when I download the form to excel?

  • Profile Image
    Victoria_K
    Answered on January 29, 2019 at 04:42 PM

    We do not have a direct option to implement what you have shared. But, I can suggest the following:

    1. You can assign calculation values to options of multiple choice field: How-to-Assign-Calculation-Value

    2. Then, with help of additional field you could capture calculation values for multiple choice field: How-to-Perform-Form-Calculation-Using-a-Widget

    3. As result, you can include a calculation field on your excel report instead of multiple choice field: How-to-Create-an-Excel-Report

    Hope this helps! But, please get back to us if you need further assistance.