Matrix or Table Based Calculations?

Hi,

I’m sorry, the question is a little confused, however, if you want insert the fields with a table structure, for example with 4 columns, you simply should insert a container field (for example, a DIV field), select the option: “4 Columns” for the “Columns” attribute, and finally, insert the rest of fields into the container, or if the fields were inserted in the form, drag and drop them over the container.

Best regards.

Hi,

Ok, assuming your form includes a number field, and a dropdown field:

The fieldname1, for entering the quantity (a number field)

and the fieldname2, for selecting the colors, a dropdown field with the choices:

Choice one
Text: 1-color
Value: 1

Choice two
Text: 2-color
Value: 2

Choice three
Text: 3-color
Value: 3

Finally, insert a calculated field with the equation:

(function(){
var q = fieldname1, c = fieldname2;

if( q <= 7 && c == 1 ) return q*3.72;
if( q <= 7 && c == 2 ) return q*5.52;
if( q <= 7 && c == 3 ) return q*6.72;

if( q <= 15 && c == 1 ) return q*1.62;
if( q <= 15 && c == 2 ) return q*3.12;
if( q <= 15 && c == 3 ) return q*4.32;

if( q <= 31 && c == 1 ) return q*1.26;
if( q <= 31 && c == 2 ) return q*2.46;
if( q <= 31 && c == 3 ) return q*3.36;

if( q <= 80 && c == 1 ) return q*1.14;
if( q <= 80 && c == 2 ) return q*1.62;
if( q <= 80 && c == 3 ) return q*2.10;

return 'Please, contact us';
})()

If you need additional help implementing the equations, I can offer you a custom coding service:

http://cff.dwbooster.com/customization

Best regards.