Calculate a field value on WebForm submission

[EBickmann]

I'm having trouble with a script. I understand that I can add to the footer of a submission DP a script that should take two "user" inputted values (Tool_Retail_Value and Tool_Sug_Rental_Rate) and perform a calculation using them and then take the result and put it back into the table into a third field (Tool_Daily_Rate).

So what's wrong?

function calculate()

{

   var rval = document.getElementById("InsertRecordTool_Retail_Value").value);

   var rrate = document.getElementById("InsertRecordTool_Sug_Rental_Rate").value);

   var drate = Math.abs(rval * rrate);

   document.getElementById("InsertRecordTool_Daily_Rate").value=drate;

}

/* On submitting the webform, the function calculate is executed */

document.getElementById("caspioform").onsubmit=calculate;

[Doc DB]

Hi,

I can see that the JavaScript has syntactical errors. I can see two unmatched parenthesis

var rval = document.getElementById("InsertRecordTool_Retail_Value").value);

and

var rrate = document.getElementById("InsertRecordTool_Sug_Rental_Rate").value);

Fix that first and then see if the rest of it works. You can look here for the correct syntax and use of that technic:

http://forums.caspio.com/viewtopic.php?f=14&t=12155

[EBickmann]

I'd spotted that too.... but with even the correction it still doesn't play nicely...

function calculate()

{

   var rval = document.getElementById("InsertRecordTool_Retail_Value").value;

   var rrate = document.getElementById("InsertRecordTool_Sug_Rental_Rate").value;

   var drate = (rval * rrate);

   document.getElementById("InsertRecordTool_Daily_Rate").value=(drate);

}

/* On submitting the webform, the function calculate is executed */

document.getElementById("caspioform").onsubmit=calculate;

[timKman]

Hi Eric,

Can you post the URL? Looking at your web page in Firebug should give a clue what's wrong.

Tim

[ChrisJ]

Tried to replicate the issue. It's working for my DataPages.

May be, any specific options on your web page.

[Kurumi]

Hi @EBickmann,

As of July 12, 2018, Caspio introduced new features which you can find here: https://howto.caspio.com/release-notes/caspio-bridge-13-0/

This release includes a new feature, Calculated Values in Submission Forms.  This allows you to generate calculations which you can use to calculate Tool_Retail_Value field and Tool_Sug_Rental_Rate field and put it to Tool_Daily_Rate. 

Check these videos for more information: