Mathematical calculations occur directly in the form of adding/editing a record when entering data. The calculations take place using JavaScript, which allows you to use any mathematical functions and operators of JavaScript language.

Simple calculations


where 36 and 54 — id of numeric fields.

Calculation by the formula with the condition

([36]>5) ? ([36]+[54])/2:0

Custom Function

If you need more logic, then you can use the following example:

function my_function()
  my_value = [261]*[262]+get_value([260])
  if( my_value>500)
    return my_value*2
    return my_value