Community

I can't add multiple coupon codes

Wynand De Kock

Nov 14, 2023

Comments (1)

Hi Wynand, you can use the IFS function to set up multiple coupon codes. For example, you can use the below formula to apply a 15% discount for LOYAL15 and a $10 discount for WELOME. IFS(Coupon Code == "LOYAL15", 0.15 * Order Amount, Coupon Code == "WELCOME10", 10,0) Please note that Coupon codes are case sensitive. You can change the coupon code and discount percentage as required. You can also add multiple coupon codes or provide fixed discounts. Notes for your reference IFS function evaluates multiple conditions and returns a value that corresponds to the first true condition. Syntax: IFS(condition1, value1, condition2, value2, …) where condition1 - The first condition to be evaluated. value1 - The returned value if condition1 is TRUE. condition2, value2, … - Additional conditions and values if the first one is evaluated to be false. You can evaluate multiple conditions using the IFS function. For example, IFS(Age > 60, "Old", Age > 18, "Adult", Age >=12, "Teenager", "Kid"). If you would like to use the AND logical condition, You can use && operator as shown below. IFS(Age == x && Weight == y, "string1", "string2") IFS(Age == x && Weight == y, calculation1, calculation2) If you would like to use the OR logical condition, You can use || operator as shown below. IFS(Age == x || Weight == y, "string1", "string2") IFS(Age == x || Weight == y, calculation1, calculation2) Note: To use any form field in the Calculations, type @, it will show a list of all the fields in the form. Select the required field from the list.

Add your comment