Automatic Calculation

If a formula is set in these fields, results calculated based on values and numbers of other fields are displayed.

Example of displaying the result of the unit price multiplied by the quantity:
Image Formulas are set with one of the following fields:

  • Calculated field
    The calculated result is treated as one of the following types, and set each field to take on one of these types:
    • Number
    • Date and time
    • Date
    • Time
    • Hours
  • Text field
    The calculated result is treated as a string.

To set automatic calculation:

  1. Open the settings page of the app to which automatic calculation is to be set.
    Opening App Settings Page
  2. Click the "Form" tab.
  3. Make a note of the field code of the field that is referred by the formula.

    1. Hover the cursor over Image for the field that is referred to by the formula, and click "Settings".
    2. Make a note of the value in the "Field Code".
      If desired, you can change the field code to something that is easier to remember.
      Checking or Setting Field Codes
    3. Use the same procedure to make a note of the field code for each field that is referred by the formula.
    Image

  4. Set the formula.
    Hover the cursor over Image for the field where the calculated result is to be displayed, and click "Settings".

    • When setting the "Calculated" field
      In "Formula", enter the formula for automatic calculation.
    • Image
    • When setting the "Text" field
      Select the "Calculate automatically" check box and enter the formula for automatic calculation.
    • Image

    For field types that can be referenced from formulas, see Fields That Can Be Used as Input Values of Formulas and Data Types of the Values.
    For operators and functions available for formulas, see Operators and Functions in Automatic Calculation.

  5. When the "Calculated" field is set, select the display format of the calculated result.
    In "Show As", select the display format of the calculated result depending on the calculation type.

  6. Click "Save".

  7. Click "Save Form" on the upper left side of the screen.