Every column in a list view carries a set of properties that control what it is called, how its value is rendered, how wide it is, and whether users can sort, filter, total or group by it. These properties are set in the Columns blade, one column at a time.

This article covers the property panel in full: the formatter catalogue and each formatter's options, column sizing, visibility, sorting, filtering, totals, and grouping.

Overview

A list view scope defines a query and a set of columns. The query comes from the list view provider. The columns are bound from the fields that provider exposes, and each bound column has its own properties.

Two things constrain what you can configure on any given column:

• The provider determines which formatters and filters are valid for each field. The Formatter and Filter dropdowns show only those options, so the choices differ from column to column.
• The provider also declares whether a field supports sorting, filtering and totals. The Sorting, Filters and Totals sections appear only for columns that support them.

The same Columns blade serves two audiences. Configurators change the columns for everyone. End users personalise the columns for themselves. The blade subtitle tells you which mode you are in.

Open the Columns blade

Configure columns for all users

1. Navigate to Modeller > Forms and Views > List Views.
2. Select the list view you want to edit, or select +New to create one.
3. Select Columns in the blade menu bar.

You can also reach the same blade from:

• A List View widget in the portal designer by selecting Edit scope.
• The burger menu on any list view by selecting Manage list view.

Personalise columns for yourself

1. Open any list view where customisation is allowed.
2. Select the burger menu.
3. Select Customise columns.

Changes save immediately against your own user record and apply to that list view wherever it appears. To revert to the configured columns, select Clear customisations from the same menu.

How the Columns blade is arranged

The blade has three panes.

Available columns

On the left, lists every field the provider exposes that is not yet in the list. Select Add to bind a column. Fields with no configured title display as [Field display name].

Bound columns

In the middle, lists the columns in the list, in display order. Each card summarises the column: the field it is bound to, its `FieldId`, the formatter, the filter, and a row of status icons. Use the arrow buttons to move a column up or down, and the bin button to unbind it. Select a card to edit its properties.

The status icons on each card are:

A tick displays against the column set as the default sort.

Selected column properties

On the right, holds the property panel. Its sections vary depending on what the selected column supports.

There is no numeric display order field. The order of the bound columns list is the order the columns render in.

Column identity and visibility

The top section of the property panel displays for every column.

	Column title	The header text end users see. Maximum 400 characters. Leave it blank and the header renders empty, with the bound column card displaying No title [field name].
	Column Icon	Use the icon picker to browse.
	Column header drop down from	Sets whether the header dropdown, and any inline row dropdowns in this column, open to the Left or the Right. The default is Left. Set it to Right for columns close to the right edge of the list so the menu does not fall outside the viewport.
	Hide this column on table views	Removes the column from table display modes.
	Hide this column on card views	Removes the column from card display modes. Hiding a column in both display modes is a deliberate pattern, not a mistake. Bind a column, configure it as the default sort, then hide it everywhere to sort a list by a field you do not want to display.

Format a column

The Format section holds the Formatter dropdown. The formatter decides how the value renders. For example, a date field can render as a plain date or as a date with a RAG indicator or a decimal field can render as a plain number, a percentage, or money.

Select a formatter and, where that formatter has options, a configuration panel displays beneath the dropdown. The dropdown lists only the formatters available for that field. 

Available formatters

Size a column

The Column size section controls width and overflow behaviour.

	Column Width	Choose: As wide as possible shares the remaining width with other columns set the same way. Use it for the one or two columns that carry the most content. Fit content sizes the column to its content. Use it for short, predictable values such as dates, references and status labels. Fixed size reveals a text field for a width in pixels. Use it where a column must stay a consistent width regardless of content.
	Wrap text	Allows cell content to wrap onto more than one line.
	Trim text when it overflows	Displays only when Wrap text is off. Truncates overflowing content with an ellipsis.
	Wrap text and Trim text when it overflows are mutually exclusive. Enabling Wrap text clears the trim setting, and the trim option disappears from the panel. Leave wrapping off on most columns so rows stay a single line high, and rely on trimming to handle long values.

Sorting

The Sorting section displays only for columns whose field supports sorting.

	Allow user to sort by this column	Adds a sort option to the column header dropdown.
	This will be the default list sort	Makes this column the initial sort for the list.
	Default sort order	Displays only when the column is the default sort. Set Ascending or Descending. You must and can only set one column as the default sort. Setting none, or more than one, raises a configuration warning.

Filtering

The Filters section displays only for columns whose field supports filtering. Select a filter to add a filter control to the column header dropdown, or leave it as No filtering.

The dropdown lists No filtering plus the filters the provider declared for that field. Where a filter has options, a configuration panel displays beneath it.

Totals

The Totals section displays only for columns whose field supports a total, which in practice means numeric and monetary fields.

Enable Show a total for this column to display a total in the totals row at the foot of the list.

Two things to note:

• Totals render in table display modes only. They do not display on card views.
• The totals row can be suppressed for an individual widget. If totals are configured here but no totals row displays, check Hide column totals on the List View widget in the portal designer.

Configuration warnings

A red Configuration warnings panel displays at the foot of the property panel when the column set is inconsistent. Clear these warnings before saving.