I have an order form where the minimum order, before shipping, needs to be $150.00
How do I create the formula for this?
Cognito-forms – Subtotal minimum amount
cognito-forms
Related Solutions
I am a developer for Cognito Forms.
Assume you have a Currency field called Utilities and a Choice field called Timeframe, with the options Monthly and Yearly. Your calculations would then be:
Monthly Amount
=Utilities / (Timeframe = "Monthly" ? 1 : 12)
Yearly Amount
=Utilities * (Timeframe = "Yearly" ? 1 : 12)
And of course you can just keep adding on additional items to the calculation for each type of cost.
I am a developer for Cognito Forms.
Currently Range Validation (ie min and/or max values) is supported on Number, Date, and Currency fields. We have recently added support to support this same Range Validation on Price and Calculation fields. That feature will be released early next week.
To enable this Range Validation add the appropriate field to the builder. At the bottom of the Field Settings there is a Range option that supports both Minimum and Maximum Values. This can be used to require that the input of the field is between the specified Minimum and Maximum values. You do not have to enter both a Min and a Max, you can specify one, the other, both, or neither. The Min/Max values can specify either a static value or calculation.
Related Topic
- Cognito-forms – Browser Compatibility with Cognito Forms
- Cognito-forms – Create post-event forms in Cognito allowing users to see what they entered in pre-event
- Cognito-forms – How to show answer from yes/no item
- Cognito-forms – How to apply a discount code to the entire order amount in Cognito Forms
- Cognito-forms – Using Cognito Form Creator to create Order Forms with Multiple Available Options
- Cognito-forms – Adding Calculator to Cognito Form to create delivery charge line item
- Cognito Forms – Calculate Current Week Number
Best Answer
I'm a developer with Cognito Forms.
You can set this up using a Calculation field with the title of 'Subtotal' and the following calculation to call and see what the Subtotal of the form is, you will also want to set the fields 'Type' to 'Currency'.
You can then set up a custom error that will prevent a user form submitting the form when the Subtotal is less then $150.00. In the custom error message, the field that i'm checking is the 'Subtotal' calculation field.