..2 Form
Create and save a new form
Launch an XLSX Workbench, and create a new form with name DATA_VALIDATION .
Assign a context to the form
Assign a context SDBXXLTABS_TAB to the form. When an automatically creation of the Form structure will be prompted, you should press the button
to create a structure manually.
Create a Form structure
Add the new components into form structure as shown in the picture below:
Context binding for components
Perform Context binding for «Loopstep» , «Value» and «Grid» according to scheme below:
Markup of template
Markup an Excel-template and perform template binding as shown below :
Setup data validation option for cell A1
Put cursor into the A1 cell.
Choose Data Validation from the Data Tools group on the Data tab.
Pick 'List' value from listbox Allow on the on the Settings tab
Put some text (no matter, it will be replaced in runtime) into field Source on the Settings tab
Optionally, specify error text on the Error Allert tab (if needed)
Setup component VALUE in the form structure tree.
Follow to the properties tab for component INPUT_FIELD and select 'From Dataset' option in the 'Data validation' item
In popup window select Grid component and its column in order to specify values for dropdown of the cell
Activate the Form by pressing a button
Form is ready to use now.