Trigger calculated field to unhide different fields

Avatar

Avatar

sp215

Avatar

sp215

sp215

16-04-2015

I have a calculated field (rate) which is used to calculate a total value which if the amount field is above a certain amount would then display one of 2 hidden fields but I am not sure how to trigger the code from the amount field

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

jasotastic81

Avatar

jasotastic81

jasotastic81

16-04-2015

Here are some examples. They would go in the calculate event of your amount field

Say there's a $5,000 threshold for the field to be visible.


if (this.rawValue > 5000) field1.presence = "visible";


else field1.presence = "hidden"; //to rehide if the amount drops below your threshold.


If there's a second threshold for the other hidden field like $2,000 for field1 and 5,000 for field2.


if (this.rawValue > 5000) field1.presence = field2.presence = "visible";


else if (this.rawValue > 2000) {


  field1.presence = "visible";


  field2.presence = "hidden";


}


else field1.presence = field2.presence = "hidden";


Answers (0)