TOTAL function can be used to calculate the order amount for the products selected by the user. Syntax: TOTAL(currency) where
Example usage: TOTAL("$") TOTAL("€") TOTAL("EUR") TOTAL("INR")
QUANTITY function can be used to calculate the order quantity. Syntax: QUANTITY(currency) where
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
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
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
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
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
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
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
Example usage: IFS(Total > 500, 0, 25)
Click Submit to finish.
To use this feature, you need our Gsuite addon. Install this addon to customize Google Forms.
Try It Free