I want to create a DropDown Field from the values in the Table.

  • Azrin Sani
    Asked on September 25, 2022 at 11:06 PM

    I want to create a DropDown Field from the values in the Table. How do I do that?

  • Christian JotForm Support
    Replied on September 26, 2022 at 2:27 AM

    Hello Azrin,

    Thanks for reaching out to Jotform Support. Unfortunately, it is not possible to pull data from the Submission Table or any third-party spreadsheet into the Dropdown form element; right now, you can only copy the data and paste them into the Options field of the Dropdown element, as seen below:

    1664173584 63314610c4af2  Screenshot 10

    We can raise this to our Developer Team as a feature request but we'll need a little more information. By Table, are you referring to the Submission Table or a third-party spreadsheet like Google Sheets or MS Excel? If it's the Submission Table, are you also looking to dynamically update the options in the Dropdown field if the Submission Table is updated?

    As soon as we hear back from you, we can move forward with a solution.

  • av.wolfurt
    Replied on October 20, 2022 at 4:32 AM

    Hi

    We have the same requirement and I'd like to answer your questions:

    Table for Lookup shall be a submission table from another form.

    Whenever the submission table gets a new record, it shall be on-the-fly available in the dropdown field of the other form. So yes, dynamically update of the selection options

    BR Martin

  • Leonidas JotForm Support
    Replied on October 20, 2022 at 4:52 AM

    Hello Martin,

    Thanks for getting back to us. The feature you’re looking for isn’t currently available, rest assured we’re always working to add new services and features to Jotform.

    I've gone ahead and escalated your request to our Developer Team. When or if it's developed depends on their workload, how viable it is, and how many other users request it.

    If there are any updates, we’ll circle back to this thread and let you know.