How to show the bill in your order forms?

You can use the BILL function to show the list of products selected by the user along with its price and amount so that they can review it before placing their order. If you want to record this bill in Google Forms, you can use the TEXTBILL function.

How to display the bill in your order form?

BILL function

You can use the BILL function to show the list of products ordered by the users along with its price and amount. The syntax for the BILL function is:

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.

Note: The bill 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 ${ ... }

If the currency used in the form is $, then the summary formula would be ${BILL("$")}
If the currency used in the form is €, then the summary formula would be ${BILL("€")}
If the currency used in the form is ₹, then the summary formula would be ${BILL("₹")}
Similarly, you can write the summary formula for any currency.

How to show the order amount, delivery fee and total amount in the bill?

If you have order amount, delivery fee and total amount fields in your order form, then you can display it in the bill by adding the entry #ids for the order amount, delivery fee and total amount field in the BILL function as show below.

How to show the bill and record it in Google Forms?

Use TEXTBILL function to show the bill and also record it in Google Forms

You can use the TEXTBILL function to show the order summary. Unlike the BILL function, this returns the summary as text. The syntax for the TEXTBILL function is:

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.

If the currency used in the form is $, then the summary formula would be TEXTBILL("$")
If the currency used in the form is €, then the summary formula would be TEXTBILL("€")
If the currency used in the form is ₹, then the summary formula would be TEXTBILL("₹")
Similarly, you can write the summary formula for any currency.