Spreadsheet to Form widget: Fields is not auto populating

  • Profile Image
    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_

  • Profile Image
    Mike_G
    Answered on November 18, 2021 at 06: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.

  • Profile Image
    Mike_G
    Answered on November 18, 2021 at 06: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

    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.

  • Profile Image
    asimsidiqi
    Answered on November 19, 2021 at 01:02 AM

    is it possible the options pre populate from excel sheet?

  • Profile Image
    Mike_G
    Answered on November 19, 2021 at 03: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.