Additional Parameters
Additional parameters can be entered for columns in gridform design. There is no GUI for this, so to be able to change the settings, you need to export the template to Excel, and then import it into Bizview again.
Ribbon Button | Description |
|---|---|
groupIndex | Group the grid by specific columns. groupIndex=1 (the first column that you want to group), groupIndex=2 (if you want the grid to also group by a second column), and so on. Note: One column in a group makes it difficult to add new rows and save in the grid, since that actual column is then not part of the edit row in the grid. |
fieldOrder | Govern the order in which the columns should be rendered. By default, the columns are rendered in the same order as the physical database table. Enter this parameter in the column row for the column you want to order in another way (e.g. fieldOrder=3). The column will then be the fourth column shown in the grid. Note: The first column is always value 0, therefore, fieldOrder=3 will be the fourth column. |
format | Formatting of numbers, For example, displaying the numbers in thousands or fixed point. Available values: 'billions' | 'currency' | 'day' | 'decimal' | 'exponential' | 'fixedPoint' | 'largeNumber' | 'longDate' | 'longTime' | 'millions' | 'millisecond' | 'month' | 'monthAndDay' | 'monthAndYear' | 'percent' | 'quarter' | 'quarterAndYear' | 'shortDate' | 'shortTime' | 'thousands' | 'trillions' | 'year' | 'dayOfWeek' | 'hour' | 'longDateLongTime' | |
precision | Number of decimals shown in column. 0=no decimals, 1=one decimal and so on. For example, precision=1. |
fieldSize | Fix the column width with a specific size. For example, fieldSize=300. |
columnFixing | Fix a specific column (like freeze panes), when scrolling in the gridform. Available values: 'left' | 'right'. For example, columnFixing=left. |
Refer to the examples in red below: