0 Replies Latest reply on Nov 11, 2012 8:28 PM by marky_mark_mcri

    Javascript for Automated Tax Calculation

    marky_mark_mcri

      Hi,

       

      I am a novice form builder and need some help with a javascrip query.

       

      From the attached image below I am trying to write scripts that will automatically calculate the 10% GST tax.

       

      So, in the "$ Amount (Incl GST)" column (Text7 Box) I would type $110.00 and hit enter and have it automatically calculate and add $10.00 to the "GST" (Text6 Box) and $100.00 to the "Amount Excl GST" column (Text5 Box), and the cursor would then appear in the Text8 box.

       

      I was also hoping to be able to override these amounts if I wish as sometimes with international vendors you are not required to pay GST.

       

      At present I have been using these Simplified Field Notations but they cannot be overriden and do not seem to update unless you enter an amount in the following row.

      (Text5 Box) = Text7 - Text6

      (Text6 Box) = Text7 *10/100

       

      Any help would be greatly apreciated, so thanks in advance!

      Mark

       

      Requisition Example.jpg