Azrin SaniAsked 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 SupportReplied on September 26, 2022 at 2:27 AM
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:
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.wolfurtReplied on October 20, 2022 at 4:32 AM
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
Leonidas JotForm SupportReplied on October 20, 2022 at 4:52 AM
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.