Selection Lists

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.

IDTABLE_SCHEMATABLE_NAMECOLUMN_NAMEEVENT_NAMEHANDLER_SCHEMAHANDLER_NAMEHANDLER_TYPEHANDLER_CODE
 s02cashbookaccount_idSelectionLists02accountsTABLEid, +name
 s02cashbookitem_idValidationLists02itemsTABLEid, +name
 s02cashbookcompany_idValidationLists02companiesTABLEid, +name