Selection Lists
The selection lists are the same as validation lists except for the SaveToDB add-in.
The SaveToDB add-in does not create Excel validation lists for selection lists.
I.e., it loads the list, converts data table values, but does not create an Excel validation list.
Users can input any value.
Also, users can use the List Editor task pane (from the Options menu) to select values.
The configuration is also the same. Just use the SelectionList event type in the xls.handlers table.
| ID | TABLE_SCHEMA | TABLE_NAME | COLUMN_NAME | EVENT_NAME | HANDLER_SCHEMA | HANDLER_NAME | HANDLER_TYPE | HANDLER_CODE |
|---|---|---|---|---|---|---|---|---|
| s02 | cashbook | account_id | SelectionList | s02 | accounts | TABLE | id, +name | |
| s02 | cashbook | item_id | ValidationList | s02 | items | TABLE | id, +name | |
| s02 | cashbook | company_id | ValidationList | s02 | companies | TABLE | id, +name |