Chapter 2 · Build your menu

Totals and order summary

Show customers a live order amount and an itemized summary, and check that both are correct.

Quick Answer

How does Neartail calculate the order total?

Order forms include a total calculated with TOTAL(), which adds up price times quantity for every selected product. Forms made from a menu, a website, a description, or a template call it Order Amount, and add an Order Quantity field that counts the items. Imported Google Forms call it Amount Due and have no Order Quantity. A summary block shows each item with its unit price, quantity, and amount, so customers can check their order before they submit.

Forms made from a menu, a website, a description, or a template already have these fields, in an Order Summary section and a Review and place your order section. Imported Google Forms are a little different. See Imported forms. Either way, you usually only need to check that they work.

Two bowls at $8 and one small soup at $4 make 1 a $20 Order Amount.

The fields your form uses

FieldCalculationShows
Order Amount (Amount Due on imported forms)TOTAL()The price of everything selected
Order Quantity (not on imported forms)QUANTITY()The number of units selected
Review blockBILL()A table of item, unit price, quantity, and amount

Customers can't change these fields, because Neartail calculates them.

Order Quantity adds different units together

One bowl and 0.5 kg of salad give an Order Quantity of 1.5. That's fine for a form with one kind of unit, but it can mislead on a mixed menu. To see how much of each product to make, use Sales by product.

Imported forms

When you import a Google Form, Neartail adds:

  • A total called Amount Due, calculated with TOTAL(), after your products.
  • A Contact details page with Name and Phone.
  • A Review and place your order page with the itemized bill.

There's no Order Quantity question. Guides that use Order Quantity, such as a fee per item, work the same with Amount Due where they need the total. If you need the number of items, add the question yourself:

Add a field after Amount Due

Open the dropdown beside Add price field and choose Add field. Name it Order Quantity.

Make it calculate

Open its gear, go to the Answer tab, and type QUANTITY() in Calculate. Choose Save.

Place a test order

Check the count against what you selected.

If your form has no total at all, open the dropdown beside Add field and choose Add price field, then Standard calculation using TOTAL(). For prices written in the text of a Google Form, pass the currency symbol so Neartail can find them: TOTAL("$"). See Functions.

Add the summary

In a section's description, type ${BILL()} where you want the table. It appears on the customer form once they select something, and shows Your cart is empty until then.

Select Configure under the block to adjust it.

Test before you share

Try each of these on the live form, not in the editor:

TestExpect
No products selected$0.00 and an empty cart
Two of one productTwice the price
Each variantThat variant's own price
A weight, such as 0.5 kgHalf the per-kg price
Remove an itemThe total drops

After submitting, check that the same amount appears on the order in your Orders board.

If a total looks wrong, see Troubleshooting.

Next steps