Sum of entered numeric values
I am making a form for a new instructor evaluation. There are 6 criteria that are to be used and then added up. I created a "Calculate" button for each column and I would like to have the button run a script and place the total in the "Total" field. Then, depending on number in the total field, i would like the background color of that cell to change.
Can I do all of this from one script? I know that i may have to change the names of the fields so the script would work but before i did that, i wanted to throw the question out into the aether.
