Never mind, I finally figured it out.
When updating a submission inside the Form Tools Interface, here is the Pre-Parser Code that does the addition and multiplication, then successfully updates the "total_metres3" field in the database ...
if ($_POST["form_tools_calling_function"] = "ft_update_submission")
{
$_POST["total_metres3"]=("{$_POST["bed_king"]}"*2)
+("{$_POST["bed_queen"]}"*1.5)
+("{$_POST["bed_single"]}"*0.62)
+("{$_POST["bed_head"]}"*0.3)
+("{$_POST["bed_draws"]}"*0.14)
;
}
But this will only work provided that :
(1) The "total_metres3" field is in the same TAB View as ALL the other fields in the equation.
and :
(2) The "total_metres3" field is editable in that particular View.
Click the Update button and whatever value was previously in the "total_metres3" field will be overwritten with the result of the equation.
When updating a submission inside the Form Tools Interface, here is the Pre-Parser Code that does the addition and multiplication, then successfully updates the "total_metres3" field in the database ...
if ($_POST["form_tools_calling_function"] = "ft_update_submission")
{
$_POST["total_metres3"]=("{$_POST["bed_king"]}"*2)
+("{$_POST["bed_queen"]}"*1.5)
+("{$_POST["bed_single"]}"*0.62)
+("{$_POST["bed_head"]}"*0.3)
+("{$_POST["bed_draws"]}"*0.14)
;
}
But this will only work provided that :
(1) The "total_metres3" field is in the same TAB View as ALL the other fields in the equation.
and :
(2) The "total_metres3" field is editable in that particular View.
Click the Update button and whatever value was previously in the "total_metres3" field will be overwritten with the result of the equation.