Neartail functions

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 functions 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, deliverys 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, delivers 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 choices (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)