- photoguy123Asked 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.
- JotForm SupportChriistianAnswered on March 15, 2017 at 05:25 AM
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.
- photoguy123Answered on March 15, 2017 at 05:41 AM
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.
- JotForm SupportNik_CAnswered on March 15, 2017 at 05:58 AM
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.