Using SQL Connector to Populate Drop Down List

[mellerbeck]

Many thanks, I wonder when ARRAY_INDEX_OF was introduced (I hope I didn’t miss it when I tried it 2 years back!)

Updated way to do drop downs returning id of selected value

Create your table [image] Create your function [image] Load the data into an array. And then map it to a text list (so the drop down can use it) [image] Create a single select, and create its ‘selected value’ [image] Populate the drop down from the drop_down_list [image] Now write a trigger to populate the selected index [image] [image]