SOLVED
Update a Drop Down List from a SQL Query
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
giorg90
6 - Meteoroid
‎12-11-2017
08:39 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi guys,
I am using a Drop Down tool in my app. I would like to dynamically update the option list as the output of a SQL Query. For example, if my query produces a list of customer, I want the app allows to choose among all customers in that list.
How can I do it?
Thank you,
Giorgio
Solved! Go to Solution.
Labels:
- Labels:
- Apps
2 REPLIES 2
20 - Arcturus
‎12-11-2017
09:37 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Youtube post: https://www.youtube.com/watch?v=0Wm8vIwnD6c
Youtube video:
This post shows how to chain/link applications so that the first app reads the database and prepares the listbox to include relevant options in the second application.
Cheers,
Mark
Alteryx ACE & Top Community Contributor
Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
‎12-12-2017
12:34 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks,
Actually we found the solution by selecting External Source in the drop down menu
And then typing the SQL query in "Properties" field
