The calculated fields function in WS Form PRO makes it easy to create calculate field values that are updated in realtime. It can handle everything from simple addition to more complex trigonometric functions.

## Demo

## Features

- Works with all fields that can accept a numeric input (including rating and progress).
- Calculates from any field or variable that can output a numeric output (including dates).
- Works with repeatable sections.
- Full logging to the debug console.

## Syntax

To create a calculated field value, click the field settings icon and then enter a `#calc(...)`

variable in the ‘Default Value’ setting. Anything within the brackets we be calculated in realtime on your form and used as the value of your field.

You can create calculations such as:

`#calc(1 + 2)`

You can include values from other fields on your form, for example, multiplying field ID 123 value by 5:

`#calc(#field(123) * 5)`

You can use WS Form math variables (listed at the end of this document) to perform more complex calculations, for example, rounding the previous example to two decimal places:

`#calc(#round(#field(123) * 5, 2))`

You could even create a calculated field that works out the sum of all values of a field in a repeatable section. The syntax is easy:

`#calc(#field(123))`

… where field ID 123 is a field in a repeatable section. WS Form PRO automatically sums the values together. The `#section_row_count(456)`

function (where 456 is the section ID) can be used to calculate the average value of those values:

`#calc(#field(123) / #section_row_count(456))`

There is an easy way of creating these calculations … the calculator!

### Calculator

WS Form PRO includes a calculator feature that helps creating calculated values for fields.

- Click the field settings icon.
- Click the calculator icon. On most fields this is found on the ‘Default Value’ setting.

The calculator will then appear directly below:

The cursor will automatically position itself within the #calc() function. In addition to the normal numeric and arithmetic buttons, the calculator has the following additional buttons:

**Insert Field** – Click this to insert a #field() variable into your calculated field. It lists all of the fields on your form that are compatible with the calculated field feature.

**del** – Deletes a character

**AC (All Clear)** – Deletes the entire calculation

**f** – Inserts a math variable into your calculation such as `#pi`

, `#cos(...)`

or `#sin(...)`

(See below)

*Note that whilst the calculator will do its best to maintain a suitable cursor position, you can always click on the default value itself to reposition the cursor.*

### Variables

In addition to `#field(...)`

, the following variables can be used inside with `#calc(...)`

.

Name / Variable | Additional Information |
---|---|

Absolute`#abs(number)` | Returns the absolute value of a number. |

Average`#avg(number)` | Returns the average of all the input numbers. |

Ceiling`#ceil(number)` | Rounds a number up to the next largest whole number. |

Cosine`#cos(radians)` | Returns the cosine of a radian number. |

Euler's`#exp(number)` | Returns E to the power of a number. |

Floor`#floor(number)` | Returns the largest integer value that is less than or equal to a number. |

Logarithm`#log(number)` | Returns the natural logarithm of a number. |

PI`#pi` | Returns an approximate value of PI. |

Round`#round(number, decimals)` | Returns the rounded value of a number. |

Sine`#sin(radians)` | Returns the sine of a radian number. |

Square Root`#sqrt(number)` | Returns the square root of the number. |

Tangent`#tan(radians)` | Returns the tangent of a radian number. |

Name / Variable | Additional Information |
---|---|

Seconds in a day`#seconds_day` | Returns the number of seconds in a day. |

Seconds in a minute`#seconds_minute` | Returns the number of seconds in a minute. |

Seconds in a week`#seconds_week` | Returns the number of seconds in a week. |

Seconds in a year`#seconds_year` | Returns the number of seconds in a year. |

Seconds in an hour`#seconds_hour` | Returns the number of seconds in an hour. |

Seconds since Epoch`#seconds_epoch` | Returns the number of seconds since the Unix Epoch (January 1 1970 00:00:00 GMT). |

Name / Variable | Additional Information |
---|---|

Random Number`#random_number(min, max)` | Outputs an integer between the specified minimum and maximum attributes. This function does not generate cryptographically secure values, and should not be used for cryptographic purposes. |