I have an HTML cfgrid that contains fields for quantity, name (which is the description of the work done), price and amount (the price times the quantity). Upon loading, the grid will start out blank (this is for new jobs). When the client starts entering data into the grid, I need the grid to calculate the total based upon quantity times price and update the amount field accordingly. I also need it to calculate the subtotal by adding all the amount fields in the grid together. Both the form and the grid MUST be in HTML format. I've tried to adapt several techniques I found online, but to no avail. I found some code that works flawlessly on a Flash formatted grid in a Flash form, but I can't seem to get it to work with an HTML formatted grid. Does anyone have any solution for this? It's driving me bonkers. Here is the code for the grid:
<cfgrid name="details" format="html" width="820" selectMode="edit" insert="yes" delete="yes" italic="no" bold="no" gridLines="yes" colHeaders="yes" colHeaderItalic="no" colHeaderBold="yes" enabled="Yes" visible="Yes" rowheaders="no"> <cfgridcolumn name="quantity" header= "Qty." Select="Yes" type="numeric" width="50" textcolor="##003366" bold="No" dataalign="left" headeralign="center" headerbold="yes" headertextcolor="##003366"> <cfgridcolumn name="name" header="Description" Select="Yes" width="600" textcolor="##003366" bold="No" dataalign="left" headeralign="center" headerbold="yes" headertextcolor="##003366"> <cfgridcolumn name="price" header="Cost" select="Yes" width="100" textcolor="##003366" bold="No" dataalign="left" headeralign="center" headerbold="yes" headertextcolor="##003366"> <cfgridcolumn name="amount" header="Subtotal" type="numeric" dataalign="right" select="false" width="60"> </cfgrid> Any help would be greatly appreciated, thanks. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350081 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
