Data entry

<< Click to Display Table of Contents >>

Navigation:  Data Module >

Data entry

Virtually any data structure, data type and layout can be defined in CORE-GS.

To provide this flexibility, the user interface changes based on the selected table:

Data_Overview

The Table Navigators (Table Tree and more functionally Workflow Toolbar) work together with the Record Navigator to define the data shown in the Data Grid:

Data_Interface_Navigators

Additionally, report previews can be used to navigate tables and records:

single mouse click - highlights the Workflow Toolbar table used in a report region

double mouse click - changes the table / record associated to the clicked report component

Data_Interface_Navigators_ReportWithData

Data changes can be manually saved at any time by clicking the Save Button_Save button (CTRL+S) on the Quick Access Toolbar .  Otherwise data changes are automatically saved when changing table or navigation record.  If more frequent saving is required, the Record Commit mode can be enabled to automatically save any changes when leaving a record:

Data_Interface_Ribbon_Button_RecordCommit

If changes have been made that you do not want saved, clicking the Cancel Button_Cancel button (CTRL+Z) on the Quick Access Toolbar will discarded any changes (one or more record) since the last save.

The Data Grid provide many advanced features that users can use to visualize data in different ways for each table:

Data_Grid_Features

Including:

Column width

Column order

Column visibility

Column sorting

Row groups

Row height

Row filters

Conditional formatting

Summaries

Most options are available through the column contextual menu shown by right-clicking the column header:

Data_Interface_Grid_ColumnHeaderMenu


 

How To: Change column width

img_1 Click on the column separator with the left mouse button, then drag the separator left or right:

Data_Grid_Column_Separator

img_2 Release the left mouse button once the desired width is reached.

 

How To: Sort columns

img_1 Click on the column header with the left mouse button:

Data_Grid_Column_Sort

hs-tip

Sort can be applied to multiple columns by holding down the SHIFT key.

noteNote

Sort cannot be changed when Continuous Range mode is enabled.

 

How To: Hide columns

img_1 Click on the column header with the left mouse button, then drag the header down onto the grid:

Data_Grid_Column_Drag

img_2 When an X appears, release the left mouse button:

Data_Grid_Column_Hide

 

How To: Unhide columns

img_1 Right-click on the column header to show the contextual menu, then click Column Chooser:

Data_Grid_Column_ColumnChooser_Show

img_2 Left-click on the required column and drag it to the column header, using the indicators to determine the position before releasing the mouse button:

Data_Grid_Column_ColumnChooser_Drag

 

How To: Move columns

img_1 Click on a column header with the left mouse button, the begin to drag the header left or right:

Data_Grid_Column_Drag

img_2 Use the indicators to determine the position before releasing the mouse button:

Data_Grid_Column_Move

 

How To: Filter columns

img_1 Click on filter glyph on the column header to show the filter options for the current column:

Data_Grid_Column_Filter

Text

Numeric

Date / Time

Data_Grid_Column_Filter_Text

Data_Grid_Column_Filter_Numeric

Data_Grid_Column_Filter_Date

img_2 Filters are automatically applied.

 

Rows and columns can be navigated and selected using:

mouse

keyboard

embedded navigator

Various cell editors can be used to improve usability and ensure input consistency.