How to set a minimum order quantity in your order forms?

This is a common question from small sellers who pack and deliver every order themselves. For example, small orders may not be worth delivering, so you want a minimum quantity on each order. A Google Form can check one answer, but it cannot count the items your customer picked across products, so a small order still comes in and you have to go back to the customer. With Neartail, you can add a number validation to the Order Quantity question to enforce a minimum or maximum order quantity. Your customers will see your message until they add enough. Even better, the QUANTITY formula is already in your form, so you only set the number.

Let's start. Create your order form and follow the steps below.

How to set a minimum order quantity?

  • On the page that opens, click "Enter your form name". Type your form's name, click Generate and wait about a minute.
  • Check the outline it suggests and click Proceed.
  • Once you create the form, you will land on the form's "Edit" tab. If it asks "Do you want to preview this form?", click No.
The tabs Edit, Preview, Share and Orders, with Edit marked
  • Your form comes with products, an Order Amount question that adds up by itself and an Order Quantity question. Click on each product and check its name and price, because a generated product can have no name and a price of 0.
To enforce a minimum order quantity, add a "greater than or equal to" number validation for the order quantity question. Please follow the detailed instructions below.
  • Click on the Order Quantity question, then click the ⚙️ icon
  • Field settings screen will be displayed. Select the "Answer" tab. The QUANTITY formula is already in the Calculate option
  • Click Configure under Validation
  • Select "Greater than or equal to" number validation and enter the minimum quantity. Enter the error message and click Save
The Order Quantity question selected in the editor, with its title and the gear at the bottom of its card marked
Similarly you can set a maximum order quantity by adding a "less than" number validation for the order quantity question.
When an order is below your minimum, your customers see your error message on the form.
The Bakery order form with an Order Quantity of 4 and the error Minimum order quantity is 6

Summary

If small orders are not worth your time, a Google Form cannot count the items and stop them. With Neartail, the QUANTITY function counts the order quantity and the validation you add enforces the minimum. Create your order form and complete the steps above. If you have any questions, write to support.

Last updated: