What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
Minimum orderAsked by photoguy123 on March 15, 2017 at 04:56 AM
Is there any trick using formulas to never be below a certain number. now i know i can do this with conditions, but i was wondering if there's just a better formula i could use. the idea is if i have a minimum order value of $50 but the customer only enters $20 of product, i would want the formula to fill $50 until it goes above that minimum.
I'm not quite sure what you mean by formulas to never be below a certain number. If you do not want the user of your form to enter a value below $50, you can set this as a default to the field so that they cannot change it.
However, if you mean something else, please provide us more details and please also provide us the form URL you are working on so that we can better assist you.
We'll wait for your response.
I gave an example. To clarify, I'm using a form calculation field to calculate cost. If a customer only orders $12.50 worth of product, I want that the field fills with $50 instead because $50 is the minimum order.
I've solved this problem using the mathematical function max (formula, minimumOrder). If above $50, the formula will fill the proper price. But if the formula results in an order under $50, it will automatically fill the field with 50. I've tested it and it works.
It's a little tricky though using a comma in that max() function. Supposedly you need to click the comma several times to get this to work. By default when I type in a comma, it just appears as text. There is no visual difference to indicate to me that it's a mathematical comma. You really should just include a clickable comma to make that more straightforward.
Anyway, I hope this is helpful to others because max() is a useful feature if you know how to use it.
Thank you for sharing your solution for this problem.
It is true, the max function would be the best solution for the situation you described. The clicking problem you mentioned is actually switching from string to numerical:
If that is what you had in mind.