..2 Form

The Form's source is here .

How to import Form into the system see here . 



Of course, you could create the form "from scratch", however, it will be faster to slightly modified the Form from the previous example. Here we explain this method.




Open the previous Form and save it by another name


Open (in the XLSX Workbench) the form SHIPPING_LABEL (from previous example) and save it by another name SHIPPING_LABELS.

To do it, You have to click an icon "drop-down list" (right-side of the button ) and choose the item «Save as…». In a popup-window specify a new name (SHIPPING_LABELS): 


 

Assign a new Context to the Form

Select a root node of the form structure tree  and in the Properties tab assign to a new context name ZCONTEXT_SHIPPING_LABELS :



 

Add a new Component «Loopstep» to the Form structure 

Select the node  and create a new component «Loopstep» (with name LOOP_AT_LABELS, for example) under the Sheet. To do it, You have to press the button :

 

Assign the recently created «Loopstep» to Context table 

To do it, You have to press the button  in the item «Binding with context» of the Properties tab.
In the popup search-help choose a nested table (at which a 
loop has to be performed) of the context (in this case it is a root node of the context, it has a table type):



 

Move «Pattern» under the recently created «Loopstep»

Drag a component  and drop it on the . 
As result, the 
«Pattern» will be child node of the «Loop» node: 



 

Correct a Context binding for all «Values»

  • Select a component  in the form's structure tree. 

  • Press a button  in the item «Value» of the Properties tab

  • In the popup search-help pick a field of the context


In the same way, correct the binding with the context for the rest "Values" (TO_STREET, TO_TOWN, TO_STATE, TI_ZIP).


Activate the Form by pressing a button 


Form is ready to use.

 

Explanations

The final look of the Form structure tree:


This structure means the following :

  • Result Printing form will contain just single worksheet in the runtime mode.

  • In runtime mode, each iteration of «Loopstep»  induces an insertion of next Shipping Label in the worksheet
    (
    it is obvious that the number of iterations of «Loopstep» is equal to the count of records in the assigned context table; and each table record contains the data for corresponding Shipping Label). 

  • A direction  indicates that an each next «Pattern» will be placed below the previous one. In other words, all Shipping Labels will be located in the worksheet sequentially under each other, from Top to Bottom .

  • If we would decide to set the direction to , in this case the Labels would be located from the Left to the Right in the actual worksheetIt will be shown in the next example.