List selection input

A list selection input is used to select a record or value from a data source.

List selection inputs have the following properties:

• Target Variable The name of the new variable(s) in which to store the record selected.

• Table Variable Choose the table that will be the data source in the list.

• Default Selection Use Flow script to do a default selection of values. Example:

  {customerNo = 5}

• Result Transformation Use this if the output record variable differs from the selected target variable. Example:

  {[column1: orderNo, column2: orderDate]}

• Prompt The label to be displayed at the top of the list.

• Large Text Enter text and variables which are to be displayed in the list (can be left empty but observe that either large or small text needs to be configured to show something in the list). Use {} to get a list of available variables from the source table.

• Small Text Enter text and variables which are to be displayed in the list (can be left empty but observe that either large or small text needs to be configured to show something in the list). Use {} to get a list of available variables from the source table.

• Group Rows By If the list should be grouped choose a column from the source table to group the list by. Set to "none" to not group the list.

• Condition To Hide

  Add the condition that must be met for the control to be hidden. If left empty, the control will be visible in the user step. Note that when controls are hidden, empty variables will be created, unless default values or pre-defined data exist.

• Item Style Use a case statement to decide what color the columns should have. Example:

  {case
      when Id = '1' then '#15A9E1'
      when Id = '2' then RGB(146,147,149)
      when Id = ‘3' then 'YELLOW'
      else '' 
  end}

  Colors: Set the color using the FlowScript RGB function plus RGB code or use the color HEX code. There is also a fixed color pallet available: GREEN, RED, YELLOW, BLUE and PURPLE.

• Inline Option

  Setting if the list is to open directly or not in the user step. The setting is available from Flow 6.14 and only for new generation clients.

  • Automatically - the list is open or closed depending on size and user step content, see List selection and list multi-selection.

  • Open - the list will always open inline.

  • Closed - the list will always be closed in the user step and the user must click to open it.

• Show Automatically If set to True the list will be open directly when the user steps into the user step (only in mobile clients) so the user does not need to open the list and after that choose from the list, and in that way make the workflow more user friendly.

New generation mobile clients do not use the Show Automatically setting but are open or closed depending on size and user step content, see List selection and list multi-selection.

From Flow 6.14 it is recommended to use the Inline Option setting instead of Show Automatically to control the list behavior.

• Match By

  • Rows: If a barcode scanner is used in a list selection input, the Flow Client will search the data source for a record where the Key field matches the scanned value and select the corresponding line in the list. If no match is found, the Flow Client will attempt to match the other fields on the data source to the scanned value and select the first line where a match is found.

  • Specific Columns: Enables Match Columns.

• Match Columns Click Edit to open the Match Columns pop-up. In Match Columns it is defined which columns should be matched when scanning and in which order (top to bottom). When Specific Columns has been selected the scanning is on exact match only, regardless of client settings. Letters in upper or lower case are seen as separate values.

Example of Match Columns

If the list look is empty, make sure that variables are entered in the large and/or small text fields.

• Allow Empty Input If set to True, the workflow is allowed to move forward without input.

• Reloading

  The control behavior at reloading, see User step reloading.