To reward bigger orders, the discount has to depend on the order, and a Google Form never adds the order up. Ten percent off once someone buys ten items, or 20% off above $100, means checking each response yourself, working out the discount and telling the customer the new amount after they've submitted. Neartail puts the order amount and quantity on your Google Form, so a Discount field can follow your rule with the IFS function. When an order reaches your amount or quantity, the customer sees the discount come off before they submit, and the order reaches you with it taken off.
Let's start. Import your Google Form and follow the steps below.
Give bigger orders a discount on your order form.
Import your Google Form and add a Discount price field with an IFS formula, so the discount comes off once an order reaches your amount or quantity.