Summary

Summary is a table view that gives a brief overview of records. To create a summary view, select the Summary option from the list of view types and click Next. The system will display the Summary View form comprising the following sections:

General Properties

Name

Enter a name of a new summary view.

Notes

This field can hold any developer’s comments that need to be kept for this view. The comments will be visible in the Setup mode only.

Show In Menu

Leave this option checked if the view should be displayed in the menu.

Category

Enter a category name if you want to group view under a category.

Highlight Color

Select a color to highlight this view in the list displayed in the menu.

Icon

This option allows you to select an icon for a view. You have a choice of 900+ icons covering various subjects – actions, brands, file types, symbols, animals, and more. The Search box above will help you narrow down the list of choices.

In the User mode the icon will appear to the left of the view name listed in the left menu of the table.

Access

If you want to restrict access to the view for your users basing on their roles, select the Restrict access right by role checkbox and choose what roles will have access to this particular view.

Matching Properties

Filter

The Matching section is intended to set the filter criteria for the records that will be displayed in the view.

• All records: select if you want to include all records in the view;
• Only records that meet certain criteria: select if you want to filter records according to certain criteria. With the help of drop-down lists below create the rules according to which records will be filtered;
• Custom formula: select if you want to enter a custom formula and add the formula to the expanded field.

There is no way to filter a summary view by a calculated column value.

Ask the User

This filter option prompts the user to specify a value each time the view is accessed, allowing dynamic filtering based on their input.

• Nothing: option is disabled;
• Ask columns: the selected columns determine which fields the user will provide values for when applying the dynamic filter.
• Allow search for keywords: enables users to search within the column using keywords, making it easier to find specific records.

Grouping Properties

Grouping

In the Grouping section you specify how displayed records should be grouped. You can choose up to three columns whose values will be used for grouping.

Grouping options are expounded in the Grouping item.

Columns To Calculate

Columns

The Summary View contains columns where the data (amounts, number of records or dates) are aggregated by groups. A total amount, average, minimal (maximal) result or a number of records in a group (or all records if None grouping is set) can be calculated and shown in the summary view. Select one or several columns in the Columns to calculate section and the function you need. Also you can enter the alternative column name in the display as field (if the field is left empty, default naming convention is used).

There is no way to sort a summary view by a calculated column value.

Advanced Options

The Advanced options section is intended to specify additional options:

Details View

The Summary View contains an overview of table records, these records are grouped and results of such grouping are shown in cells. To see details on a certain group, the Details View option should be set and each grouping value will be displayed as a link. When a user clicks on such link, the details of a group are displayed. Detailed group information may be given in any view. You can define what view will be used to show details of the record groups. In the Details View dropdown you can select any view built in the same table.

Row Colorization

If you want to highlight certain rows, select the Colorization Formula check box and enter the formula into the expanded field. The details are expounded in the View Colorization item.

There is no way to colorize a summary view by a calculated column value.

Enable Embedding

This option allows you to copy/paste simple HTML snippet to embed a view on your website page. More details are described here Embedding Option for Views.

Help

When this text property is filled in, a view page displays a small dropdown titled "Help" just under the tab bar. When the user clicks it, it extends downward, displaying the text you’ve entered. Help text is formatted using markdown.

When finished, click Save to save changes or click Cancel to discard.