What inactive column can be used for

Inactive columns are normal columns that can have data source, conditions and cards. They are existing Flexi Kanban object records, that have IDs and other properties - but they are just not rendered in Kanban.

You can use them in all places where you need to act with columns, e.g., in Totals calculations.

E.g., you want to show total revenue amount on all accounts in the top of kanban. There is no way to get this number directly without doing some programmer's magic, but you can get any totals with standard Flexi Kanban function applied to a column that contains ALL records. So:

  • Make a column that has no conditions (that means column include all records) with an Account object as a data source:

  • Get this column ID using merge field picker. Select context object "$Record" > Kanban Column > Id > %Column name%. Copy and save given column id for the future (e.g. at the field "Description" of this column), or in your favorite notes editor.

  • Use this column's ID in a formula with COLUMNTOTAL() function that will return a total by "Expected Revenue" field calculated for this hidden column and enter this formula into that cell

  • Apply created function and save kanban. Close kanban builder to see the result in the top of kanban:

Last updated