Cognito-forms – How to create a calculation in Cognito Forms that has two or more conditional outcomes

cognito-forms

When building a form using Cognito Forms, I am trying to create a discount code field that will accept 2 different codes and apply each with a different discount on the base rate.

I cannot figure out how to calculate the discount code when using more than one discount code.

E.g. : CODE1 = 15% discount; CODE2 = 25% discount. These discounts are applied to a selected REGISTRATIONRATE.

I found this code for the calculation of the discount amount on the Field Setting of Price:
= CouponCode = "CODE1" ? -FullWeekendRegistration_Amount*.15 : 0

which works for one couponcode only.
What is the syntax to add the 2nd code? i.e. I want to say IF couponcode="CODE1" then apply a 15% discount to the base rate else if couponcode="CODE2" then apply a 25%.
discount to the base rate.

Best Answer

I am a developer for Cognito Forms.

The example you included was from this blog post on three ways to implement discounts in Cognito Forms.

The syntax for the discount calculation would be:

=CouponCode = "CODE1" ? 0.15 : CouponCode = "CODE2" ? 0.25 : 0

The syntax is a bit cryptic (used by JavaScript and other C languages), but generally it is:

[condition] ? [true result] : [false result]

But you can chain them together indefinitely like:

[condition 1] ? [true result 1] : [condition 2] ? [true result 2] : [condition 3] ? [true result 3] : [false result]

The full documentation for calculations can be found on the Cognito Forms help site.

Related Solutions

Cognito-forms – Calendar calculation in Cognito Forms

I am a developer for Cognito Forms.

Since February 2015 the following functionality has been made available:

In this example, I am setting the range on the Start Date field to =DateTime.Today. It could have also been =DateTime.Today.AddDays(1) to be tomorrow or later. Calculations are very robust and should cover most scenarios you can dream up, but you can also just enter literal dates.

range field

I then set the range on the End Date to be at least three days after the Start Date, but no more than seven days. Here is the calculation for the End Date minimum:

setting end date minimum

And this is how the Start Date appears on the form, with the days before today disabled:

calendar with days disabled

And similarly for the End Date, with both minimum and maximum date restrictions based on the Start Date.

calendar with days after disabled

The date range for the End Date automatically updates based on changes to the Start Date, so if an End Date is specified and the Start Date is later changed, validation will catch this if the user does not fix it first.

end date validation

Please note that range validation applies to Date, Number and Currency fields, not just the dates included in this example.

Cognito-forms – Age calculation in Cognito Forms

I am a developer for Cognito Forms

You can do this with the use of two fields. The first field is a Date filed with the label of "Birth Date". This will be the title I use in the calculation in our next field.

The next field we need to add is a Calculation field. You can title this anything you need to and for this example I used "Age" we are then going to use the fallowing calculation in the calculation field.

=DateTime.Today.Year - BirthDate.Year + (DateTime.Today.Month < BirthDate.Month or (DateTime.Today.Month = BirthDate.Month and DateTime.Today.Day < BirthDate.Day) ? -1 : 0)

This will allow a user to input their birth date into the Date field and the users age will be placed as a number onto the form in the Age field.

enter image description here

Best Answer

Related Solutions

Cognito-forms – Calendar calculation in Cognito Forms

Cognito-forms – Age calculation in Cognito Forms

Related Topic