Hi Experts, I want to have a dropdown which values/attributes are need to fetch from external DB using query. Explanation: i have an external DB with Site and Project Column. Lets say i have my 1st drop down which contains all the site detail (India,Japan,Isreal..etc), when user select any option from the 1st dropdown it should trigger some microflow and execute the query (Select Project from Testtable where site =”whatever user select in 1st dropdown”) and show the result in 2nd dropdown. Please help me to achieve this.
Hi Abhishek Bhardwaj,
Check this Database Connector Module. This will suit your use case to load the data from the external database.
I suggest to check the widget Searchable Reference Selector on the Marketplace. You can refer a MF for the selectable objects.
This widget does not provide solution to query external DB. That requires some kinds of DB connector such referred by Dinesh.