Customize a View
On this page
Customize View is where you change what a view shows and how: which columns appear, how rows are grouped and summarized, which rows the view keeps, and who else can use it. In the Web App it is a drawer that opens beside or over the grid, separate from the views panel beside the grid, where you select, show or hide, rename, export, or import whole views; see Lists and Views. The Settings App's own Customize View dialog for its grids is covered in Work in the Settings App.
Before you begin
In the Web App, what you may save depends on what you changed. A change to columns, grouping, or summaries is checked against your ordinary right to edit the view; sharing a personal view, making a shared view personal, and changing who a view is shared with are checked against the view permissions. You can therefore be allowed to rearrange a shared view's columns and still be refused making it personal. Save As needs Manage Personal Views and Boards, whatever you changed. For the permissions, see Permissions for views.
In the Web App
Open Customize View
Click the Customize View button in the grid's toolbar. In a picker or a related-objects grid, the toolbar is replaced by a settings button placed in the surrounding page; it opens the same drawer.
The drawer has up to four tabs, in this order:
- Columns - columns, grouping, and summaries. This tab opens first.
- Filter - shown only when the grid allows filters.
- Sharing - shown only when the grid works as a list grid, as it does on a list page and in the global search results. A grid embedded in another page works that way only when that page sets it, so it normally shows neither this tab nor the Save As button.
- Conditional Formatting - the view's highlighting rules.
The page that shows the grid can also leave out any of these tabs.
Besides the tabs, the drawer has Save and Apply, and, in a grid that works as a list grid, Save As. For how the drawer docks and resets, see The Customize View drawer.
Choose and arrange columns
- Open Customize View. The Columns tab opens.
- To add a column, click More in the fields section and pick a field from the searchable list. Only fields not already in the view are offered.
- To reorder an added column, drag its handle among the other added columns.
- To remove an added column, open its ⋮ (Options) menu and choose Remove.
- To hide or show a fixed (system) column, clear or select its Show/Hide column checkbox. A fixed column has no drag handle, and its Remove entry is disabled with the hint "Cannot remove system columns; use the checkbox to hide it".
The fixed columns of a list are set by the server: the column that links to the row's own record, usually the record number, and the flag column when the list's default view has one.
Hidden columns are part of the view: they are applied, saved, and exported with that view only. If you hide the column that links to the row's own record, usually the record number, the rows lose their Copy link to clipboard button; link cells in columns of related records keep theirs.
Sort rows
Sorting is not done in the Customize View drawer. Click a sortable column heading to sort ascending, click again for descending, and once more to remove the sort. Shift-click another heading to add a secondary sort. Right-clicking a column heading opens the grid's column menu, which offers sorting and grouping.
Group rows
- On the Columns tab, drag a field into Group By, or open a column's ⋮ (Options) menu and choose Group By. For a column that is already grouped, the entry reads Ungroup.
- For each grouping level, choose by value or by count, and ascending or descending order. You can group by any number of columns.
- Click Apply or Save. Dragging a field into Group By, reordering, or removing a grouping there only takes effect when you do; Group By or Ungroup from a column's menu applies at once.
Removing a column from the view also removes it from Group By.
You can also group from the grid itself. While nothing is grouped, the box above the grid reads "Drag a column header here to group by that column". Drag a column heading into the box, or out of it, and the grid regroups at once. Grouping from a column heading's right-click menu also applies at once. Once something is grouped, the box shows a chip for each grouped column, each with its own sort, filter, and remove buttons, and Expand All and Collapse All at its right. Drag a chip onto another to reorder the grouping levels; the new order applies at once.
Add a summary
- On the Columns tab, open a column's ⋮ (Options) menu and choose Summary. The column gets a summary set to Count in the grid footer and None in the group footer. Choosing Summary again removes it.
- In the column's Footer picker, choose the statistic for the whole grid; in its Group
Footer picker, choose None or a statistic for each group. The statistics depend on the
column's type:
- Number, currency, and duration columns: Average, Count, Min, Max, and Sum.
- Date and date/time columns: Count, Min, and Max.
- All other columns: Count.
- Click Apply or Save.
The summary row is pinned to the bottom of the grid. It is calculated from the rows already loaded in the grid, and leaves out any column that is currently grouped or hidden. Count shows the number alone; Sum, Max, Min, and Average are shown with the prefix SUM=, MAX=, MIN=, or AVG=. A currency column whose loaded rows use more than one currency shows N/A, with the hint "N/A: Values are in multiple different currencies". Summaries are set only in the drawer; no right-click menu in the grid sets one.
Filter and highlight rows
The Filter tab holds the view's filter conditions, and the Conditional Formatting tab holds its highlighting rules. Highlighting rules belong to the view, so sharing a view also shares its coloring.
Share a view
- Open the Sharing tab.
- Under Shared with, choose Only me to keep the view personal, Everyone, or Specific
people or groups. A choice you do not have the permission to make is disabled and titled
"Permission denied":
- Only me needs Manage Personal Views and Boards, and, for a view another technician owns, also Manage Shared Views and Boards.
- Everyone and Specific people or groups need Share Views and Boards for a view you own, or Manage Shared Views and Boards for any view.
- If you chose Specific people or groups, add technicians and groups in the list below the
choices. You can add any number of each.
- Groups are offered only from the active technicians-only groups. With Manage Shared Views and Boards, you can pick any of them. With Share Views and Boards only, you can pick those you are a member of. Without either permission, no groups are offered. Groups that the View permission of Group does not let you see are never offered.
- Technicians are offered by name, as far as the View permission of Person lets you see them. Without that permission, no technician is offered.
- The view's owner is always in the list, is saved as one of the people the view is shared with, and cannot be removed ("The owner cannot be removed from sharing.").
- Save the view (see Save your changes).
If you choose Specific people or groups without adding any technician or group, Save, Save As, and Apply are disabled.
At the bottom, the tab shows View name, Owned by, Last modified, and Modified by, or "N/A" where a value is missing. Last modified and Modified by are updated on every save. For an imported view, Owned by and Modified by both name the technician who imported it; no view records who created it.
A change to who the view is shared with counts as a change on its own: it enables Save even if nothing else changed, as far as your rights allow, and the Customize View button then shows a dot with the tooltip "View has been modified but not saved".
Save your changes
Inside the drawer, your edits are staged until you click Apply or Save; the only exception is Group By or Ungroup from a column's menu, which applies at once.
- Apply shows your staged changes in the grid without saving them to the view.
- Save writes your changes to the saved view.
- Save As saves them as a new view. The name is filled in as "current name - Copy". If you have neither Share Views and Boards nor Manage Shared Views and Boards, a copy of a shared view is created as a personal view, and the dialog tells you so.
Save As needs Manage Personal Views and Boards. Without it, Save As is disabled in the drawer, with the hint "You do not have necessary permissions to save views", and in the views panel.
When you click Save on a view that is currently shared and you have Manage Personal Views and Boards, the Save Shared View dialog offers two choices:
- Save as personal - always available. Creates a new personal copy with your changes, which is not the default view.
- Update shared view - available only if you may edit that shared view.
Without Manage Personal Views and Boards, Save writes to the shared view directly, if your permissions allow it.
If the view is shared with specific people or groups and you are not its owner, not one of those technicians, and not in one of those groups, saving would leave you without access to it. You are asked "You may lose access after saving. Continue?"; if you decline, nothing is saved and no copy is offered.
The list's default view cannot be saved over: Save is disabled, and Save As is the way to keep your changes. In the drawer, the hint on the disabled Save is "No changes to save" until you change something; once you have made a change and the Sharing tab is complete, it is "Default temporary views cannot be modified. Please use the 'Save As' command instead." This does not apply to grids that have only one view, or to the Attachment Browser.
Manage the shared views of a list
The Manage Shared Views dialog lists the shared views of a list. In it you can rename a shared view, change who it is shared with, and reassign or clear its owner.
Before you begin: changing the shared views requires Manage Shared Views and Boards. Without it, Manage Shared Views is not in the views panel's More menu.
- In the views panel beside the grid, select a view other than the list's default view, and open its More menu. More is disabled for the default view and for an unsaved draft of a view.
- Choose Manage Shared Views. The Manage Shared Views dialog lists the shared views with the columns Name, Owner, and Sharing. Sharing shows the group's name, Specific people or groups, Everyone, or Only me. You can filter the Owner and Sharing columns.
- Click a view. A pane titled with the view's name opens.
- Make your changes:
- To rename the view, change the Name field.
- To change who the view is shared with, choose Everyone, Specific people or groups, or Only me under Shared with. For Specific people or groups, pick the technicians and groups in the list below the choices. Only me is available only when the view's owner may have the view personal. A view you make personal becomes your own view.
- To change the owner, pick another technician in Owner, or clear it so that the shared view has no owner. Owner is disabled while Only me is chosen.
- Click Save, and then click Close.
Save stays disabled until you change something, and while Specific people or groups is chosen without any technician or group. Manage Shared Views has no command to delete a shared view.
Reference
This section gives the details of Customize View in the Web App.
Permissions for views
The Views and Boards Management permission group of a security role holds these permissions:
- Manage Shared Views and Boards - lets you share any view and change who any view is shared with, including views that other technicians own. Together with Manage Personal Views and Boards, it also lets you make another technician's shared view personal.
- Manage Personal Views and Boards - lets you change and save personal views and use Save As, and is needed to make a shared view personal. With it, Save on a shared view offers the choice between a personal copy and an update of the shared view.
- Share Views and Boards - lets you share a view you own and change who it is shared with.
- Export data
Curating the whole shared set of views for a list (renaming shared views, changing who they are shared with, and reassigning their owners) is done in the Manage Shared Views dialog, which needs Manage Shared Views and Boards; see Manage the shared views of a list.
The Customize View drawer
The drawer docks beside the grid and pushes it aside, unless the grid's area is less than 1200 pixels wide or 700 pixels tall; then it floats over the grid instead. In a picker or a related-objects grid it is always docked. Its header, Customize View, always offers Reset, which discards your unsaved changes, and Close. If a tab fails to display, it shows an error message with a Clear button that resets only that tab.
Related topics
- Lists and Views - select, rename, export, and import whole views from the views panel.
- Shared Views - shared views in the Administration Guide.
- Work in the Settings App - the Settings App's Customize View dialog.
- Filter and Highlight Rows