Minimum order

  • photoguy123
    Asked on March 15, 2017 at 4: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.

  • Chriistian Jotform Support
    Replied on March 15, 2017 at 5: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.

     

    Minimum order Image 1 Screenshot 20

     

    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.
    Regards.

  • photoguy123
    Replied on March 15, 2017 at 5: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.

  • Nik_C
    Replied on March 15, 2017 at 5: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:

    Minimum order Image 1 Screenshot 20

    If that is what you had in mind.

    Thank you!