Spreadsheet to Form widget: Fields is not auto populating

  • asimsidiqi
    Asked on November 17, 2021 at 11:25 PM

    please see the screenshot below:

    I put excel sheet but no options are filled in human resources dropdown.

    Please let me know what is the issue?

    1637209372 6195d51c6b174  Screenshot 10

  • Mike_G JotForm Support
    Replied on November 18, 2021 at 6:09 AM

    We will be glad to help you with your concern. Please allow me some time to test the issue you are having on my end and I'll get back to you on this ticket with my findings/solution as soon as possible.

  • Mike_G JotForm Support
    Replied on November 18, 2021 at 6:31 AM

    Apologies for any delays. Upon checking further, I found that the issue is with the drop-down field on your form. It appears that there are still no options added under it.

    1637234919 619638e79edb0 zt211118 062708 Screenshot 10

    Please try to add options on the drop-down field on your form that matches the data under the Human Resource column of the Excel File you uploaded on the Spreadsheet to Form widget.

    Feel free to let us know if you need any further assistance.

  • asimsidiqi
    Replied on November 19, 2021 at 1:02 AM

    is it possible the options pre populate from excel sheet?

  • Mike_G JotForm Support
    Replied on November 19, 2021 at 3:17 AM

    I'm afraid that it is not possible to get the options of the fields on your form from an outside source. You would have to set the options on a dropdown field on the builder page. Otherwise, you can change it into a different field type, like the Short Text element.

    Feel free to let us know if you need any further assistance.