Difference between revisions of "GUI Tables"

From 3forge Documentation
Jump to navigation Jump to search
Line 137: Line 137:
  
 
''Secondary Sort applied to Name''
 
''Secondary Sort applied to Name''
 +
 +
In order to clear '''all''' of the sorts on a table, click on any column and select Clear All Sorts from the column menu.
 +
 +
[[File:GUI.Columns.23.jpg]]
  
 
==Pinning & Sizing==
 
==Pinning & Sizing==

Revision as of 03:30, 9 April 2021

Columns

Adding, Editing, Copying, & Deleting Columns

Adding

(Note: these options are only available when in developer mode)

There are three ways to add columns in tables

1. Click on the green button to bring up the panel configuration menu and select Add Column

GUI.Columns.1.jpg

2. Click on a column to bring up the column menu. This method allows you to place the new column in between existing columns. In the menu, select whether to add the new column to the right or left of the selected column

GUI.Columns.2.jpg

3. Click on an open area of the header in order to bring up the header menu. In the menu, select Add Column.

GUI.Columns.3.jpg

Add Column menu

GUI.Columns.4.jpg

Display Use variables, operators, functions, and icons to create the content for the column
Sorting Use variables, operators, and functions to apply a sorting to the contents of the column
Format Choose the format of the column (e.g.: text, numeric, time, date, price, etc.)
Title Create a title for the new column. Must be unique from existing columns.
Header Style Apply different fonts, alignments, style, and colors to the column header
Description Add a description/help which can be seen when clicking on the column header
Column Position Drop down list of various positions where the new column can be placed (can also be hidden)
Style Apply a style to the contents of the column (including font and alignment)
Foreground Color Apply a color to the contents of the column
Background Color Apply a background color to the column
Clickable Makes the contents of the column clickable

Examples

Adjusting header and column styles

GUI.Columns.5.jpg

Column Description

GUI.Columns.6.jpg

GUI.Columns.7.jpg

Editing

There are two ways to edit columns

1. Click on the header of the column to bring up the column menu and select Edit Column

GUI.Columns.8.jpg

2. Click on the green button to bring up the panel configuration menu. Highlight Edit Column to bring up the list of columns and select the column

Both options will open the Edit Column window, which is the same as the Add Column window.

Example

Conditional Formatting

Formatting can be used to highlight data in specific formats when certain parameters are met. In this example, the Price is set to be in bold red and highlighted if it is greater than $50.

GUI.Columns.9.jpg

GUI.Columns.11.jpg

Copying

In order to copy a column, click on the column to be copied and select Copy Column. This will bring up the Edit Column menu. Apply a different name and click Update.

GUI.Columns.12.jpg

Note: if the column to be copied has any input in its fields, those fields will also be copied.

Sorting

Columns can be sorted in multiple ways

Primary Sorting

Primary sorting will remain in place until it is cleared. Any new data added to the table will automatically be sorted. There are two ways to add a primary sort to a column.

1. Click on a column to open the column menu. Select either Sort Ascending or Sort Descending

GUI.Columns.13.jpg

2. Hover over the column header - this will bring up the sorting arrows on the right side of the header. Clicking on the up arrow will apply a sort in ascending order & clicking the down arrow will apply a sort in descending order

GUI.Columns.15.jpg

After applying a primary sort, the corresponding arrow indicating the type of sort will appear in the header

GUI.Columns.16.jpg

Application of a descending sort

In order to cancel a primary sort on a single column, use the Sort Ascending Once or Sort Descending Once options from the column menu. This will perform a sort which will not remain in place and the primary sort will no longer be applied to the column.

GUI.Columns.17.jpg

Secondary Sort

Secondary sort can be used to further sort the data based on multiple columns. The secondary sort option will not be available unless there is a primary sort in place on one of the columns.

Example

GUI.Columns.18.jpg

Table without any sorting applied

GUI.Columns.20.jpg

Sort Ascending applied to Continent

GUI.Columns.21.jpg

Secondary Sort applied to Region

GUI.Columns.22.jpg

Secondary Sort applied to Name

In order to clear all of the sorts on a table, click on any column and select Clear All Sorts from the column menu.

GUI.Columns.23.jpg

Pinning & Sizing

Filters

Arranging

Hiding & Searching