Cognito-forms – How to perform conditional calculation in Cognito Forms

cognito-forms

I want to calculate pricing based on location, destination & weight.

For example, if a user wants to send a shipment from Austria to Ireland and the weight is up to 10 kg then the price will be $27 and if up to 20 kg then $29 and so on up to 50 kg.

I have From & To fields for location & destination and I have a repeating section which includes a weight field and at the end I have a calculation field.

How can I achieve this?

Best Answer

There are two ways to write conditional if/then calculations in Cognito Forms.

if <condition> then <true result> else <false result>
<condition> ? <true result> : <false result>

For your specific example, lets assume you create a calculation outside your repeating section called Total Weight with the calculation =Packages.Sum(Weight) that sums up the weight of the items in the Packages repeating section.

You can then write the following calculation to based on your example:

=if Location = "Austria" and Destination = "Ireland" then if Weight <= 10 then $27 else if Weight < 20 then $29 else ... else ...

If you have a ton of options like this, I suspect this would be very difficult to work through. It sounds like you want to be able to look up a value from a very long table of potential values. Please provide feedback to this answer and I will be glad to refine my response.

Related Solutions

Cognito-forms – How to build a form with repeatable sections in Cognito Forms

I am a developer for Cognito Forms.

Cognito Forms supports repeating sections to capture repeating data. It also supports exporting entry data to an Excel spreadsheet with one sheet containing the main entry data and additional sheets for each repeating section. CSV export is not currently supported due to the requirement of exporting hierarchical data like this.

Anyone can sign up for free and create an organization account, but currently this is limited to one organization per user and one user per organization. This limitation will disappear in the coming months as new features are added.

Cognito-forms – Repeating section in Cognito Forms with variable costs

There are a couple of ways to handle this in Cognito Forms:

Include the camper registration fee of $60 for each camper as part of the repeating section. Then add a Price field for the multi-camper discount below the repeating section, using a calculation like =Campers.Count() > 1 ? (Campers.Count() - 1) * -30 : 0. You can hide this Price field or make it only appear when the discount is not zero. This would produce a receipt like:
```
Camper 1   
    James Philips        $60.00 
Camper 2   
    John Cartin          $60.00 
Camper 3 
    Parker Owens         $60.00
Multi-Camper Discount   ($60.00)
--------------------------------
Subtotal                $120.00
```
You could also charge $30 for each camper and have a separate $30 registration fee that applies to each application. I definitely prefer the first option since it clearly identifies the discount on the receipt.

Long term, it sounds like you would benefit from being able to use the Index of the item in the repeating section within calculations. We are looking at ways to make additional information like this available to calculations. In the mean time, hopefully these suggestions will meet your needs.

Best Answer

Related Solutions

Cognito-forms – How to build a form with repeatable sections in Cognito Forms

Cognito-forms – Repeating section in Cognito Forms with variable costs

Related Topic