Skip to main content
Configure the columns displayed in the data grid. You can add fields, create formula columns, and manage column settings.

​
Add Column

Add a new column from a field or a formula.

​
Add Field Column

1

Open Columns Dialog

From the data grid menu, click Columns.
2

Open Fields Tab

Select the Fields tab.
3

Select Field

Turn on the checkbox next to a field in the field picker.
4

Add to Columns

The field is added to Selected Columns.
For field details, see Fields.

​
Add Formula Column

1

Open Columns Dialog

From the data grid menu, click Columns.
2

Open Formula Tab

Select the Formula tab.
3

Enter Formula Details

Enter the required information.
4

Validate

Click Validate to check the formula.
5

Add

Click Add to create the formula column.
For syntax, operators, and functions, see Formulas.

​
Edit Column

Update column settings.
1

Open Column Menu

From a column header or Selected Columns, open the column dropdown menu.
2

Select Edit

Click Edit to open the dialog.
3

Update Column Details

Modify the required information.
4

Save

Click Save to apply changes.

​
Clone Column

Create a new column by copying an existing column.
1

Open Column Menu

In Selected Columns, open the column dropdown menu.
2

Select Clone

Click Clone to open the dialog.
3

Update Column Details

Modify the copied settings as needed.
4

Save

Click Save to create the column.

​
Delete Column

Remove a column from the data grid.
1

Open Column Menu

From a column header or Selected Columns, open the column dropdown menu.
2

Select Delete

Click Delete to remove the column.
For field columns, you can also remove them by turning off the checkbox in the field picker.

​
Hide Column

Hide a column without deleting it.
1

Open Column Menu

From a column header or Selected Columns, open the column dropdown menu.
2

Select Hide

Click Hide.
3

Show

Click Show to display the column again.
Hidden columns appear semi-transparent in Selected Columns but are not displayed in the data grid.

​
Reorder Column

Change the display order of columns.
  • Drag in Data Grid: Drag a column header left or right.
  • Reorder in Dialog: In Selected Columns, drag columns or use menu actions.

​
Pin Column

Keep a column visible while scrolling.
1

Open Column Menu

From a column header, open the column dropdown menu.
2

Select Pin

Choose Pin to left or Pin to right.
3

Unpin

Select Unpin to return to normal.