Skip to main content
Known Participant
March 22, 2023
Question

Javascript Age/Rate not working properly

  • March 22, 2023
  • 1 reply
  • 378 views

All,  I have a form that requires an age field calculation (working correctly) and then another field that has a rate table based on the age of that prior field (not working correctly).  Please help!  This is the script I am currently using:

 

event.value = "";
var SPage=Number(this.getField("SpouseAge").valueAsString);
var rate=0
if (this.getField("SPCH1").value=="Spouse")

if (SPage<14) rate=120.000;
else if (SPage<=15) rate=130.670;
else if (SPage<=16) rate=134.750;
else if (SPage<=17) rate=138.820;
else if (SPage<=18) rate=143.220;
else if (SPage<=19) rate=147.610;
else if (SPage<=20) rate=152.160;
else if (SPage<=21) rate=156.86;
else if (SPage<=22) rate=156.86;
else if (SPage<=23) rate=156.86;
else if (SPage>=24) rate=156.86;
else if (SPage<=25) rate=157.49;
else if (SPage<=26) rate=160.63;
else if (SPage<=27) rate=164.39;
else if (SPage<=28) rate=170.51;
else if (SPage<=29) rate=175.53;
else if (SPage<=30) rate=178.04;
else if (SPage<=31) rate=181.80;
else if (SPage<=32) rate=185.57;
else if (SPage>=33) rate=187.92;
else if (SPage<=34) rate=190.43;
else if (SPage<=35) rate=191.69;
else if (SPage<=36) rate=192.94;
else if (SPage<=37) rate=194.20;
else if (SPage<=38) rate=195.45;
else if (SPage<=39) rate=197.96;
else if (SPage<=40) rate=200.47;
else if (SPage<=41) rate=204.24;
else if (SPage>=42) rate=207.84;
else if (SPage<=43) rate=212.86;
else if (SPage<=44) rate=219.14;
else if (SPage<=45) rate=226.51;
else if (SPage<=46) rate=235.30;
else if (SPage<=47) rate=245.18;
else if (SPage<=48) rate=256.47;
else if (SPage<=49) rate=267.61;
else if (SPage<=50) rate=280.16;
else if (SPage>=51) rate=292.55;
else if (SPage<=52) rate=306.20;
else if (SPage<=53) rate=320.00;
else if (SPage<=54) rate=334.90;
else if (SPage<=55) rate=349.80;
else if (SPage<=56) rate=365.96;
else if (SPage>=57) rate=382.27;
else if (SPage<=58) rate=399.69;
else if (SPage<=59) rate=408.31;
else if (SPage<=60) rate=425.73;
else if (SPage<=61) rate=440.78;
else if (SPage<=62) rate=450.67;
else if (SPage<=63) rate=463.06;
else if (SPage>=64) rate=470.59;
event.value=rate

 

I think it is my last event.value but not sure what is wrong with it.

This topic has been closed for replies.

1 reply

Bernd Alheit
Community Expert
Community Expert
March 22, 2023

What happens when you use the script?

Known Participant
March 22, 2023

It is pulling the rate for the test employee's age and not the spouse's age.