Pool Water Volume Calculator?

Hello @filmguy2013

Yes of course, you simply should to insert four number fields (the names of the fields are assigned dynamically, but I’ll assume they are: fieldname1, fieldname2, fieldname3 and fieldname4)

and then, you simply should insert a calculated field, and enter the following equation through its “Set Equation” attribute:

fieldname1*fieldname2*fieldname3*fieldname4*7.5

And that’s all.
Of course, using the correct names of the fields in your form.

Best regards.

Hello. Thank you for the quick reply. I did what you said to do, but the form is performing the equation like so, if I insert a 2 in each of the four fields which would be 2*2*2*2*7.5 the total comes to 120 when it should be 60 because the calculator is multiplying the total of the first two fields by field 3 and then multiplying that by 7.5. How do I set the calculator to multiply all four fields one by one and THEN multiply that total by 7.5 so that I would get 60 instead of 120 if I insert a 2 in each field?

Also, is there a way to add a button and make the user click the button to see the total?

Thanks.

Hello @filmguy2013

In mathematics the order of factors does not alter the product. So, if you multiply first all four fields between them, and then, by 7.5 the result would be the same: 2*2*2*2 = 16 and 16*7.5 = 120, the issue is your formula definition.

First, the volume of the figure would never be: field1*field2*field3*field4, it depends on the shape of figure.

If you want the equations won’t be evaluated dynamically:

– Untick the checkbox: “Eval dynamically the equations associated to the calculated fields”, in the “Form Settings” tab (https://cff.dwbooster.com/images/documentation/form-settings-tab.png)

– Insert a button field in the form, and select the “Calculate” option as the button’s type in its settings.

Best regards.

Hello. So, if I understand you correctly, I can’t make the form calculate the numbers so that 2*2*2*2*7.5 = 60? The form is always going to multiply by by consecutive order so that 2*2*2*2*7.5 = 120?

I unchecked the “Eval dynamically the equations associated to the calculated fields” box and saved the settings and then tried again and the total still came out to 120 instead of 60.

Hello @filmguy2013

I’m not talking about the plugin, it is not mathematically possible that this operation:

2*2*2*2*7.5 returns 60

Your formula for the volume is incorrect.

– If the swimming pool is rectangular, with the same depth in every point, the volume would be: width*length*depth

– If the slope of the swimming pool start in zero, until the maximum depth in the other end, the volume would be: width*length*depth/2

So, the correct would be to use the average: width*length*(depth A+depth B)/2

In whose case the equation associated to the calculated field would be:

fieldname1*fieldname2*(fieldname3+fieldname4)/2*7.5

You need to know the mathematics you want to calculate.

Best regards.

That worked! Sorry man, me went to the public schools. In all seriousness though, thank you so much for your help! I am now going to give your plugin a 5 star review.

Just left a 5 star review. Thanks again!

Thank you very much.