Total amount, order quantity & order summary

Frequently asked questions from our users

How to automatically calculate the total amount in your order form?

You can use the TOTAL function to calculate the total amount for the products ordered by the user and display it in the form in real-time.

Read the full article →

How to calculate sales tax and add it to the total amount?

You can add a short answer question in Google Forms and then write the formula in Formfacade to automatically calculate the taxes based on order amount.

Read the full article →

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

You can add a number response validation for the total amount Short Answer question in Google Forms to enforce a minimum or maximum order amount.

Read the full article →

How to calculate the total quantity ordered by the users?

You can use the QUANTITY function to calculate the order quantity for the products selected by the user. This will allow you to offer discounts, calculate shipping fees etc based on order quantity.

Read the full article →

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

You can add a number response validation for the order quantity question in Google Forms to enforce a minimum or maximum order quantity.

Read the full article →

How to show a summary of the products ordered by the user?

You can use the SUMMARY function to show the list of products selected by the user so that they can review it before placing their order. If you want to record this order summary in Google Forms, you can use the TEXTSUMMARY function.

Read the full article →

How to show an order summary including the customer details?

You can use the ${SUMMARY(true, true)} formula to show the complete order details filled by the user. This is very useful if you want the users to review their contact and delivery details or if your order form offers customizable products.

Read the full article →

How to show the bill in your order forms?

You can use the BILL function to show the list of products selected by the user along with its price and amount so that they can review it before placing their order. If you want to record this bill in Google Forms, you can use the TEXTBILL function.

Read the full article →

How to generate an order number or unique id for each response?

You can use the SEQUENCE() function to generate an order number that is auto incremented by 1 or concatenate it with a text to generate a unique order id.

Read the full article →