6 Replies Latest reply on Jan 19, 2018 4:57 PM by gkaiseril

    Having trouble with result not changing if another number is added into the equation....


      Hello Friends,


      Thank you in advance for helping me learn Javascript!  If anyone has any advice on my current issue that would be fantastic.  I hope I can explain this so it's understandable.  Here are the scenarios:


      Cell D = L16

      Cell E = L17

      Cell F = L18

      Cell H = L20

      Cell I = L21

      Cell J = L22


      Example:  If $10,000 is entered in Cell D, $250 is entered in Cell E, $250 is entered in Cell F, I've written script that limits the entry into Cell F to 1.5%.  Cell J will automatically be $10,000.  Here is my script which works!  The result is $150.


      var a = this.getField("L22").value;

      if (event.value > a * .015)event.value=(event.value = a * .015);

      else event.value;


      if (event.value) event.value = util.printf("%.4f", event.value);


      The issue happens when I enter an amount into Cell H (example $5,000).  It is supposed to reduce Cell J.  So, the original amount of $10,000 will reduce by $5,000 with a new result of $5,000.  Cell F should reduce down to $75.00.  The problem is it doesn't reduce.  It stays at $150.  If I go back to Cell F and enter $250 again then it calculates down to $75.  I am stumped how to write so it changes if a number is entered into Cell H and/or Cell I.