Database

I'm crying uncle. After 2 weeks I can't seem to figure this out myself.  I'm on moodle 2.4 on a lamp system on server 2008.  I just want to calulate in one column using another. I tried the two examples I found on moodle without luck.  They were zip files that did not even load until I changed them to .mbz and then they failed with these errors:

Debug info: 
Error code: cannot_precheck_wrong_status 
$a contents: 200

Here are the one's I tried:

BMI_-_JS_to_calculate_field_and_lists_horizontally

Calculated_field-preset-20110131_0107

Then I downloaded my own example by making a preset of the dataform. Upon opening it and comparing to those above they have very different contents. 

2nd I tried for another week learning Java and programming it in.  I found 19 websites with examples and a bunch frrom Itamar - pasted them all in with many variations without joy.

I assume the javascript or html goes into the repeated entry section by going to manage tab then click view then in my case edit the tabular view.  I changed them to Plain text view in the drop down as well as on my profile because it kept deleting my code.  I got some java scripts to work but I can't seem to get any values corresponding to the items in my table. I set up a table with the same values as in the BMI example but in my dropdown I don't see choices like Weight#id  instead I see weight  so where do I find the correct id name so I can use it?

I tried various scripts from these links without success so I'm missing the concept of identifying the objects and cells in my code.  For example why are these two suggestions so different:

%%F1:=||Lecture 1:value||+||Lecture 2:value||+||Lecture 3:value||+||Lecture 4:value||%%

and a snippet of this code both used as solutions for dataforms

<script type="text/javascript">// <![CDATA[
document.getElementById('Weight#id').Xonkeypress=function(){setBmi();};
document.getElementById('Height#id').Xonkeypress=function(){setBmi();};
function setBmi(){
var weight=document.getElementById('Weight#id').value;
var height=document.getElementById('Height#id').value;

Why does one use ( ) and # signs before the value and the other uses [] and .value is 
inside: ex ("Weighted#id).value vs [Lecture 1 .value]
I figured out that F1 meant all the data cells for col F and F2 is for the header but I
tried using C1 for my 3rd column for BMI and I could not get anything to show up.

I realize I am so behind the curve that I'm a project needing much more than just 
tweaking but if I could only get an example to load I could figure it out easier.  I did 
the same thing 10 years ago with VBA and now I can use it to solve a lot of things.
 I'm hoping this does not take me 10 years though.  

Thanks in advance :) JT

Perfect! Just the direction I needed!

I didn't realize you could add .innerHTML to the document.getElementById statement.

Thanks Itamar!

My final database looks like the image attached, and I updated the code for the last row to the following:

<tr class="totalrow**">
<td></td>
<td align="right"><strong>TOTALS >></strong></td>
<td align="right" id="totalP"></td>
<td align="right" id="totalC"></td>
<td align="right" id="totalB"></td>
<td></td>
</tr>
</tbody>
</table>
<script language="javascript" type="text/javascript">
var pledgeList=document.getElementById('pledgeData');
var theRows=pledgeList.firstChild.rows;
var countP=0;
var countC=0;
var countB=0;
for (var j=1; j<theRows.length; j++) { start j from 1 not 2, as it automatically skips the heading row
var theCells = theRows[j].cells;
countP+=Number(theCells[2].innerHTML); also note that column 1 is really [0]
countC+=Number(theCells[3].innerHTML);
countB+=Number(theCells[4].innerHTML);
}
document.getElementById('totalP').innerHTML=countP;
document.getElementById('totalC').innerHTML=countC;
document.getElementById('totalB').innerHTML=countB;
</script>

**the row class is just for css, not the script

Thanks again!

Sarah