Selection Table
This macro displays a list of predefined choices and inserts one of the data fields within the phrase placeholder. Several standard Windows controls are supported - ListBox, DropDown, ComboBox, Radio and Lookup search. Input selection dialog window will appear when command is executed to allow user input.
The macro is similar to a Selection Form macro but much more powerful as it allows the output of multiple fields from the table with a single selection.
•Name - The unique name of the field. The field name cannot contain blanks or special characters. Two fields with the same name and of the same type are treated as one - the user input is only required once.
•Description (optional) - Description of a field to be shown on the input dialog.
•Type - Select one of the standard Windows selection controls - ListBox, DropDown, ComboBox, Radio and Lookup search. Lookup search should be used for larger tables.
•Table - Select a table from the list or select New to create a new table. Select a folder button to open a table from a disk. Select a folder button to rename or delete tables.
•Selections - List of available selections, one selection text per line. Right click to open a context menu to add, edit or delete table cells or columns. The selection or search is always performed on the first column (Selections).
To improve visibility, add a description prefix to selections. In such cases only the description will appear on an input selection dialog. The default description separator is "::" and can be changed in Preferences > Text Expander.
•Return column(s) (optional) - Comma delimited list of one or more table columns to be returned as an output. Leave this field blank to return all the columns.
•Output separator (optional) - Specify separator characters to be shown between multiple return fields..
•Force Query (optional) - If multiple Selection Table macros in the same command are using the same table, FastKeys only asks for the user input once. Select this option to force a separate user input.
•Remember last input (optional) - If this option is enabled, the last user selection will be pre-selected when calling the macro next time.
•No output (optional) - Enable this option to instruct FastKeys not to output the value. This is useful for using the values later in the conditional statements, calculations or scripts.
•Output format (Optional) - The macro output can be further processed by several additional macro functions. See: Output format
Select OK to insert a %TABLE_Name% macro field into the command. Double-click on the field name to open the dialog and edit the macro properties again.
In the following example, the user will be asked to select a patient's gender to further adjust the phrase.
The patient is associated with several symptoms. %TABLE_Gender1% is advised to stay home. %TABLE_Gender2% blood pressure is normal.
TABLE_Name field variables can also be used in the conditional statements, calculations or scripts.