Columns

Documentation Index

Fetch the complete documentation index at: https://coconut-grid.mintlify.app/llms.txt

Use this file to discover all available pages before exploring further.

​

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.