Field script output based on range in another field
Hi there,
I am creating a fillable form and have used different scripts to automatically calculate figures or copy information to page 2. I am however stuck on one field I cannot seem to resolve:
On the form section there are 2 fields.
field1: quantity
field2:rate
in the second field I want to output a rate based on the pricing tier we have and based on quantity entered in field 1.
After that I would just multiply those 2 fields which is easy. I just am struggling with setting the script. These are the attempts I have made but each time it outputs the same rate. I feel like I am close but need help asap.
event.value=Number(ifthisgetField("Students"<=4000))(event.value=1.24);
if(2000<="Students"<4000)(event.value=1.46);
if(1000<="Students"<2000)(event.value=1.67);
if(500<="Students"<1000)(event.value=1.98);
if(250<="Students"<500)(event.value=2.50);
if(150<="Students"<250)(event.value=2.66);
if(100<="Students"<150)(event.value=2.96);
if(25<="Students"<100)(event.value=3.32);
Or
var v1 = this.getField("Students").value;
if (v1 >= 25) {event.value = "3.32";}
else if (v1 >=25 && v1 <100) {event.value = (v1);}
else if (v1 >100) { event.value = "3.32";}
var v1 = this.get.Field("Students").value;
if (v1 >=100&&v1<150) {event.value = (v1);}
else if (v1 >=100 &&v1 <150) {event.value = "2.96";}
else if (v1 >150) {event.value ="2.96";}
event.value=Number(ifthisgetField("Students"<=4000))(event.value=1.24);
if(2000<="Students"<4000)(event.value=1.46);
if(1000<="Students"<2000)(event.value=1.67);
if(500<="Students"<1000)(event.value=1.98);
if(250<="Students"<500)(event.value=2.50);
if(150<="Students"<250)(event.value=2.66);
if(100<="Students"<150)(event.value=2.96);
if(25<="Students"<100)(event.value=3.32);
