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 displayed at the top of the list.

  • Large Text Enter text and variables that should 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 that should 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.

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

    {case when objStatus = 'Planned' then 'PURPLE' 
          when objStatus = 'Released' then 'GREEN' 
          when objStatus = 'Rested' then 'RED' 
          else '' end}

    Colors: GREEN, RED, YELLOW, BLUE and PURPLE Log on to the Flow community to download an example workflow of item style: http://community.novacuraflow.com/product/670/

  • 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.

  • Show Automatically If set to True the list will be open direct 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.

The new generation mobile clients do not use the Show Automatically setting. For more information see list selection help in Flow Help for 6.13.

  • 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 have been selected the scanning is on exact match only, regardless of client settings. Letters in upper or lower case are seen as separate values.

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

Last updated