Dropdown Field: Can I Import data from external source into dropdown list?

  • Profile Image
    tecknow
    Asked on February 11, 2021 at 07:30 AM

    I can see that a table collates data from the linked form submissions. But can it also work the other way around. Can a form field (dropdown or checkbox type) lookup a dataset from the linked/connected column in a table and give users the options from which to select their response?

  • Profile Image
    Zahra_S
    Answered on February 11, 2021 at 07:41 AM

    Hi there!

    Thank you for reaching out to us.

    Unfortunately, it is not possible to fill the options of the dropdown from an external source.

    You may use the Spreadsheet to Form widget. This widget enables you to upload an excel file that houses all the options. It acts like an auto-fill or like querying a database using a unique code. To know more about it and how to use it, please check out this guide:

    How-to-Use-the-Spreadsheet-to-Form-Widget

    If the widget is not helpful for your requirement, you would have to write the data in the drop-down options manually. You cannot connect the form to the database to get the value.

    I hope this helps. Please let us know if you need further assistance.