Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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.

  1. 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.
  2. Go back to the rules editor, create a new rule and edit it. Change the name of the rule to: Calculate SubTotals
  3. Click on the Rule Builder button. You will see the Condition wizard

    1. Click the Add Condition button

    2. Select your Price control from dropdown

    3. Select the "is filled" property from the Property dropdown
    4. Click Next to go to the Action wizard.

    5. Click the Add Action button on the top right of the Action Wizard

    6. Select your Subtotal control from the dropdown.

    7. Select "to" from the second dropdown

    8. Type Price * Quantity in the Expressions field

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

...