Coupons and automatic discounts

Choose a discount rule that matches your offer: a coupon entered by the customer, an automatic amount or quantity threshold, or a tiered rate.

Define the offer

Record the rule before editing the form. For example: “Orders of $100 or more receive 15% off products; delivery is charged separately.” Decide what happens at the threshold and which products count.

Use a distinct field for the discount amount when you need to show the customer how the final amount was calculated.

Coupon-based discounts

Add a short-answer question for the code. In a Google Forms-based setup, response validation can restrict the valid codes. Then use a calculation in Neartail to apply the discount associated with the entered code.

A code being accepted by validation does not itself subtract money. The final amount must use the discount calculation.

Use the official coupon setup guide for the Google Forms validation route.

Automatic and tiered discounts

IFS chooses the result for the first matching condition. For example, this discount calculation uses the higher threshold first:

IFS(TOTAL() >= 100, TOTAL() * 0.15, TOTAL() >= 50, TOTAL() * 0.05, 0)

The expression returns the discount amount, not the final amount due. Subtract that result once in your final calculation. This rule is a fictional offer, not a Neartail default.

The tiered discount guide documents the IFS approach.

Protect your intended pricing

If premium products should not count toward a meal-plan offer, keep the eligible base explicit. Use categories or an appropriate calculation rather than applying a percentage to every product unintentionally.

Check boundaries

Preview just below, exactly at, and above each threshold. Check a valid code, an invalid code, no code, and an order with only an excluded product. Confirm delivery and tax use the intended base after discount.

Continue with totals to keep the displayed summary and final amount consistent.