Can I upload multiple conditions in spreadsheet form?

  • Profile Image
    RDeYoungClearesult
    Asked on July 01, 2019 at 09:46 AM

    I have a spreadsheet of 148 different items, each with 11 different codes. I am looking to create a form that, when one of the 148 options is chosen, the output in Excel will automatically fill in the 11 different corresponding codes.

    Can I upload this spreadsheet into the conditions section (update/calculate field), or do I have to create an individual condition, one at a time, for each of the 148 options?

  • Profile Image
    Jed_C
    Answered on July 01, 2019 at 11:43 AM

    Can I upload this spreadsheet into the conditions section — Unfortunately, it's not possible to upload the spreadsheet into the condition.

    What you can do is use the Spreadsheet to Form widget and create a condition that If field is equals to X, copy field value into Spreadsheet to form widget.

    1561995483The Easiest Online Form Builde

    Once it met your condition, the value will auto fill into the Spreadsheet to form widget and user will just have to click on the widget's button so the data in the Spreadsheet will autofill into the fields.

    ex.

    1561995556spreadsheet_to_form.gif

    That's the workaround I can think of since you cannot directly put the spreadsheet into the conditional rule.

    I hope that helps. Let us know if you have any questions.

  • Profile Image
    RDeYoungClearesult
    Answered on July 01, 2019 at 12:43 PM
    Thank you, I will give this a try.
    I have come across another problem with this form, however. On multiple occasions while I have been uploading it, one of the options on my list has disappeared and another option keeps changing.
    Should I start a new ticket for this issue, or can you help me?

    ...
  • Profile Image
    Richie_P
    Answered on July 01, 2019 at 01:47 PM

    I have moved your question to a new thread to assist you better.

    Kindly follow this link https://www.jotform.com/answers/1876233

    Thank you.