I want to create a DropDown Field from the values in the Table.
-
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?
This is a re-post of a comment on How to Get Data from Other Forms in Jotform Tables
-
ChristianAnswered on September 26, 2022 at 02:27 AMJotform Support
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:
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.wolfurtAnswered 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
-
LeonidasAnswered on October 20, 2022 at 04:52 AMJotform Support
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.