Hi all! I had a quick post I wanted to write up on a fairly common topic - using SQL connectors to dynamically populate a dropdown input widget in a Tulip app. In this example, I’m going to query a SQL table that is storing a list of tasks so that I can select which task I want to begin in my appli…

FYI @twatkins this would have been an alternative approach to solving your custom widget problem earlier!

My struggle is getting the value back out of the drop down :slight_smile: I’ve done this before One way to do Tulip dropdowns from tables (and passing an ID) But I wish we could return the index from the selected item!

[image] mellerbeck: But I wish we could return the index from the selected item! You can: [image] [image]

Many thanks, I wonder when ARRAY_INDEX_OF was introduced (I hope I didn’t miss it when I tried it 2 years back!) [image] Updated way to do drop downs returning id of selected value Show and tell Create your table [image] Create your function [image] Load the data into …

Looks like it was added back in r232! [image] Release 232 - July 2022 Announcements Another exciting release has arrived for all accounts on the standard release cycle. Below are some highlights of the release! iphone App Editor The signature widget now supports the s…

Using SQL Connector to Populate Drop Down List

Show and Tell

Grant April 15, 2023, 3:40pm 7

Looks like it was added back in r232!

Topic		Replies	Views
Pass the connector result to App input drop down list options Support, Troubleshooting, & Help	6	1564	May 18, 2021
Using dropdown widget with Tulip table values General	2	1593	July 4, 2021
Table records in a select option General	27	4490	April 18, 2024
Drop Down as Text Box Editable Support, Troubleshooting, & Help	22	1856	July 2, 2021
[Tip of the Week] Getting Started with Arrays General weekly-tip	12	2780	May 18, 2021

Using SQL Connector to Populate Drop Down List

Related topics