Columns

Easily configure your columns from fields and formulas.

How to open

• From the data grid toolbar menu, click Columns to open the Columns dialog.

• Or click Columns from a column menu popover to open the Columns dialog.

Add Field Column

• In the Fields tab, turn on the checkbox next to a field in the field tree.

• The field is added to Selected Columns.

Add Formula Column

• Open the Formula tab.

• Input Fields

  • Column Label — the header text shown in the data grid.

  • Data Type — the formula’s output type.

  • Formula — your expression built with fields, operators, and functions.

  • Treat blank fields as zeroes / Treat blank fields as blanks — choose how blanks are evaluated during calculation.

• Buttons

  • Validate — checks that the formula syntax is valid and shows errors if any.

  • Add — enabled after a successful validation; adds the new formula column to Selected Columns.

• For Formula Editor, full syntax, operator details, and function reference, see the Formulas.

Edit Column

• From a column header open the column menu and click Edit or from Selected Columns click the column’s popover icon button and click Edit.

• Input Fields

  • Label — the header text displayed in the data grid.

  • Alias — alias of column.

  • Name — the unique system name for this column.

  • Hidden — hides the column in the data grid.

  • Column Type — the column’s type.

  • Data Type — the column’s output type.

  • Formula — the expression for formula columns.

  • Treat blank fields as zeroes — interpret blanks as 0 during calculations.

  • Treat blank fields as blanks — keep blanks as empty so they do not contribute to calculations

• Buttons

  • Save — applies your changes to the column.

  • Cancel — closes without saving.

Clone Column

• In Selected Columns, click the column’s popover icon button, then Clone.

• Opens a dialog with the same Input Fields and Buttons as Edit Column.

Hide Column

• From a column header, open the column menu and click Hide.

• Or in Selected Columns, click the column’s popover icon button, then Hide.

Delete Column

• From a column header, open the column menu and click Delete.

• In Selected Columns, click the column’s popover icon button, then Delete.

• In the Fields tab, turn off the checkbox for that field in the field tree to remove its column.

Reorder Column

• Drag a data grid column header left/right to change its position.

• In the Columns dialog, drag a column in Selected Columns or use Move Up / Move Down buttons to reorder.

Pin Column

• From a column header menu, choose Pin to left or Pin to right to lock a column in place.

• Choose Unpin to return the column to normal scrolling.

Buttons

• Save — applies all changes to the data grid.

• Close — closes the dialog without applying unsaved changes.

Behavior details

• Formulas refers to Formulas.