I am trying to figure out a creative solution to a problem and am hopeful that someone here can help me. My client needs to be able to price something by the square inch (they do custom sinks and shower bases). So, I have a price per square inch for them, but I then need to multiply that by both a length and width in square inches that the customer would enter. Thus, if the price was $2 per square inch I would create an input field for width and length that client would enter values. So, if they entered 1" for each value total price would be 2 (2x1x1).
The only way I can conceive of doing this is with the quantity field. So, price is $2 and first quantity is listed as "Length in inches" and customer enters that value. It would accurately multiply that value times the price. However, now I need to multiply that product times the other value of "Width in inches." But I cannot seem to figure out how to do that. Is there a way to store the value of the first product (Price x quantity1) and multiply that times the value of quantity 2?
Please let me know if I need to clarify anything.
Regards-
Dave
