How to show a summary of the products ordered by the user?
"How to make my customer review their orders before submit their form?"- Google Docs Editors Community
On a long Google Form, especially one split over pages, customers lose track of what they've picked. Google Forms has no review step, so they submit without seeing their order in one place and mistakes reach you afterwards. 80 people on Google's forum have asked how to let customers review their order first. Neartail's review page shows it back to them: the SUMMARY function lists the products they picked with the quantity of each, so they can check before they place the order. TEXTSUMMARY saves the same list in the response, so you read the whole order in one place.
How to show a summary of the products ordered by the user?
On the page that opens, paste your Google Form's link or click Browse to pick it, then click Import.
Select your currency and click Continue.
When it says "Your order form is ready", Neartail has made a product from each question with a price and added an order total and summary. If it says no products were found, add a price to any question.
Click Preview your form. Then, under Manage, click Edit form to open the form builder.
Your form already has a section that shows the bill, called Review and place order in the pictures. Click on the section, then click the ⚙️ icon.
Use SUMMARY function to show the list of products ordered by the user
You can use the SUMMARY function to show the order summary to the users. The syntax for the SUMMARY function is:
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.
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 ${ ... }
If the currency used in the form is $, then the summary formula would be ${SUMMARY("$")}
If the currency used in the form is €, then the summary formula would be ${SUMMARY("€")}
If the currency used in the form is ₹, then the summary formula would be ${SUMMARY("₹")}
Similarly, you can write the summary formula for any currency.
In Edit Page, the description has the ${BILL()} formula. Replace it with the ${SUMMARY("$")} formula as shown below and click Save. Use the currency symbol your prices have, such as ${SUMMARY("€")}.
Your customers see the products they picked, with the quantity of each, and can check them before they submit.
How to show an order summary and record it in the responses?
Click on your order total question, then click Add field in the toolbar on the right
Enter Order summary as the new question's title and change the question type to Paragraph in its list
Click the ⚙️ icon
Use TEXTSUMMARY function to show the order summary and also record it in the responses
You can use the TEXTSUMMARY function to show the order summary. Unlike the SUMMARY function, this returns the summary as text. The syntax for the TEXTSUMMARY function is:
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.
If the currency used in the form is $, then the summary formula would be TEXTSUMMARY("$")
If the currency used in the form is €, then the summary formula would be TEXTSUMMARY("€")
If the currency used in the form is ₹, then the summary formula would be TEXTSUMMARY("₹")
Similarly, you can write the summary formula for any currency.
In Field settings, select the Answer tab. Write the TEXTSUMMARY function in the Calculate option as shown below and click Save. Use the currency symbol your prices have
Your customers see the summary on the form, and it is saved with their order when they submit.
Summary
Google Forms doesn't show customers what they've picked before they submit. With Neartail, the SUMMARY function lists their products on the review page, and TEXTSUMMARY saves the same list with the order. Import your Google Form and complete the steps above. If you have any questions, write to support.
Let customers review their order on your form.
Import your Google Form and replace BILL() with SUMMARY() on its review page, so customers see each product and quantity they picked before they submit.