Number fields allow users to input a number. The number entered by the user can be used inside a calculation or formula field.
To access the user input value for a number input include .inputvalue after the option name.
Number option with the unique name length
- Including “length” in a calculation would return the option value.
- Using length.inputvalue in a calculation would return the user input number.
- Setting option value to the user input value. You can set the value of the option to the user number input by setting the formula to length.inputvalue
This will make the calculated value for the option equal to the number input value. Now you can use the variable length inside an Option Set Calculation.
- Lookup a price from user number input.
In this example, dimensions is a pricing table.
An arbitrary constant is used as the first input. This just finds the same column every time.
length.inputvalue is used as the secondary input in the pricing table lookup. This means we will find a row matching the user input number value.