Form builder
Take food orders using Google Forms
WhatsTarget
Take online orders from your WhatsApp contacts
Peergateway
Registrations, memberships, & bookings using Google Forms
Site builder
Create website for your Google Forms
Google Forms Addon
Calculate order amount in Google Forms
Peergateway Addon
Accept payment in Google Forms
All products
Take online orders using Google Forms
Embed in website
Embed Google Forms in your website
Customize UI
Change layout, hide fields & redirect on submit
Scorecery
Assign different points for each answer & calculate score
Petaform
Upload files in Google Forms without login
Personalize Email
Email Google Forms response to your users & co-workers
Enhance Google Forms into customer facing forms
eSignature
Accept eSignature in Google Forms
HIPAA form
Make your Google Forms HIPAA compliant
Intake form
Create intake forms that accepts eSignature from patients
Formprefill
Create prefill links for Google Forms without violating HIPAA
Formfillable
Generate customized documents from Google Forms responses
Mailrecipe
Signature workflow for Google Forms
Make your Google Forms compliant
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
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.
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 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
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.
Click Submit to finish.