..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.