Online Help | Desktop App

Customize View window

The Customize View window allows you to configure various view customization options. To access this window, right-click anywhere in a grid and select Customize View from the pop-up menu.

TIP: Shared views can be customized in the General > Shared Views > [Object Class] section of the Settings App. For details on customization of shared views, see Setting up shared views.

The Customize View window has the following tabs:

  • Fields - allows you to add and remove record fields to/from the current view.

  • Advanced Filter (can be hidden when customizing some grids) - allows you to configure the Advanced Filter.

  • Grouping (can be hidden when customizing some grids) - allows you to configure multi-level grouping of records.

  • Summary (can be hidden when customizing some grids) - allows you to configure summary statistics to show in footers.

  • Sorting - allows you to specify the options for multi-level sorting of records and define the order of records retrieval from the database.

  • Conditional Formatting - allows you to configure the options for marking certain records with different colors and fonts.

  • Options (can be hidden when customizing some grids) - allows you to set different view display and grouping options.

Fields tab

The Fields tab allows you to show or hide in the grid certain columns displaying record fields.

  • Available Fields pane - lists the records fields not displayed in the grid.

  • Show These Fields pane - lists the records fields shown in the grid. The order of columns corresponds to the sequence of columns in the grid.

  • Add - makes the field selected in the Available Fields pane visible in the grid and moves the field to the Show These Fields pane.

  • Remove - removes the field selected in the Show These Fields pane from the grid.

  • Add All - makes all available fields visible in the grid and moves them from the Available Fields pane to the Show These Fields pane.

  • Remove All - hides all fields in the grid and clears the Show These Fields pane. You will need to make visible at least one field before you are allowed to apply the changes.

  • Move Up b>- allows you to change the order of columns in the grid and moves the field selected in the Show This Fieldsb> pane one position up.

  • Move Down - allows you to change the order of columns in the grid and moves the field selected in the Show This Fields pane one position down.

Advanced Filter tab

The Advanced Filter tab allows you to configure filtering records at their retrieval from the database (in contrast to the Quick Filter which selects the records satisfying filtering criteria from already retrieved ones).

The Advanced Filter tab can be shown in one of the following modes:

Grouping tab

The Grouping tab allows you to configure the grouping of records in the grid.

  • Available Fields pane - lists the grid columns except for the columns by which the records are grouped.

  • Group by These Fields pane - lists the grid columns by which the records are grouped. The order of columns corresponds to the sequence of grouping levels.

  • Add - allows you to group records by the column selected in the Available Fields pane. When you click Add, this column name moves to the Group by These Fields pane.

  • Remove - allows you to remove the grouping level corresponding to the column selected in the Group by These Fields pane. When you click Remove, this column name moves to the Available Fields pane.

  • Remove All - allows you to ungroup all records in the grid. When you click Remove All, all column names in the Group by These Fields pane move to the Available Fields pane.

  • Move Up - allows you to change the sequence of grouping levels. Clicking Move Up moves the column name selected in the Group by These Fields pane one position higher.

  • Move Down - allows you to change the sequence of grouping levels. Clicking Move Down moves the column name selected in the Group by These Fields pane one position lower.

Summary tab

The Summary tab allows you to configure displaying summary statistics in the grid and group footers. Make sure the relevant footers are enabled before you can see the statistics; for details, see Showing and hiding footers.

  • Available Fields pane - lists the grid columns except for the columns for which some summary statistics is shown.

  • Define Summary for These Fields pane - lists the grid columns for which some summary statistics is shown and displays the kind of statistics.

  • Add - allows you to add either grid or group or both summary statistics for the field selected in the Available Fields pane and moves this field to the Define Summary for These Fields pane.

  • Remove - allows you to remove grid and group summary statistics for the field selected in the Define Summary for These Fields pane and moves this field to the Available Fields pane.

  • Remove All - allows you to remove all summary statistics from the grid and group footers and clears the Define Summary for These Fields pane.

Sorting tab

The Sorting tab allows you to configure the sorting of records in the grid and also the order of records retrieval from the database.

  • Available Fields pane - lists the grid columns except for the columns by which the records are sorted.

  • Sort by These Fields pane - lists the grid columns by which the records are sorted and shows the sorting order (either ascending or descending). The order of columns corresponds to the sequence of sorting levels. If the grid records are grouped by one or more columns, these columns are shown at the top of this list (once the records are grouped, they are automatically sorted by the same columns ).

  • Add - allows you to sort records by the column selected in the Available Fields pane. When you click Add, this column name moves to the Sort by These Fields pane.

  • Remove - allows you to remove the sorting level corresponding to the column selected in the Sort by These Fields pane. When you click Remove, this column name moves to the Available Fields pane.

NOTE: You cannot cancel sorting by the columns by which the records are grouped. These sorting levels can be cancelled by ungrouping records.

  • Move Up - allows you to change the sequence of sorting levels. Clicking Move Up moves the column name selected in the Sort by These Fields pane one position higher.

  • Move Down - allows you to change the sequence of sorting levels. Clicking Move Down moves the column name selected in the Sort by These Fields pane one position lower.

NOTE: You cannot change the order of sorting levels for the columns by which the records are grouped. They are always shown at the top of the list and their order is defined by the order of grouping.

  • Retrieval Order section - allows you to select the record field by which to sort the records at their retrieval from the database and choose the sort order (either ascending or descending).

Conditional Formatting tab

This tab allows you to highlight records with different background colors based on custom conditions. As an alternative or in addition to background color, records can be highlighted by text formatting such as font style, font color, size, etc.

You set up highlighting by defining conditional formatting rules. A rule consists of a highlighting condition, a highlighting format (background color and/or text properties) and a highlighting scope (row, column or first column). Conditional Formatting rules are listed on this tab. If a record satisfies a condition, it is highlighted using the format defined in the rule. If a record satisfies the condition of two or more rules, it is highlighted in accordance with the first (uppermost) rule in the list.

You can manage conditional formatting rules using the following buttons:

  • Add - allows you to create a new rule and opens an empty Conditional Formatting Rule window.

  • Edit - opens the selected rule in the Conditional Formatting Rule window so that you can modify it.

  • Copy - creates a copy of the selected rule and opens the Conditional Formatting Rule window so that you can modify it.

  • Move Up - moves the selected rule one position up in the table, thereby changing its priority.

  • Move Down - moves the selected rule one position down in the table, thereby changing its priority.

  • Delete - removes the selected rule.

Conditional Formatting Rule window

The Conditional Formatting Rule window allows you to create a new rule or modify an existing one. A rule consists of a condition and a format: background color and/or text properties.

The window contains the following controls and sections:

  • Name - the rule name (must be unique within the conditional formatting rules).

  • Enabled - enables the rule.

  • Apply to - allows you to select the scope for conditional formatting (Row, First column or Column).

  • Condition section - allows you to set up the condition in either of two modes:

The condition can include a series of child conditions. Conditions can be combined in groups; the groups can also include nested groups of child conditions. You can create a new rule as follows:

        • Add Condition - creates a new condition.

        • Add Group - creates a new group.

        • Clear All - removes all existing conditions and groups.

        • Delete Row - removes the selected condition or group.

        • Move Up - moves the selected condition or group up.

        • Move Down - moves the selected condition or group down.

Subcondition rows - display single conditions. Each condition consists of the field to be compared, a comparison operator and, if the operator requires so, field value(s) to compare with. If the comparison operator is either "like" or "not like", in the value you can use the wildcards: "_" representing any single character or "%" representing any sequence of characters. To define the value, you can also use the following placeholders: <Current User>, <Current User Organization>, and <Current User Location>, which will be replaced with the values of the Full Name, Organization, and Location fields, correspondingly, from the current user’s Person record.

Group rows - link the conditions and groups included in the group and display the conjunctive logical operator (AND, OR, NOT AND, or NOT OR) that connects all conditions and groups within the current group.

      • Switch to SQL Mode - changes to the SQL mode (recommended for advanced SQL users only).

    • SQL Mode - allows you to directly specify the SQL WHERE clause. This mode is recommended for advanced SQL users only.

      • Your SQL WHERE clause can include the following placeholders: <Current User>, <Current User Organization>, and <Current User Location>. Before the filter is applied, the placeholders will be automatically replaced with the respective data from the Full Name, Organization, and Location fields of the current user’s Person record.

      • Switch to Design Mode - changes to the Design mode. However, all the data entered in the SQL Mode will be lost.

  • Apply Style section - allows you to define the background color for the records that satisfy the rule condition. As an alternative or in addition to background color, you can specify font formatting for those records.

    • Background color - allows you to select the desired color from the drop-down list. Alternatively, you can click the ellipsis button and select one of standard colors or define a custom one using the Color window.

    • Text color - allows you to select the desired color from the drop-down list. Alternatively, you can click the ellipsis button and select one of standard colors or define a custom one using the Color window.

    • Font name - allows you to select the desired font name from the drop-down list.

    • Font size - allows you to specify the desired size in the field.

    • Font style - allows you to specify the desired font style characteristics using the Bold, Italic, Strikeout and Underline check boxes.

      NOTE: If you want to exclude any of the styles from conditional formatting, clear its check box.

    • Example- shows how the records with the specified formatting will appear in the grid.

Options tab

The Options tab allows you to configure the display settings for the current list view.

  • View section - allows you to configure the following display options:

  • Show Grid Lines - select to show grid lines on the view.

  • Show Filer Row - select to show the Filter Row on the view. The Filter Row allows you to specify the filtering conditions for the records to be shown in a grid (for details, see Filtering with the Filter Row).

  • Show Footer - select to show the list footer. The footer allows you to view the record statistics, such as the number of records, and the maximum, minimum, average, and sum of the values for numeric, currency, and date/time fields.

  • Column Auto Width - select to re-size columns width using auto-width.

  • Preview lines count - specify the maximum number of text lines that will be shown in the preview row when you are previewing record fields (for details, see Previewing record fields.) If you do not want to limit the height of the preview row, type 0 in this field.

  • Grouping section - allows you to configure the following grouping options:

  • Group by Sorting - select to have records automatically grouped when you click a column heading in the grid. The records will be grouped by the clicked column's values and the previously applied grouping (if any) will be cleared. Note that selecting this check box has no effect if you sort records by using the Sorting tab of the Customize View window or the grid pop-up menu commands.

  • Group by Box - select to show the Group Panel. You can group records by dragging column headers to that panel.

    NOTE: Alternatively, you can make the Group Panel visible by right-clicking anywhere in a grid and choosing Group > Group by Box. For details, see Showing and hiding Group Panel.

  • Hide Columns on Grouping - select to hide the columns by which values the records are grouped.

  • Group Date Columns in Outlook Style - select to show grouped date columns in Microsoft Outlook style.

  • Show Group Footers section - allows you to choose whether to show group footers. The group footers allow you to view record statistics by group.

    • Never - hides group footers.

    • When Expanded - show the group footer when the group is expanded.

    • Always - always shows group footers.