You are viewing limited content. For full access, please sign in.

Question

Comparing one value to another in forms

Forms Version 10 How To

Updated February 10, 2021

asked on February 9, 2021

I am trying to (learn) design a Budget Adjustment form. I have the amounts to increase, and decrease, totaling correctly in their respective sum boxes.

Now I want to hide the justification section of the form (and prevent submission) until both the sum of increase and the sum of decrease equal each other (balance out).

What do I need to do to accomplish this process? Thank you.

0 0

Replies

replied on February 10, 2021

Hi Jeff

As Field Rules don't allow you to compare two field values against each other, typically what I would do is to create a Field (Ie: ShowJustification) with a formula that does the validation with an outcome of Yes or No.

example =IF(Sum_of_Increase=Sum_of_Decrease,"Yes","No")

Then I would use the output of this field (ShowJustification) in the Field Rule

Show Justification Section when ShowJustification equals Yes

3 0

You are not allowed to follow up in this post.

Sign in to reply to this post.

Asked February 9, 2021
Updated February 10, 2021
82 views