A Google Form has no formulas. Everything an order needs worked out, the total, the number of items, a delivery fee, a summary for the customer to check, has to happen after the response arrives. Neartail adds functions to your Google Form that do those sums while the customer fills it in, and shows the result on the form. TOTAL and QUANTITY are already on every new order form. The rest, from BILL and SUMMARY to FEE and IFS, go in where you need them. Here is each one with its syntax and an example.
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)
A Google Form can't calculate anything for an order. With Neartail, these functions work out the total, the quantity and the fees, and show a summary or a bill while your customers order.
Create your order form and try them. If you have any questions,
write to support.