1. Module Name: Give a name to your module.
2. Select "Select-List" module and click Create.
FORM Element Plug-In module for building a STATIC or DYNAMIC dropdown selection list to be linked to a dropdown list form element.
Select-List are used as plug-in modules in forms. It is used for adding selection and choices type behaviour to your form. Only one selection or choice can be made at any given time. Select-List require two (2) paramaters:
1. Value - a unique value for each of the option in the List.
2. Text - a display text or label to represent the option in the List.
Static or Fixed Select-List is useful if you have a finite or a predetermined sets of selection or choices. When setting up Static Select-List, each of the option must be added manually.
Example of adding Static or Fixed options to the Select-List, one at the time.
See example of Static or Fixed Values Select-List.
When setting up Dynamic Select-List, an SQL Query module plug-in is required to query dynamic values and labels from a database table. First, each option in the List require a unique value so the database primary key field will be appropriate for this, and second each button will need labels or Text to which is what will be displayed.
SQL Query must contain the Primary Key (PK) field to be used as option Value and any field representing a name to be used as option Text.
From Types of Values field, select Dynamic Values(SQL) and select the SQL Query plug-in module to be used