2. PHPRunner General questions
  3. [SOLVED]  how to calculate CBM in the add form, given the length,width,height
This topic is locked
[SOLVED]

 how to calculate CBM in the add form, given the length,width,height

 		6/15/2009 10:06:16
PHPRunner General questions
K
 kondur author

This is my formula: $values["CBM"] = ($values["shelf_length"]0.0254)($values["shelf_width"]0.0254)($values["shelf_height"]*0.0254);

This is the formula I use in the excel sheet to calculate the CBM. But when I use it in the events I am not getting the CBM result as soon as enter the length,width,height. I don;t know where to add it to get the result depending on the meausurements.
Please help me if anyone of you have done this.
thanks,

Sara
J
 		Jane 6/16/2009

Sara,
use this code in the Before record added event on the Events tab.
K
 		kondur author 6/17/2009

Hi Jane, I used in event still it is not working. Please help me with this.. It is not sending the value to the database. CBM is holding only zero value. I don;t know why.

I am stuck here. Also I tried the javascript code it is not either.
Any other suggestions.

Thanks..