How to make multiple choice field work with Spreadsheet to Form widget?

  • Profile Image
    ViaInsideSales
    Asked on October 05, 2018 at 10:33 AM

    I have the option multiple choice, but is not working, how has to be displaid in the excell cell?

    example of data in a cell:

    PAYMENT METHOD REQUIRED

    ACH,VIACHECK,E-CHECK

    SELECT DEPOSIT DAYS "

    MONDAY,WEDNESDAY,FRIDAY,



    This is a re-post of a comment on How to Use the Spreadsheet to Form Widget

  • Profile Image
    Mike_G
    Answered on October 05, 2018 at 12:29 PM

    I have made some test with the Spreadsheet to Form widget on a form that also has Multiple Choice fields and it seems to be working on my end.

    1538756921t12_15_50.png

    Here's my test form — https://form.jotform.com/82775112109959

    Please note that although the Field Label of the Multiple Choice fields in the form and the Column Header on the uploaded spreadsheet are not case sensitive, the options of the Multiple Choice fields and the values in the spreadsheet should have the same cases.

    You may refer to the details in the screenshot below to test my form.

    1538756844t12_26_26.png

    Please note that unique codes are also case sensitive.

    If you have any further questions, please feel free to let us know.