List selection input

A list selection input control is utilized to choose a record or value from a data source.

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

• Table Variable Select the table that will serve as the data source for the list.

• Default Selection Utilize FlowScript to perform 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 to be displayed in the list (this can be left empty, but note that either large or small text needs to be configured to show something in the list). Use {} to access a list of available variables from the source table.

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

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

• Item Style Utilize a case statement to determine the color that 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 followed by the RGB code or use a HEX code for the color. Additionally, you can use predefined colors from the fixed color palette: GREEN, RED, YELLOW, BLUE, and PURPLE.

• Inline Option

  Configure whether the list should open directly in the user step or not.

  • 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 open directly when the user enters the user step (only in mobile clients). This allows the user to select from the list immediately without having to manually open the list, thereby enhancing the user-friendliness of the app.

• Condition To Hide

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

• 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 scanned value with the other fields in the data source 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, you define which columns should be matched when scanning and in which order (top to bottom). When "Specific Columns" has been selected, scanning is based on an exact match only, regardless of client settings. Letters in upper or lower case are treated as separate values.

• Allow Empty Input If set to True, the app is permitted to progress without requiring input.

• Reloading

  The control behavior at reloading, see User step reloading.