Hi All,
I have three requirements which I feel can be done by either JavaScripting/FormCalc or both.
1) If the user enters "99.00" in "New Price" the "% Change" column should get populated.(% difference between Current Price & New Price +/-)
2) If the user enters "+2" in "% Change" the "New Price" should be calculated depending upon the Current Price
3) If the user enters "+2" in "CHANGE ALL PRICES BY" field then the "New Price" for entire table(mass change) should change by +2% of old price
---------------------------------------------
CHANGE ALL PRICES BY : XX %
---------------------------------------------
Current Price | New Price | % Change
$51.73 | $99.00 | +/- ??
$80.90 | ?? | +2
.
.
.
---------------------------------------------
Kindly let me know what will be the code for JavaScript/Form calc to handle each individual issue.
Waiting for help.
--Regards,
VD