This panel define the columns in the data grid
Recordset:
The recordset the extension use to populate the data grid rows.
Use the button Add, Edit and Del to populate the data grid columns.
When you click on Add or Edit the extension open the column setup panel (the panel belowe) with a main and an edit element. In the main panel you can find the column setup parameters, the edit is disabled in tree grid.
Recordset field:
The field in the recordset the value will be show in the column
Header text:
The header text of the column
Width:
The width of the column, if void the columns with will be proportional
Text and Header Align:
The text align for the cell and for the header
Text and Header Css class:
The css class for the cell and for the header
Text format:
The text format of the column data between:
String
String multiline
Number (0 decimal)
Number (1 decimal)
Number (2 decimal)
Number (3 decimal)
Number (4 decimal)
Number (5 decimal)
Date DD.MM.YYYY
Date MM.DD.YYYY
Date YYYY.MM.DD
Date DD/MM/YYYY
Date MM/DD/YYYY
Date YYYY/MM/DD
Date DD-MM-YYYY
Date MM-DD-YYYY
Date YYYY-MM-DD
Boolean (true/false)
Boolean (1/0)
Boolean (-1/0)
Boolean (yes/no)
Boolean (Y/N)
IMAGE
In the StringMultiline format the extension replace the VBCRLF char with "<br>"
In the IMAGE format the extension insert an IMG tag and use the record field value to populate the SRC parameter, so the content of the record must be the path for the image you want show in the data grid. In the IMAGE format the extension add the "dwzGridImage" class to the img tag so you can setup your style parameters to the images in the grid.
The boolean format show in the grid the value you can see between the (...) or an image if you check the "Image checkbox" in the main panel of the extension.
Link url:
The url of the link, if this is not void the column value will have a link to this url.
You can use a placeholder to add parameters to this url, like:
mypage.asp?id=[ID]
The extension replace the name bentween the [] with the corresponding recordset field value.
Identifier:
Define the recordfset field that is the unique column key
Status Field:
If checked this field will be the column with the Status Mapping
Text before:
The value of this field will be added to the column value
Text after:
The value of this field will be added to the column value
Search:
If checked the search method will search in this column value
Sortable:
If checked the column can be sorted
Visible
Sets the visibility of a column
Visible in selection
Sets the visibility of the column selection box item for a specific column.
Image:
The fa class to define the button icone
Custom Image:
If you choose custom in the image combo you must enter the fa class of the button image
Link:
The link to call on the button click, can be any html href tag value, also javascript call
Link target:
The target of the link
