I have two fields
- Do you need coffee (Yes or No)
- Flat rate with a default value of 40$
I'm trying to use a conditional statement to increase the default value by 10$ if Yes is selected for coffee.
Example: Coffee Yes, Total = 50$
Page 1 / 1
Hi,
I see a couple of things here that may help you.
Firstly equals(RequireCoffee, "Yes")
If you are comparing to Yes/Now checkbox the output of the control is actually true or false.
This would mean that this should be equals(RequireCoffee, true)
Next is the IF statement. The IF statement takes 3 parameters but you are only passing 2.
So the whole formula should look like:
If(equals(RequireCoffee, true), flatrate+10,flatrate)
I see a couple of things here that may help you.
Firstly equals(RequireCoffee, "Yes")
If you are comparing to Yes/Now checkbox the output of the control is actually true or false.
This would mean that this should be equals(RequireCoffee, true)
Next is the IF statement. The IF statement takes 3 parameters but you are only passing 2.
So the whole formula should look like:
If(equals(RequireCoffee, true), flatrate+10,flatrate)
This was super helpful. Thanks
Reply
View our Community Site Map
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.