Question

Field Rule for Greater Than

Forms

Updated October 3, 2019

asked on April 16, 2019

I have 2 different sections in a form and need one to populate based on if a variable is greater than or less than/equal to a specific number that is generated in that variable.

For Example.

Section A if variable is greater than 90

Section B if variable is less than or equal to 90.

0 0

Answer

SELECTED ANSWER

replied on April 16, 2019 • Show version history

The fields you're using in the field rule need to be Number types in order to use the less than or greater than comparisions

Your screenshot indicates you're using some kind of text field like a Single Line, which will not work for numeric comparisons.

Number fields would show "is equal to" instead of "is" in the comparison.

2 0

Replies

replied on April 16, 2019

If 90 is a constant number, you can set this up using field rules. If 90 changes per instance, you can create a hidden field for Visible_Section with a formula that does the comparison. Write the formula as something like =IF(Variable > 90, "A", "B") which reads "If the variable is greater than 90 (or use the other variable to compare to), put "A", otherwise put "B". Then in the field rule put "Show Section A if Visible_Section is A", "Show Section B if Visible_Selection is B".

0 0

replied on April 16, 2019

The 90 is a constant when compared again the field. This is what I have so far in the screenshot.

Capture.JPG (31.12 KB)

| Download

0 0

SELECTED ANSWER

replied on April 16, 2019 • Show version history

The fields you're using in the field rule need to be Number types in order to use the less than or greater than comparisions

Your screenshot indicates you're using some kind of text field like a Single Line, which will not work for numeric comparisons.

Number fields would show "is equal to" instead of "is" in the comparison.

2 0

replied on April 17, 2019

That worked. Thank you

0 0

replied on October 3, 2019

What is it is greater than another numeric value on the Form? Ie. If Quantity Processed is Greater than Quantity Received? Would like a message to appear and prevent form submission.

0 0

You are not allowed to follow up in this post.

Question

Question

Field Rule for Greater Than

Answer

Replies

Sign in to reply to this post.