Oct 27, 2020 11:44 AM
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?
Oct 27, 2020 03:30 PM
The formula would be something like:
IF({field 2} < ({field 1} * .05), "what to show if less than 5%")
Oct 27, 2020 11:49 PM
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
Oct 27, 2020 11:52 PM
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.
