...
When an item and quantity are selected in a particular row, we want to compute the price for that item (Subtotal = Quantity * Price) and the overall price for all itemsdisplay it in the Subtotal column for that row.
- Click the icon in the toolbar to return to the form. In the Order Items table, select the Subtotal column by clicking on the header. In the Properties panel, uncheck Enabled. The entire column is greyed out.
- Go back to the rules editor, create a new rule and edit it. Change the name of the rule to: Calculate SubTotals
Click on the Rule Builder button. You will see the Condition wizard
Click the Add Condition button
Select your Price control from dropdown
- Select the "is filled" property from the Property dropdown
Click Next to go to the Action wizard.
Click the Add Action button on the top right of the Action Wizard
Select your Subtotal control from the dropdown.
Select "to" from the second dropdown
Type Price * Quantity in the Expressions field
Click Finish then click on the save and test icon. Now, when the end user selects the item and fills in the quantity, the Subtotal will be calculated for each row of the table
...