Is there a way to lookup data and dynamically autofill it in the dropdown field?

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.

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.

I 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
________________________________
...

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

Thanks a lot.
Warm Regards,
Dinakar
https://dinakarmurthy.com/
Sent from Outlook Mobile
________________________________
...