Adding 3 Text Fields And Writting Total To Table

[senicholas]

I have been working the code below, adding 3 text fields and tying to write the total to the field TTL_Crates, but, I cannot get it to work. Any ideas?

 

 

<br />

 

<script language="JavaScript">

 

 

 

function calculate()

 

{

 

   var v_one= parseFloat (document.getElementById("InsertRecordCrate_One_Quantity").value);

 

 

 

  var v_two= parseFloat (document.getElementById("InsertRecordCrate_Two_Quantity").value);

 

 

 

   var v_three= parseFloat (document.getElementById("InsertRecordCrate_Three_Quantity").value);

 

 

 

 

 

   var v_total  = (v_one + v_two + v_three);

 

document.getElementByID(“InsertRecordTTL_Cratesâ€).value= (v_total);  }

 

 

 

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

 

document.getElementById("InsertRecordBid_Order Web Form_1").onsubmit=calculate;

 

[Jan]

Hello senicholas,

 

You can try using the following script:

<script language="JavaScript">

function calculate()
{
var v_one = parseFloat(document.getElementById("InsertRecordCrate_One_Quantity").value);
var v_two = parseFloat(document.getElementById("InsertRecordCrate_Two_Quantity").value);
var v_three = parseFloat(document.getElementById("InsertRecordCrate_Three_Quantity").value);

var v_total  = v_one + v_two + v_three;

document.getElementByID(“InsertRecordTTL_Cratesâ€).value = v_total;
}

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

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

</script>

I hope, it helps.

[senicholas]

Thanks, I made the modifications, but it still does not write to the DB. Are only text fields allowed to writer to?

[Jan]

Hello senicholas,

 

As far as i know, usually "Hidden" and "Text Area" fields are allowed too. There are some tricks with Dropdowns and Listboxes, Checkboxes and Radiobuttons.

Which Form Element do you use?

 

Could you provide the URL of your page?

[senicholas]

The crate_one_Quanity fields are number fields and the ttl_crate field is a text. The url on my test page is:

 

https://b5.caspio.com/dp.asp?AppKey=9f653000b65254d3e607447ab34e

[senicholas]

Maybe this is my problem, I have the crate_xx_quanity fields in the form as text, but the db is number.

[Jan]

If I understand correctly, now the following code is used:

 

<script language="JavaScript">

function calculate()

{

   var v_one= parseFloat (document.getElementById("InsertRecordCrate_One_Quantity").value);

   var v_two= parseFloat (document.getElementById("InsertRecordCrate_Two_Quantity").value);

   var v_three= parseFloat (document.getElementById("InsertRecordCrate_Three_Quantity").value);

   var v_total  = v_one + v_two + v_three;

   document.getElementByID(“InsertRecordTTL_Cratesâ€).value= v_total; } document.getElementById("caspioform").onsubmit=calculate;

</script>

 

There are two misprints in the following line

document.getElementByID(“InsertRecordTTL_Cratesâ€).value= v_total; } 

Incorrect quotes and "ID"

 

You can try to change the line as follows:

document.getElementById("InsertRecordTTL_Crates").value= v_total; }

I hope, it helps.

[senicholas]

I changed the default value to 0 on the fields I am adding and it works like a charm. Thank you very much!!!!

[Kurumi]

Hi @senicholas,

As Caspio had their releases. You can now do this without using JavaScript.  You can check it 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 for your total.

Check these videos for more information:

 

I hope it helps.