Expand my Community achievements bar.

Guidelines for the Responsible Use of Generative AI in the Experience Cloud Community.
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";