Multiple Rows Form

In this tutorial, a Multiple Rows Form will be developed using the order_details table and the following additional resources:

  • Calculator.
  • Numeric fields using Spin.

Creating a Multiple Rows Form

Note:

In case you have any doubt of how to create a form, access here: Creating a new form


1. Create a new Form, select the Multiple Rows option, and select the example table order_details.


2. Now, in case you want to edit the label of your fields click on the Edit Fields tab and change the name of the fields as in the image below

Editing the Form fields


1. Go to the app menu and select the APrimeiro, acesse o menu da aplicação e selecione a aba “Posicionamento de Campos”


2. Remove all the fields, except: “productid”, “unitprice”, “quantity” and “totalprice” as displayed below.


3. Access the app menu in “Fields” and select the field “productid”.


4. Navigate to the “General Settings” section and deactivate the “Use Select2”.


5. Navigate to the “Lookup Settings” and substitute the SQL code by the SQL below:

SELECT productid, productname 
FROM products 
ORDER BY productname


6. Select the field “unitprice”.


7. Navigate to the section “Values format”, activate the option “Currency symbol usage”, change “Decimal precision” to 2 and activate the option “Show a calculator” as in the image below.


8. Select the field “quantity”.


9. Navigate to “Values format” and activate the option “Use Spin”, as in the image below.


10. Select the field “totalprice”.



11. Navigate to the “Values format” and activate the “Currency symbol usage” option.


12. Select the button “Run Application” in the toolbar to generate and execute the Form.


After that, your form will be as the image below


To check more examples using Scriptcase, access: Samples: Complete Systems and Applications with Scriptcase.

Tutorials in the same category

Responsive login form 3

To learn how to use the templates available within the ScriptCase in the security module, follo...

Responsive login form 2

To learn how to use the templates available within the ScriptCase in the security module, follo...

Responsive login form

To learn how to use the templates available within the ScriptCase in the security module, follo...

Form with Fixed Label

This option can be selected in the forms of type the Multiple Record, Editable Grid and View. ...

Comment this post