Order Form & Payment Page Builder (Auto Totals, UPI QR)

About the Order Form & Payment Page Builder (Auto Totals, UPI QR)

Build order, quote, fee, donation and registration forms whose totals work themselves out: products with quantities, line items, choices and add-ons with prices, amounts people type, delivery charges, discount codes, tax added or included, and your own formulas (a rush fee of 30%, a bulk discount, nights × rooms). Add a signature (drawn or typed), file uploads, an order bump on a single-product checkout and a one-time offer on the thank-you page — and try every part of it right here, as a buyer would.

When an order is placed, the buyer sees the exact amount as your UPI QR code and payment link (with the order number in the note), a PayPal.me link with the amount, or your own payment link, and can send the payment reference afterwards. The order, with a number taken in turn so no two orders get the same one, goes to your own spreadsheet; signatures and uploads to your own drive; you and the buyer get an e-mail. The script in your own account works every total out again instead of trusting the page.

MySmartCoPilot hosts nothing of your form, never sees an order and never touches money. Without a pass you can build and test everything, and the files show their first lines; a Premium pass gives the whole form, page, script and guide to copy or download.

Common uses

• A bakery, caterer or home kitchen taking orders with a delivery date and delivery or pickup.
• A coach or creator selling one course or product with an order bump and an upsell.
• A tuition centre, school or club collecting fees, or an organiser selling event tickets.
• A designer, contractor or agency giving an instant estimate that the client signs.
• A charity or temple collecting donations by UPI with quick amounts.

How the totals are worked out

Every price is kept in whole paise or cents. The lines come first (products × quantity, choices, add-ons, line items, number × price, typed amounts, the order bump and the one-time offer), then your formulas in order, then the discount code on that total, then delivery, then tax: added on top, or included in the prices and shown as “Includes GST 18%”. Tax is worked out once on the taxable total after the discount, rounded half away from zero. The same engine runs in the live preview, on your page and in your script, and the script recomputes the total from the answers, so a changed page can never lower a price.

Your own formulas

A formula uses numbers, + − × ÷ % ^, comparisons, and/or/not, the functions min, max, round, floor, ceil, abs, if and clamp, the names of your priced fields (a product is its quantity, a choice its price, a date its day number, so checkout - checkin gives the nights — write max(0, checkout - checkin), so dates picked the wrong way round never take money off), subtotal, quantity and earlier formulas. It is read by a small parser into steps and worked out step by step — never run as code — so a formula cannot do anything but give a number. Dividing by zero gives 0, and a mistake is named with where it is before any file is made.

Payments go straight to you

The payment step shows the amount due as your UPI QR code and a link that opens the buyer’s UPI app (the UPI ID, your payee name, the amount and the note with the order number: UPI payment parameters), a PayPal.me link with the amount and the currency (PayPal.me links) or your own payment link. The buyer pays you directly; afterwards they can send the transaction ID or UTR number, which goes into the order’s row. Check it against your bank statement before you treat an order as paid — the UPI Payment Reconciliation tool matches a statement to your orders.

Order numbers, codes and e-mails in your own account

Your script takes each order under the script lock (Lock Service), so order numbers never repeat and a code with a use limit cannot be used once too often. Discount codes are not written in your page: it keeps only a fingerprint of each, and the script checks every code again. The e-mail to the buyer holds only your own wording, the products and the amounts — never what the buyer typed — and goes to one address at most three times in six hours, so nobody can use your form to send messages from your account. Your account’s own limits apply (quotas): 100 e-mail recipients a day on a personal account, 1,500 on a business account, and each order sends up to two.

Your buyers’ data

Names, contact details, answers, signatures and uploads go from the buyer’s browser straight to your own spreadsheet and drive; MySmartCoPilot never receives them. You are responsible for them: say on your form why you collect them and how long you keep them, ask only for what you need, and delete old orders when you no longer need them.

Limitations

• It takes orders and shows how to pay; it does not take card payments or confirm that a payment arrived — the buyer’s reference and your bank statement do that.
• UPI is for rupees only. If the UPI link does not open the buyer’s app on their phone, the QR code and your UPI ID beside it still work.
• Uploads and signatures of one order are kept to 10 MB in all, because they travel to your script in one message.
• The payment reference and the one-time offer can be sent from the order page for six hours after the order.
• The first order after a quiet spell can take a few seconds while your script starts.

Privacy

The set-up is kept in this browser (and in settings files you save yourself) and is never uploaded. Test orders in the live preview exist only in this page. On your own site, orders go from your buyers straight to your own spreadsheet.