How To Count In A Submission Form

[wvantongeren]

How can I count the value's  in this Submission Form.

 

 

[wvantongeren]

[svitlanataran]

Hi, you can use Script from the following post: http://forums.caspio.com/index.php/topic/3149-js-perform-a-calculation-on-values-entered-in-a-webform/

[wvantongeren]

Do not understand javascript
can you please help a little?

[MayMusic]

Can you give us the URL to the page and also explain what exactly you want to perform on that page so we can assist you?

[wvantongeren]

Thanks Caspio Evangelist, for your replay.

 

Here is my URL: http://hemubo.weebly.com/test2.html

 

and a litle bit more explanation.

[Xiang]

Hi wvantongeren,

 

How are you doing?

 

I think, you can use the following script:

<SCRIPT LANGUAGE="JavaScript">
function calculate()
{
var v_Werkuren = parseFloat(document.getElementById("InsertRecordWerkuren").value);
var v_DWM_uren = parseFloat(document.getElementById("InsertRecorddwmuren").value);
var v_55_uren = parseFloat(document.getElementById("InsertRecorduren55").value);
var v_Ziekte_uren = parseFloat(document.getElementById("InsertRecordziekteuren").value);
var v_Scholingsuren = parseFloat(document.getElementById("InsertRecordschooluren").value);
var v_Onbetaalde_uren = parseFloat(document.getElementById("InsertRecordonbeturen").value);
var v_totaaluren = v_Werkuren + v_DWM_uren + v_55_uren + v_Ziekte_uren + v_Scholingsuren - v_Onbetaalde_uren;
document.getElementById("InsertRecordtotaaluren").value = v_totaaluren;
}
document.getElementById("caspioform").onsubmit=calculate;
</SCRIPT>

Could you please let me know, if the script works?

 

 

Have a nice day!

[wvantongeren]

Xiang,

 

huge thanks for your help !
It works great .

1000 x thanks.

Greetings from the Netherlands

[NailDyanC]

Just to update this post and add a comment from the previous comment above, you may also try using Calculated value in your submission form to calculate data entries. You may check this link for more details:  https://howto.caspio.com/datapages/datapage-components/calculated-values/