Customize your tables to view them according to your preference. For each table, changes you make will be saved and reloaded automatically whenever you return to the same table.
Adjust columns
Hide / display columns
| Click the table menu button found in the top-right corner: In the menu, you will see the list of all category titles available for display: Click a title to mark it with an X to hide it. Click a title to mark it with a checkmark to display it. |
Reorder columns | Drag and drop columns by their title to rearrange them. |
Adjust column width
| Place the cursor on the column border. It will change to the adjust width action. Alternatively, double-click the border and the column will adjust to its full width. |
Hide a column
| Click the arrow of the column title to open the column menu, and choose "Hide Column". |
Restore all hidden columns | Click the clear button above the table to open its menu, and choose "Restore Hidden Columns". |
Filter
Filter a column | Enter an alphanumeric string (letters, numbers or a combination of both) into the white box below the title. You can filter multiple columns. The order is not significant. At the bottom of the table, you will see the total number of items returned by the filter/s.
|
Clear one filter | Click the arrow of the column title to open the column menu, and choose "Clear filter". |
Clear all filters from all columns | Click the clear button above the table to open its menu, and choose "Clear All Filters". |
Sort
Quick sort a single column | Click the column title to sort it. direction.
|
Sort multiple columns | Click the arrow of the column title to open the column menu, and choose either "Sort Ascending" or "Sort Descending". The order is significant. A number will appear near the sorting arrow to indicate the order in which the columns are being sorted. In the example below, records are first sorted by status, then by Local ID and then by Mold Name. |
Restore default sorting | Click the clear button above the table to open its menu, and choose "Restore Default Sorting". |
Select
Select line/s | Select the check box on the far-left to select a line. You can select multiple lines. Selected lines are highlighted with a shaded background and marked with a checkmark. |
Run calculations
Count the rows | Click the arrow of the column title to open the column menu, and choose "Count". The total number of rows is presented at the bottom of the column. If you apply filters, the system will recalculate the total count. If you select items, the system will recalculate the total number of rows selected. |
Sum | Click the arrow of the column title to open the column menu, and choose "Sum". The system will calculate the subtotal for the column. If you apply filters, the system will recalculate the subtotal. Only the visible rows returned by the filter/s will be taken into account. If you select items, the system will recalculate the subtotal. Only the selected rows will be taken into account. |
Min / Max | Click the arrow of the column title to open the column menu, and choose either "Min" or "Max". The system will return the minimum value or maximum value from that column's values per your choice. If you apply filters, the system will recalculate the value. Only the visible rows returned by the filter/s will be taken into account. If you select items, the system will recalculate the value to include only the selected rows in the calculation. |
Average | Click the arrow of the column title to open the column menu, and choose "Average". The system will calculate the column's average. If you apply filters, the system will recalculate the average. Only the visible rows returned by the filter/s will be taken into account. If you select items, the system will recalculate the average the system will recalculate the value to include only the selected rows in the calculation. |
Export data to PDF or Excel
Export all data
| Click the Export button above the table to open its menu, and choose "Export all data as [PDF | Excel]". The system will export the data for the default table. It will not take into account your table customizations. |
Export data for filtered rows
| Click the Export button above the table to open its menu, and choose "Export visible data as [PDF | Excel]". The system will export the data for the rows returned by your filters. |
Export data for selected rows | Click the Export button above the table to open its menu, and choose "Export all data as [PDF | Excel]". The system will export the data for the selected rows. |
Restore defaults
To return the table to its defaults, use clear button above the table to open its menu, and choose from the available options:
Clear All Filters
Restore Default Sorting
Restore Defaults
Restore Hidden Columns
Note: your table defaults may be changed by other users with special permissions.