a!customFieldMultiply_26r9 Function

Function

a!customFieldMultiply_26r9( value )

Used to create a real-time custom record field, this function returns the result of multiplying a series of values. You can multiply record fields, related record fields, or literal values of type Number (Integer) or Number (Decimal Floating).

Parameters

Usage considerations

Where to use this function

The a!customFieldMultiply_26r9() function can only be used to create a custom record field that evaluates in real time. This means you can reference related record fields, constants, and other supported functions in your calculations.

To create a custom record field that evaluates in real-time:

1. In your record type, go to Data Model.
2. Click NEW CUSTOM RECORD FIELD.
3. From SELECT A TEMPLATE, choose Write Your Own Expression.
4. Choose Real-time evaluation.
5. Click NEXT.

6. Enter an expression using any Custom Field function.

   Note:  Custom record fields that evaluate in real-time must use at least one Custom Field function.

7. Click NEXT.
8. Enter a Name for your custom record field.
9. Click CREATE.
10. Click SAVE. The new custom record field appears in your list of fields.

Use with other Custom Field functions

You can use the a!customFieldMultiply_26r9() function in conjunction with other Custom Field functions, like a!customFieldSubtract(), a!customFieldSum(), or a!customFieldDivide() to create the calculations you need.

See the Real-time evaluation recipes for an example.

Example

Let's say you want to calculate each employee's potential bonus amount.

The Employee record type has an annualSalary field, which contains each employee's salary amount. The Level record type has a percentBonus field, which determines the potential bonus amount based on an employee's level in the organization.

To calculate each employee's potential bonus amount, you could create a custom record field on the Employee record type that evaluates in real-time so you can reference the related record field from the Level record type in your calculation.

The expression would look something like this:

1
2
3
4
5
6
a!customFieldMultiply_26r9(
  value: {
    recordType!Employee.fields.annualSalary,
    recordType!Employee.relationships.level.fields.percentBonus
  }
)

Feature compatibility

Feedback