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

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



    This is a re-post of a comment on How to Get Data from Other Forms in Jotform Tables

  • Profile Image
    Christian
    Answered on September 26, 2022 at 02: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_

    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.

  • Profile Image
    av.wolfurt
    Answered on October 20, 2022 at 04: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

  • Profile Image
    Leonidas
    Answered on October 20, 2022 at 04: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.