Skip to content

Intervals ​

An interval sets the value of one or more fields from the value of other fields, using rows of conditions.

Example: the price per square meter depends on the width.

Whenprice_m2 is set to
[width] from 0 to under 10030
[width] from 100 to under 20025
In every other case20

Then the price formula uses [price_m2]:

js
[width] * [height] / 10000 * [price_m2]

Add an interval ​

  1. Click Add interval.
  2. Choose the field to set (up to 5 fields).
  3. Add rows. Each row has conditions and one formula for each field to set.

Conditions in a row ​

Each condition is on one field and is either:

  • A range: From (included) and To under (not included). Leave To under empty for no upper limit. A range can't end at 0.
  • One of these values: values separated by commas, for example 1, 2, 3.5. For a dropdown or radio field use the option values. A checkbox or switch is 1 when on and 0 when off.

Text, text area, date and color fields need a list of values, not a range.

All conditions of a row must be true. A row with no condition means In every other case: it is used when no row above it applies.

How intervals work ​

  • The first row whose conditions are all true is used. The rows below it are skipped. Use the arrows to change the order of rows.
  • The formula of a row can use fields, for example [width] * 0.1. An empty formula sets 0.
  • Intervals run after the conditions and before the field formulas and the price formula.
  • An interval condition on a field that a field formula calculates sees the value the customer entered, not the calculated one.
  • The value is used for the price only. It is not shown in the field on the product page.

Limits: 20 intervals, 50 rows each, 5 fields to set, 5 conditions per row, 100 values per condition.