Expand my Community achievements bar.

Nomination window for the Adobe Community Advisor Program, Class of 2025, is now open!
SOLVED

Trigger calculated field to unhide different fields

Avatar

Former Community Member

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

1 Accepted Solution

Avatar

Correct answer by
Level 7

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";


View solution in original post

1 Reply

Avatar

Correct answer by
Level 7

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";