Page History

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

Using DataGrid tables

Most Solution Configuration interfaces are presented in DataGrid tables, which offer various features to help manage and edit the contents of the configuration tables.

Most tabs display information in a table format, and all tables use the same methods to manipulate, copy, paste, and import data.

Editing Tables

Most configurations, such as tags, alarms and users, are stored in tables. In most tables, you can add and edit information using the insertion row.

To add a new table item (row):

1. Click the first column of the insertion row

1. (marked with asterisk *)
2. The

Image Removed

1. asterisk becomes a pencil icon

Image Removed

When editing a table, you can:

• If the column is a text field, enter the information.

• If the column is a selection field, click the same spot again and select items from the drop-down list or pop-up window that displays.

• Press Tab to move through the columns in the row.

To edit an existing row, click the column in the row that you want to change and do one of the following:

• If the column is a text field, enter the new information. The system overwrites the text that was in the field. To change part of the text, click again.

• If the column is a selection field, click again and select items from the drop-down list or pop-up window that displays.

1. when editing
2. Enter data or select from dropdowns
3. 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

An easy way to create a tag is to click the Name column of the insertion row, then press Space and Enter. Each time you do this, the system will create the same type of tag that was last created. In the insertion row, select the Type, then click on the header or any other part of that grid. This will create a tag with a default name.

Editing Multiple Rows

You can configure more than one row at a time by selecting the rows with the Shift button, then right-click and select "Edit Combined Rows". A new dialog will open with the information for the rows. The settings changed in this window will apply to all the selected rows. If a column has more than one configuration, the platform will indicate it.

Showing or Hiding Columns

Tables display a default set of columns. Every table has additional columns that you can display, and you can remove any of the default ones. You can also change their order.

To add or remove a column:

1. From any table, right-click the column heading area.

2. A list of all available columns for that table will be displayed. Columns with a check mark next to them are displayed in the table.

3. Select or deselect columns in the list.

4. Click outside the list to close it.

Image Removed

5. To change the order of the columns, drag a column heading to a new location.

Image Removed

Sort, Filter and Group Columns

Sort

Click a column name to sort by that column and to change the order to ascending, descending, or none. When none is selected, the internal row ID is used: every DataGrid has an internal column named "ID".

Image Removed

Filter

Click the down arrow icon to select visible rows according to their content.

Image Removed

Grouping

Drag and drop the column titles in the upper area to create a dynamic hierarchical grouping of the information. 

Image Removed

Image Removed

Common Column Definitions

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

assigned to the object in the table. Numbers are assigned starting from 1 for the first object created and continue as needed. The IDs are unique only to a specific table.

Column	Description
ID	Database ID
Level	Select the level you want to associate with the tag on the Asset Tree. Learn more at UNS Asset Tree.
Category	Select one or more categories for this attribute. See Solution Categories.
DateModified	Date the object was last changed.
DateCreated	Date the object was created.
Description	Enter a description of the object

Copying and Pasting Rows

You can copy and paste rows into and from tables on the software platform. The smart copy/paste functions allow you to copy rows from one table to another. For example, you can copy tags and paste them into the Historian tab or the Items tab under Alarms. You can also copy and paste to and from a spreadsheet. Additionally, you can import a comma-separated values (.csv) file into any table. Column headings must match the table you are importing into. The best way to ensure the headings match is to first copy rows into a spreadsheet, then edit the spreadsheet.

Copying and Pasting

To copy rows to another tab:

• From any table, select one or more rows.
• Right-click and select Copy Selected Rows.
• Go to another tab.
• Right-click and select Paste Rows.

Copying and Pasting To or From a Spreadsheet 

To copy rows to a spreadsheet:

• From any table, select one or more rows.
• Right-click and select Copy Selected Rows.
• The copy automatically includes all available column headings for the tab you are in.
• Go to a spreadsheet and paste.

To paste rows from a spreadsheet:

• Set up the spreadsheet columns by following the copy steps above.
• Enter the information you want.
• Copy the information, including the headings, from the spreadsheet.
• From the corresponding table, right-click and select Paste Rows.
• The paste automatically places the data into the corresponding columns. Any empty cells are ignored. 

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...

In this section: