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

Calculation result that makes a subform visible

usuggestaname
Level 3
Level 3

Hi - I have two fields that will have dollar amounts entered. If one of the fields is a higher dollar amount than the other field, a subform with a text field should open asking for an explanation. How would I do that? I don't have a great deal of coding knowledge. Thanks.

2 Replies
whyisthisme
Level 7
Level 7

in the exit event of the dollar amount field that if it is higher will show the subform put (in formcalc):

if ($ > NumericField1) then

yourSubform.presence = "visible"

else yourSubform.presence = "hidden"

endif

obviously changing the names of the fields to whatever you have called them.

Vjay_Reddy
Level 5
Level 5

Hi,

Keep the below script On calculate event of the subform under which these two fields are there language should be JavaScript.

yoursubform.presence = (firstNumericValue.rawValue < secondNumericValue.rawValue) ? "visible" : "hidden";

Vjay