My problem.
Ive created a form that calculates all the total fields without a problem. The issue Im having is there is a separate part to the form which needs to be included and Im not sure how to go about it. Im assuming that JavaScript will be the best option but Ive been trying to teach myself the last few days and I just want to make sure Im heading down the right path.
Here is a screen grab of what I'm trying to do:
http://img471.imageshack.us/img471/8540/form4nl.jpgWhat is required?
As the user fills in the form there is a Sunday to Saturday section which is pretty straight forward. In addition to this section the user can fill in a special items section. Currently the user needs to manually copy the total of the special section into the special column.
The special column can only display one figure. So if the user click on the Monday cell for that column and then changes their mind and click Wednesday the script would need to remove the figure in Mondays cell and apply I to Wednesdays cell.
Wish:
Would it be possible to have it so that the form automatically fills the cell with the total once the user clicks on it?
Am I correct it assuming JavaScript can do this is Designer?
Any suggestions would be appreciated.
Regards, John.