omron — Columns dialog

Data Logging and Display • When the Data Source type is set to Database, it is important to make sure that the Type for each column configured in the object matches the Type of the respective field in the database. • When the Data Source type is set to Database, you can configure valid SQL statements directly in the field (e.g., List(DISTINCT [Cell_Name]) AS [Cell Name] ). You can also configure tag names between curly brackets to modify this setting during runtime (e.g., {MyFieldName} ). Tip: If Picture is the column type, the Grid object displays a default icon ( ) if the picture file is not found during runtime.

You can configure a different picture to be displayed when the file is not found by copying the picture file to the Web sub-folder of your project folder and configuring its name on the project_name .app file, as follows: [Objects] GridDefaultPicture= PictureFileName • Width : Enter a width of the column, in pixels. • Align : Select an Alignment for the data shown in the column. There are three options: Left, Right or Center. • Input : Click (check) to allow the user to enter data in this column during runtime. • Key : Use this field to designate a shortcut for sorting the values. A shortcut is a combination of keys pressed on a keyboard at one time (e.g., CTRL+C, CTRL+V, etc.).

This option is especially useful when creating projects for runtime devices that do not provide a mouse or touchscreen interface and only have a keyboard for interacting with the project during runtime. • Unit : Enter the name of the engineering unit (i.e., the unit of measurement), if any, that applies to the data displayed. You can also enter a String tag using the { tagname } syntax, which allows you to change the value of Unit during runtime. • Decimal Points : Enter the number of decimal places to be displayed. You can also enter an Integer tag using the { tagname } syntax, which allows you to change the value of Decimal Points during runtime. Note:

When the Data Source type is set to Class Tag, and the Columns dialog is left blank, the object displays the values from all members of the Class tag with the following default column settings: • Label = • Type = Text • Width = header of the grid object> • Align = Center • Input = Enabled (checked) • Key = • Unit = The Unit of a class member or tag is set using the Tag Properties tool. • Show ID Column : Check to display the number of each row, automatically. • Allow sorting columns : Check to enable the user to sort the values in the columns during runtime, either by clicking on the label or by using the shortcut configured for each column.

This option is disabled if the Show header option from the Advanced dialog is not checked. Tip: Use the Move Up and Move Down buttons to reorder the display of the columns. InduSoft Web Studio Page 265