Help

Use formula in conditional display of form field

Topic Labels: Views
747 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Ryana
5 - Automation Enthusiast
5 - Automation Enthusiast

I have three fields in a form. The first two hold a number, the last one I want to appear only if the second number is less than x% of the first number. Is there a way for me to use a formula within the display logic to achieve this?

3 Replies 3

The formula would be something like:

IF({field 2} < ({field 1} * .05), "what to show if less than 5%")

Hi Kamille, rather than showing a value if the conditions are met, I am wanting to use this formula to decide if a field is shown in the form view

Oh, that can’t be done. The conditional form field display isn’t quite sophisticated enough to compare values to each other, only predefined values.