sydeburn
Member
Is it possible to use conditional statements and values from multiple fields in calculation formulas? For example, say I have a number field called calc1, and I apply a formula to it. I want the value to be calculated based on what was answered in previous questions q1 and q2:
calc1 = 2 if (q1==yes AND q2==yes)
else
calc1=1 if (q1==yes OR q2==yes)
else
calc1=0
Thanks in advance.
Conditional statements are not supported in the calculations. You might be able to do this with conditional logic but I'm unclear what it is you need to do based on your question.
sydeburn
Member
What I want to do is show/store a value based on the way multiple questions were answered. In my example above, I'm saying I want to show "2" if the user answered "yes" to BOTH questions A and B, or show "1" if the user answered yes to EITHER A or B.
If you need that information stored in the entry, but it does not need to be shown on screen, you can use the gform_pre_submission filter http://www.gravityhelp.com/documentation/page/Gform_pre_submission_filter to read the values which were submitted, then perform your logic based on the answers, then update a hidden field in the form.
