Column
The displayed columns and their parameters:
- Header text: the text of the panel's header
- Value:The text value of the column (can be dynamic)
- Width: The with in pixel of the column
- Image: Define if the cell must contain an image, in this case the recordset field for this cell must return the path of the image. If you need apply a style to this image you can use the style class: dwzMultiColumnComboImage
First line text
The text displayed in the first line of the MultiColumnCombo panel.
For example you can insert the text "Select a value" and if the user don't select a value when you validate the MultiColumnCombo this field will result void.
Recordset
The recordset used to get the value for the columns
Value field
The recordset field value send on the submit of the form.
If you set a Multiselect item with the Multiselection checkbox checked will be returned a comma-delimited list of selections items.
Text field
The recordset field value displayed in the text field when you select a value in the MultiColumnCombo panel.
Limit to list
If checked it obligates the user to choose the value from the list, in this case the MultiColumnCombo return the value of the record field selected in the "Value field"
if no checked the user can insert a value directly in the text field, in this case the MultiColumnCombo return the text inserted.
Select value
The selected value in the MultiColumnCombo panel.
Use this option in an update record page to display the current value in the database.
OnClick event
In this field you can insert the name of a Javascript function you need called after the user select a value in the combo. You can also get a parameter from the DataBase and send this parameter to the Javascript function.
This is an example:
Simple Javascript function:
myFunction()
Javascript function with parameter:
myFunction('<%=(Recordset1.Fields.Item("Id").Value)%>')
If you need copy one or more multicolumncombo columns values in your form fields you can use our javascript function dwzCopyColumnValue:
To use this function in the "OnClick event" field write this code
dwzCopyColumnValue(this, '0', '<FirstFieldName>')
or if you have 2 value to set:
dwzCopyColumnValue(this, '0', '<FirstFieldName>', '1', '<SecondFieldName>')
where the "this" (the first argument) must not be modified and the others arguments must be the column number and the form field name where save the column text. You can add many pair of arguments 'column / fields' how you need.
