Designing Longview Data Grids
Designing Longview Data GridsYou can create interactive Data Grids that enable users to work with data in the Longview database. The data displayed by a Data Grid is determined by the Data Area that the grid specifies in the Show DataArea function. For more information on this function, see “Show DataArea”. Data View definition files define the layout, format, and behavior of data in a Data Gri...
Working with area specs
Working with area specsWhen you are designing your Data Grid, you must often define the area of the database to apply certain functions to. For instance, you must specify an area spec for the following functions: ConditionalCellStyleFilterLIDInputOnlyNumericInputOnlyProtectTextInputOnlyThe area spec for a Data View function must be a subset of the data area as defined by the corresponding SHOW ...
Working with line item details
Working with line item detailsIf your organization requires line item details to provide more detailed accounting for data, you can create Data Grids that allow and enforce line item details.Users can enter line item details under the following conditions: USEINPUTRELATEDSCHEDULES is set to ON or LineItemDetails in the related procedure. For more information on this function, see “UseInputRelat...
Working with comments
Working with commentsIf your organization wants to allow users to provide more detailed information about data that they input, you can create Data Grids that allow comments. Comments are always optional and cannot be enforced. A red triangle in the top-right corner of a cell indicates that there is at least one comment associated with that data intersection. In order for the Data Grid to suppo...
Working with attachments
Working with attachmentsIf your organization wants to allow users to provide supplemental information to a cell in a Data Grid, you can create Data Grids that support attachments. Attachments are always optional and cannot be enforced. Users with appropriate write access can attach files only to locked base data cells.Users can add attachments under the following conditions: The File Attachment...
Defining Data Grid layouts
Defining Data Grid layoutsLayout functions define the way dimensions are displayed in the Data Grid. When you create a Data Grid, you must choose the dimensions that appear in the rows and columns, as well as the dimensions that are fixed or sliced. You can specify a dimension as either a row, column, fixed, or sliced; you cannot specify a dimension as more than one of these categories.ColumnsU...
Adding actions to Data Grids
Adding actions to Data GridsTo make it easy for users to access certain functionality, you can create a toolbar or add a context menu to a cell within your Data Grid. You can also add inactive buttons to Data Grid toolbars, allowing for a unified look between tabs. For more information, see the "Command" parameter in “Syntax”.ActionUse this function to add a toolbar icon or a context menu with ...
Specifying title bar descriptions
Specifying title bar descriptionsYou can use a data view function to customize the title bar description for Data Grids. If you do not include the WindowTitle function in your .lvdvw or .lvui file, the Data Grid opens with the title bar description specified by the description parameter in the Longview App configuration (.lvapp) file. For more information, see “Configuring Longview Apps”. Note:...
Formatting data in Data Grids
Formatting data in Data GridsYou can use the functions in this section to format your Data Grid to comply with locale-specific formatting standards or to provide data in a familiar format to your users.ConditionalCellStyleUse this function to apply a conditional style to an area of Data Grid cells. If you use an unsupported value for a style, a warning icon appears in the cell.When you hover ov...
Working with drop-down lists
Working with drop-down listsYou can add drop-down lists to Data Grid cells to make it easier for users to submit the appropriate value and to reduce input error. Users cannot type in a cell that contains a drop-down list; however, they can paste values into the cell. Likewise, users can run a model that affects a cell with a drop-down list. Drop-down lists are not enforced in any of the followi...