This is a common question from small food and retail businesses who want their order form to do the sums. For example, you might want to total an order, show a summary or work out a delivery fee. A Google Form has no way to do it, so you do the sums by hand for each order. With Neartail, built-in functions calculate the total amount, show an order summary, calculate delivery fees and more. Your customers see the result on the form as they order. Even better, your form comes with TOTAL and QUANTITY already in it, so you only write the ones you need. Here's the list of Neartail order form functions.
Let's start. Create your order form and try the functions below.
TOTAL function can be used to calculate the order amount for the products selected by the user.
Syntax:
TOTAL(currency)
where
- currency - identifier to find the price in the description for all question types/answer choices for multiple choice, checkbox and grid questions. It can be a symbol or text, but it has to exactly match the format used in the description/answer choices.
Example usage:
TOTAL("$")
TOTAL("€")
TOTAL("EUR")
TOTAL("INR")
QUANTITY function can be used to calculate the order quantity.
Syntax:
QUANTITY(currency)
where
- currency - currency symbol or text used to display the price of the products.
Example usage
QUANTITY("$")
QUANTITY("€")
QUANTITY("EUR")
QUANTITY("INR")
TEXTSUMMARY function can be used to show an order summary with the list of the products ordered and the respective quantity.
Syntax:
TEXTSUMMARY(currency)
where
- currency - identifier to find the price in the description/answer choices. The currency can be a symbol or text, but it has to exactly match the format used in the description/answer choices.
Example usage:
TEXTSUMMARY("$")
TEXTSUMMARY("€")
TEXTSUMMARY("EUR")
TEXTSUMMARY("INR")
SUMMARY function can be used to show an order summary with the list of the products ordered and the respective quantity. This function returns an html.
Syntax:
SUMMARY(currency)
where
- currency - identifier to find the price in the description/answer choices. The currency can be a symbol or text, but it has to exactly match the format used in the description/answer choices.
Example usage:
SUMMARY("$")
SUMMARY("€")
SUMMARY("EUR")
SUMMARY("INR")
Note: The summary function returns a html. So it must be used in the description as a string literal. Any function that you write in the description must be written between ${ ... }
TEXTBILL function can be used to show the list of products selected by the user along with its price and amount.
Syntax:
TEXTBILL(currency, [entry###, entry###,…])
where
- currency - identifier to find the price in the description/answer choices. The currency can be a symbol or text, but it has to exactly match the format used in the description/answer choices.
- entry### - Entry #id of the fields such as amount, delivery fees etc to be included in the bill. You can type @ and select the required field to add the entry #ids in the formula. This is an optional parameter.
Example usage:
TEXTBILL("$")
TEXTBILL("€")
TEXTBILL("EUR")
TEXTBILL("INR")
BILL function can be used to show the list of products ordered by the users along with its price and amount. This function returns an html.
Syntax:
BILL(currency, [entry###, entry###,…])
where
- currency - identifier to find the price in the description/answer choices. The currency can be a symbol or text, but it has to exactly match the format used in the description/answer choices.
- entry### - Entry #id of the fields such as amount, delivery fees etc to be included in the bill. You can type @ and select the required field to add the entry #ids in the formula. This is an optional parameter.
Example usage:
BILL("$")
BILL("€")
BILL("EUR")
BILL("INR")
FEE function can be used to assign delivery fees for each answer choice (delivery zones or delivery options) in a multiple choice question.
Syntax:
FEE(currency, question, value1, [value2, …])
where
- currency - The currency symbol to be displayed
- question - The entry#id of the question. Type @ and select the required question from the list.
- value1, value2 … valuen - Fees for the first, second … nth answer choice
Example usage:
FEE("$", entry###, 10, 20, 15, 30, 0)
FEE("€", entry###, 10, 20, 15, 30, 0)
FEE("EUR", entry###, 10, 20, 15, 30, 0)
FEE("INR", entry###, 10, 20, 15, 30, 0)
CURRENCY function can be used to display the number in currency format.
Syntax:
CURRENCY(symbol, input)
where
- symbol - The currency symbol to be displayed
- input - This could be a number or a calculation that returns a number.
Example usage
CURRENCY("$", 10)
CURRENCY("€",4.99)
CURRENCY("EUR",Amount + Shipping)
IFS function evaluates multiple conditions and returns a value that corresponds to the first true condition.
Syntax:
IFS(condition1, value1, [condition2, value2, …])
where
- condition1 - The first condition to be evaluated.
- value1 - The returned value if condition1 is TRUE.
- condition2, value2, … - Additional conditions and values if the first one is evaluated to be false.
Example usage:
IFS(Total > 500, 0, 25)
If you do the sums for each order by hand, a Google Form cannot do them for you. With Neartail, these functions calculate the total, the quantity and the fees and show the bill as your customers order.
Create your order form and try them. If you have any questions,
write to support.