What inactive column can be used for
Last updated
Last updated
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 that has no conditions (that means column include all records) with an Account object as a data source:
Apply created function and save kanban. Close kanban builder to see the result in the top of kanban:
Get this column ID . 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.
Add a to that will show some total amount, e.g. Total Expected Revenue
Use this column's ID in a formula with that will return a total by "Expected Revenue" field calculated for this hidden column and enter this formula into that cell
