Version: eXtendMobile 1.10 and above
Audience: Administrator, User

Use Case

  • Specify formulas on fields to calculate their values based on other fields.
  • Automatically generate field values based on other related fields' values.

Summary

The eXtendMobile mobile application allows you to specify formulas in your field configurations to display dynamic values based on the specified formula and values of related fields.

Note that you can only include fields of the same level in the formula. For example, if you are specifying a formula in a sublist field, you can only use sublist fields associated with that sublist and present on the form in the formula.

Configuration

The steps to create a dynamic formula field are:

  1. Open an existing function in edit mode. Note: dynamic formulas are not supported in List functions.

  2. Go to the field that requires a dynamically-calculated value.

  3. Tap the kebab icon (the three dots on the right) of the of the field and select "Details".

  4. Specify your formula in the "Custom Formula" field.
    Image Placeholder

  5. In the example screenshot shown above, the formula calculates the value of the amount field by multiplying the value of the quantity field with the value of the rate field.

    Note:     If an incorrect formula is specified, an error will be displayed as shown below: 
    Image Placeholder

  6. Save your field configuration.
When using the function, the value of the amount field will now be automatically calculated based on the quantity and rate:
Image Placeholder