value range

solved

Hi. How do you solve this? I’m trying to set of a value range for window dimensions. For example, any number entered between 10 and 20 (inches) would have a value of 100 (dollars), 21-30in would be $150, etc.

-Andy

Hi @andysb72,

The required equations can be implemented even with the free version of the plugin, however, for sending the notification emails with the information collected through the form, is need the professional version of the plugin.

Now, the equation:

In your description you are using only the width to estimate the window’s price, so, I’ll use only the width in the equation. Assuming that the field for width is the fieldname1, the equation associated to the calculated field would as follows:

(function(){
var width = fieldname1;

if(10<= width && width <= 20 ) return 100;
if(20< width && width <= 30 ) return 150;

return 'Invalid Width';
})()

Note: In the previous equation you can include other conditional statements for different ranges.

Best regards.