using JS to conditionally sum fields in a details report data page

[tastyT]

What I am trying to accomplish in my details report data page is to Sum the weight of each product.

s1 = product ID for the first item in the sale

s1w = product weight or units for the first item in the sale

I can not just sum all my "sw" fields because each one could possibly be tied to a different product. I have come up with the following JS solution, which is intended to run when an HTML button is clicked. Here is what I have:

In an HTML block at the top of the page:

<input type="button" value="product 1 weight" onclick="prod1w()" />

In the footer of the page:

<script>
function prod1w()
{
var v_s1 = parseFloat(document.getElementById("InsertRecords1").value);
var v_s2 = parseFloat(document.getElementById("InsertRecords2").value);
var v_s3 = parseFloat(document.getElementById("InsertRecords3").value);
var v_s4 = parseFloat(document.getElementById("InsertRecords4").value);
var v_s5 = parseFloat(document.getElementById("InsertRecords5").value);
var v_s6 = parseFloat(document.getElementById("InsertRecords6").value);
var v_s7 = parseFloat(document.getElementById("InsertRecords7").value);
var v_s8 = parseFloat(document.getElementById("InsertRecords8").value);
var v_s9 = parseFloat(document.getElementById("InsertRecords9").value);
var v_s10 = parseFloat(document.getElementById("InsertRecords10").value);

if (v_s1 == 1)
{ 
var v_prod1s1w = parseFloat(document.getElementById("InsertRecords1w").value);
}
else
{ 
var v_prod1s1w = '0'; 
}
if (v_s2 == 1)
{
var v_prod1s2w = parseFloat(document.getElementById("InsertRecords2w").value);
}
else
{
var v_prod1s2w = '0';
}
if (v_s3 == 1)
{
var v_prod1s3w = parseFloat(document.getElementById("InsertRecords3w").value);
}
else
{
var v_prod1s3w = '0';
}
if (v_s4 == 1)
{
var v_prod1s4w = parseFloat(document.getElementById("InsertRecords4w").value);
}
else
{
var v_prod1s4w = '0';
}
if (v_s5 == 1)
{
var v_prod1s5w = parseFloat(document.getElementById("InsertRecords5w").value);
}
else
{
var v_prod1s5w = '0';
}
if (v_s6 == 1)
{
var v_prod1s6w = parseFloat(document.getElementById("InsertRecords6w").value);
}
else
{
var v_prod1s6w = '0';
}
if (v_s7 == 1)
{
var v_prod1s7w = parseFloat(document.getElementById("InsertRecords7w").value);
}
else
{
var v_prod1s7w = '0';
}
if (v_s8 == 1)
{
var v_prod1s8w = parseFloat(document.getElementById("InsertRecords8w").value);
}
else
{
var v_prod1s8w = '0';
}
if (v_s9 == 1)
{
var v_prod1s9w = parseFloat(document.getElementById("InsertRecords9w").value);
}
else
{
var v_prod1s9w = '0';
}
if (v_s10 == 1)
{
var v_prod1s10w = parseFloat(document.getElementById("InsertRecords10w").value);
}
else
{
var v_prod1s10w = '0';
}

var v_prod1w = v_prod1s1w + v_prod1s2w + v_prod1s3w + v_prod1s4w + v_prod1s5w + v_prod1s6w + v_prod1s7w + v_prod1s8w + v_prod1s9w + v_prod1s10w;

document.getElementById("InsertRecordprod1w").value = (v_prod1w);
}

</script>

Update:

The problem was that the Element ID in this data page is EditRecord, I changed that out but am now running  into a different issue.

I am going to have about 20 different product ID's. I started to expand on this and added a second product ID function code segment.

My buttons are working and values are coming into my prod1w and prod2w fields.

However, something is going wrong in the calculation. The attachment shows whats happening. Based on what was entered here prod1w and prod2w should be 11.5

To add to the confusion, when products are entered in order (so s1,s2 and s3 = 1) the code works and you get the correct answer. However that is not how users will be submitting the information. I tried adjusting the else values from '0'; to just 0; but that broke it. I tried changing this line to:

document.getElementById("InsertRecordprod1w").value = math.round(v_prod1w);

Which lead to the same results.

Any ideas? 

Any and all help is greatly appreciated.

[tastyT]

For anyone who might see this I tried changing '0'; to 0; again and it worked! Don't know why. I'm not touching it again!

[IMDora]

Hi tastyT,

If you put singe quotes, the script will render it as a text and not as number/integer. That's why when you change it from '0' to 0 it worked.