Working with DataGrids Reference

Build and customize DataGrids visually.

Reference → Solution →  Designer → Workspace → Find Results | Shortcuts | Settings | DataGrids 

Note: This documentation covers Configuration DataGrids in Designer. For DataGrid components in Operator Displays, see the Draw section.

Editing Tables

Adding New Rows

1. Click the first column of the insertion row (marked with asterisk *)
2. The asterisk becomes a pencil icon when editing
3. Enter data or select from dropdowns
4. Press Tab to move between columns

Editing Existing Rows

• Text fields: Click to overwrite, click again to edit partially
• Selection fields: Click twice to open dropdown/popup
• Navigation: Use Tab/Shift+Tab to move between cells

Creating Objects with Default Names

Quick creation method:

1. Click Name column in insertion row
2. Press Space then Enter
3. System creates object with default name and last-used type

Editing Multiple Rows

1. Select rows with Shift key
2. Right-click → Edit Combined Rows
3. Changes apply to all selected rows
4. Mixed values are indicated in the dialog

Column Management

Show/Hide Columns

1. Right-click column header area
2. Check/uncheck columns in list
3. Click outside to close

Reset to Default

Click Reset Grid to Default Settings button (top-right near search bar)

Reorder Columns

Drag column headers to new positions

Sorting, Filtering, and Grouping

Sorting

Click column header to cycle through:

• Ascending
• Descending
• None (uses internal ID)

Filtering

Click down arrow in column header to:

• Filter by specific values
• Apply custom filters
• Clear filters

Grouping

1. Drag column headers to grouping area above grid
2. Creates hierarchical data organization
3. Remove by dragging headers back to grid

Common Column Definitions

Copy and Paste Operations

Between Tables

1. Select rows
2. Right-click → Copy Selected Rows
3. Navigate to target table
4. Right-click → Paste Rows

Smart paste automatically maps columns between different table types (e.g., Tags to Historian).

With Spreadsheets

To Spreadsheet:

1. Select rows in DataGrid
2. Right-click → Copy Selected Rows
3. Paste in spreadsheet (includes headers)

From Spreadsheet:

1. Copy data including column headers
2. Right-click in DataGrid → Paste Rows
3. Data maps to matching columns

CSV Import

• Column headers must match target table
• Best practice: Export sample first, then modify

Keyboard Shortcuts

Multi-User Editing

• Multiple users can edit simultaneously
• Changes save to Solution server
• Last save overwrites previous changes
• Use Track Changes to monitor modifications

Performance Tips

Large Tables

• Use filtering to reduce visible rows
• Group by categories for organization
• Hide unnecessary columns
• Use search instead of scrolling

Bulk Operations

• Use spreadsheet for mass data entry
• Edit multiple rows simultaneously
• Use copy/paste for repetitive data
• Import from CSV for initial setup

Troubleshooting

In this section...