Need help with Java math calculation

[warwick]

I am trying to maintain a agent's balance once they sell an item. I have two tables, "agents" and "orders" as well as corresponding datapages. It currently works like this:

1. Agent account is created using "agent" datapage with initial "balance" field being entered.

2. Agent logs into "orders" datapage after being authenticated by user/pass from agent table.

3. Agent balance from "agent" table is displayed on "orders" form.

4. Agent selects item which has a value of, let's say $ 10.

5. Once the agent selects "submit" I would like to have the $ amount of sale deducted from the balance field (agent table) and the result displayed on the "order" page that the agent is currently logged into. The balance field is linked to the agent table but no changes occur after order is submitted.

I'm new to Caspio and don't know squat about Java. We were assured during our trial that this could be done. Here's what I have:

function calculate()

{

//(1) Retrieve the value of the field Balance and store in a variable 'balance'.

var balance = parseFloat(document.forms[0].InsertRecordBalance.value);

//(2) Retrieve the value of the field Topup_Amt and store in a variable 'topup_amt'.

var topup_amt = parseFloat(document.forms[0].InsertRecordTopup_Amt.value);

//(3) Subtract Topup_Amt from the value Balance to obtain the value of 'balance'.

var balance = (balance - topup_amt);

//(4) Insert a rounded value of the variable 'balance' into the DataPage field Area.

document.forms[0].InsertRecordBalance.value = Math.round(area);

}

//(5) On submitting the webform, the function calculate is executed.

document.forms[0].onsubmit=calculate;

I don't know if I'm even close here but I don't understand how the above code knows what forms it's dealing with. Each line references form[0] and I'm using two forms.

Any help would be greatly appreciated. Thank you.

[anonymous3009]

Hello,

Since you mentioned using two forms, I'd suggest using 'getElementById' instead of forms[0] to access the field(s) on the form.

Here's how I'd do this:

function calculate()

{

//(1) Retrieve the value of the field Balance and store in a variable 'balance'.

var field1 = document.getElementById("InsertRecordBalance");

var balance = parseFloat(field1.value,10);

//(2) Retrieve the value of the field Topup_Amt and store in a variable 'topup_amt'.

var field2 = document.getElementById("InsertRecordTopup_Amt");

var topup_amt= parseFloat(field2.value,10);

//(3) Subtract Topup_Amt from the value Balance to obtain the value of 'balance'.

var tmp = (balance - topup_amt);

//(4) Insert a rounded value of the variable 'balance' into the DataPage field Area.

document.getElementById("InsertRecordBalance").value = tmp.toFixed(2);

}

//(5) On submitting the webform, the function calculate is executed.

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

Hope this helps. Thanks!

SO

[Kurumi]

Hi @warwick,

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 for Submission Forms.

Check these videos for more information:

 

 

 

[NailDyanC]

Hi Just to add to the previous comment above, you may also find these video tutorials useful:

 

And just an update, you can now add the Calculated Value form element to Update Forms and Details Pages to generate dynamic calculations as users interact with your forms. Previously, this feature was only available in Submission Forms. You may check this link: https://howto.caspio.com/release-notes/caspio-bridge-17-0/