Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Trigger calculated field to unhide different fields

Anonymous
Not applicable

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
jasotastic81
Correct answer by
Level 7
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

0 Replies
jasotastic81
Correct answer by
Level 7
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