Posts Tagged ‘Concatenate’

Canvas App | Formula to combine combo box selected items

November 2, 2022 1 comment

In this short blog post, lets see how to write formula to combine combo box selected items in to text with a separator.


Single column collection:
  • If the Combo box items is a single column collection as specified below.
  • Use ‘ThisRecord.Value’ in the Concat function.
    • Formula : Concat(cmbFruits.SelectedItems,ThisRecord.Value,”,”)

Multi column collection:
  • Use ‘ThisRecord.{Attribute_Name}’ in the Concat function.
    • Formula : Concat(cmbFruitsTable.SelectedItems,ThisRecord.Name,”,”)