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.
| When | price_m2 is set to |
|---|---|
[width] from 0 to under 100 | 30 |
[width] from 100 to under 200 | 25 |
| In every other case | 20 |
Then the price formula uses [price_m2]:
js
[width] * [height] / 10000 * [price_m2]Add an interval
- Click Add interval.
- Choose the field to set (up to 5 fields).
- 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 is1when on and0when 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 sets0. - 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.
