Selection Lists
Selection lists function similarly to validation lists, with one key difference regarding the SaveToDB add-in.
The SaveToDB add-in does not generate Excel validation lists for selection lists. Instead, it loads the list and converts data table values without creating an Excel validation list. This means users can input any value they choose.
Users also have the option to select values using the List Editor task pane, accessible from the Options menu.
The configuration remains the same; simply 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 |