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?
Use formula in conditional display of form field
+27The formula would be something like:
IF({field 2} < ({field 1} * .05), "what to show if less than 5%")
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
+27Hi 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.
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.