Summarize values when checkbox is checked

[alpenman]

Hello all,

The output of some query shows for example 10 records with invoice prices.
Before each record is an unchecked checkbox. What I like to do is to check some
checkboxes to control the total price of the checked invoices. How can I manage
that?

Greetings,
Rudy

[MikerRoo]

What do you mean "control the total price of the checked invoices"?

Do you want to display the sum of the checked invoices? Javascript can
easily do that.
Or is it something else?

Regards,
-- MikeR

[alpenman]

Hello Mike,

Yes... I want to display the sum of the checked invoices...

Greetings,
Rudy

[Neculai Macarie]

> Hello Mike,

>
> Yes... I want to display the sum of the checked invoices...

Make those checkboxes submit the form to the server and calculate the sum on
the server.

<input type="checkbox" name="product_id#id#" onclick="this.form.submit();">

--
<mack />

[MikerRoo]

Ok, the attached code shows you one way to do it -- without having to talk to
the server at all.

Just be sure to validate and recalculate, on the server, when the user finally
submits the form. This guards against acts of browsers, hackers, and nature.

Regards,
-- MikeR


<style type="text/css">
#ItemTotalDisplay /*--- Double pound signs needed for CF. Use single
pound otherwise. ---*/
{
background-color: #CCFFCC;
border: 1px solid black;
padding: 6px;
font-size: larger;
}
</style>

<form name="frmListItems">
<p id="ItemTotalDisplay">
<!--- This next span will be overwritten by javascript. --->
Total: $<span id="domItemSumDisplay"> 0 </span>
</p>

<label for="CB_1">
<input name="cbItemList" type="checkbox" id="CB_1" value="10.99"
onclick="cjsSumChkBoxPrices ('frmListItems', 'cbItemList',
'domItemSumDisplay');">
Item 1 for $10.99
</label>

<label for="CB_2">
<input name="cbItemList" type="checkbox" id="CB_2" value="3.02"
onclick="cjsSumChkBoxPrices ('frmListItems', 'cbItemList',
'domItemSumDisplay');">
Item 2 for $3.02
</label>
</form>


<script type="text/javascript">
function cjsSumChkBoxPrices (sFormName, sCB_GrpName, sOutputElementID)
{
var zCB_Array = eval ("document.forms." + sFormName + "." +
sCB_GrpName);
var fSum = 0;
var zCntDisplay = document.getElementById (sOutputElementID);
var iNumCBoxes = zCB_Array.length;

for (iCBIdx=0; iCBIdx < iNumCBoxes; iCBIdx++)
{
if (zCB_Array[iCBIdx].checked)
{
fSum += (zCB_Array[iCBIdx].value - 0); //-- minus zero
forces number convert.
}
}

//--- Write the sum to the display span. ---
zCntDisplay.innerHTML = fSum;
}
</script>

[alpenman]

Hello Mike,

I have implemented your code in the page and it works fine for me! I have an
extra checkbox for each record because the value in the original checkbox is
the ID of the record and not the invoice value (the money).

Thanks in advance,
greetings Rudy

[MikerRoo]

Thanks for the feedback.

But, having two checkboxes may be annoying to your users.

Post another question if you want help with that. (One solution would be for
your code to write a javascript lookup table that cjsSumChkBoxPrices() would
then use to translate DB ID to price.)

Regards,
-- MikeR