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.

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.

How to calculate the order quantity?

Step 1: Add a short answer question with number response validation in Google Forms.
Step 2: Click on the Addon icon > Select Neartail > Select Customize this form > Click on the Proceed button.
In the Neartail customize interface, click on the ⚙️icon next to the short answer question for order quantity.
Step 3: Field settings screen will be displayed. Select the "Answer" tab and write the formula to calculate the order quantity.

Use QUANTITY function to calculate order quantity

You can use the QUANTITY function to calculate the order quantity. The syntax for the QUANTITY function is:

QUANTITY(currency)
where

  • currency - currency symbol or text used to display the price of the products.

For example:

  • If the price format is $50 each, $5.75 per kilo etc, the formula to calculate the order quantity is QUANTITY("$")
  • If the price format is €50 each, €5.75 per kilo etc, the formula to calculate the order quantity is QUANTITY("€")
Step 4: Write the formula  QUANTITY("$") in the Calculate option as shown below.

Baker's dozen: How to offer a free cookie for every dozen?

Step 1: Add a short answer question with number response validation in Google Forms.
Step 2: Click on the Addon icon > Select Neartail > Select Customize this form > Click on the Proceed button. In the Neartail customize interface, click on the ⚙️icon next to the short answer question for baker's dozen (free cookies).
Step 3: Field settings screen will be displayed. Select the "Answer" tab and write the formula to calculate the number of free cookies based on order quantity.

Use Math.floor to calculate the number of dozens

Math.floor function returns the largest integer less than or equal to a given number. The syntax for Math.floor function is:

Math.floor(number)
where

  • number - This could be a number or a calculation that returns a number.

Baker's dozen is 13. To offer a free cookie for every dozen that a user orders, we can calculate the number of dozens by dividing the order quantity by 12. Since we only need a round number, we can use the Math.floor function to calculate the exact number of free cookies.

Math.floor( Order quantity / 12 )

Step 4: Write the formula in the Calculate option as shown below.