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.

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?

Step 1: Click on Add title and description TT option in Google Forms and add the title as shown below.
Step 2: Click on the Addon icon > Select Neartail > Select Customize this form > Click on the Proceed button.
In the Neartail customize interface, click on the ⚙️icon next to the empty description.

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.

Step 3: Enter the ${BILL("$")} formula in the description as shown below.
The list of products ordered by the user along with is price and description will be displayed as shown below. This will enable users to review their order before submitting it for processing.

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.

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 show the bill and record it in Google Forms?

Step 1: Add a paragraph question for order summary in Google Forms.
Step 2: Click on the Addon icon > Select Neartail > Select Customize this form > Click on the Proceed button.
In the Neartail customize interface, click on the ⚙️icon next to the paragraph question for order summary.
Step 3: Field settings screen will be displayed. Select the "Answer" tab and write the formula to show the order summary.

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.

Step 4: Write the TEXTBILL function in the Calculate option as shown below.
The list of products ordered by the user along with its price and amount will be displayed as shown below. This bill will also be recorded in Google Forms when users submit the form.
Made with formfacade