-
samuthanaAsked on February 21, 2021 at 9:11 AM
I want to know how to get the drop down options from a connected table (data from, say form A) for a field in a form B and then auto populate some other fields in form B based on the data in the connected table (data from, say form A), before manually filling the other fields in form B. I need this feature for a mobile form application.
Please let me know the solution or a workaround.
-
roneetReplied on February 21, 2021 at 1:03 PM
You may use a Spreadsheet to Form widget to populate the data from the attached Excel sheet to the form:
https://www.jotform.com/help/442-how-to-use-the-spreadsheet-to-form-widget
Let us know if this would work for you.
Thanks.
-
samuthanaReplied on February 21, 2021 at 1:22 PMI checked that. The problem is that the lookup data in this case is static. I want it to be dynamic, based on the new updating of this file.
Warm Regards,
Dinakar
https://dinakarmurthy.com/
Sent from Outlook Mobile
________________________________
... -
Welvin Support Team LeadReplied on February 21, 2021 at 6:51 PM
Yes, the widget requires a static source. Unfortunately, there is no option to dynamically fill the source of the dropdown field. We do not have that feature yet in the form builder.
I'm sorry to say, but we do not have a workaround for this. You can utilize the spreadsheet to form widget and just change the source manually when new data comes in.
Thanks
-
samuthanaReplied on February 21, 2021 at 8:22 PMThanks a lot.
Warm Regards,
Dinakar
https://dinakarmurthy.com/
Sent from Outlook Mobile
________________________________
...