Order form
Take food orders using Google Forms
WhatsApp form
Take online orders from your WhatsApp contacts
Payment form
Registrations, memberships, & bookings using Google Forms
Website builder
Create website with community features
Order form addon
Calculate order amount in Google Forms
Payment form 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
Calculate score
Assign different points for each answer & calculate score
Upload file
Upload files in Google Forms without login
Email notification
Email Google Forms response to your users & co-workers
Enhance Google Forms into CRM
eSignature
Accept legally binding signature in Google Forms
HIPAA form
Mask PHI fields in email & prefill links
Intake form
Create intake forms that accepts eSignature from patients
Prefill form
Prefill Google Forms & send as email to customers
Fillable PDF
Generate customized PDF from Google Forms responses
Signature workflow
Collect multiple signatures in Google Forms
Add legal & HIPAA compliance to Google Forms
Add a short answer question with number response validation in Google Forms and then add the formula in Formfacade to calculate the amount after discount. Please follow the instructions below.
IFS function evaluates multiple conditions and returns a value that corresponds to the first true condition. The syntax for the IFS function is: IFS(condition1, value1, [condition2, value2, …]) where
If the coupon code is WELCOME20, we will apply a 20% discount by multiplying the total amount by 0.80. Otherwise, zero discount i.e. amount to be paid is the total amount for the products ordered. IFS(Apply Coupon == "WELCOME20", 0.80 * Total Amount, Total Amount)
CURRENCY function displays the number in currency format. The syntax for the currency function is: CURRENCY(symbol, number) where
We will use the currency function to format the calculated total amount and display it as a currency. CURRENCY("$", IFS(Apply Coupon == "WELCOME20", 0.80 * Total Amount, Total Amount))
Instead of applying a percentage discount for the coupon code, you can offer a fixed dollar amount discounts. Let's say you want to offer a $5 discount for WELCOME20 coupon code. So, if the coupon code entered by the user is WELCOME20, we will simply subtract 5 from Total amount. CURRENCY("$", IFS(Apply Coupon == "WELCOME20", Total Amount-5, Total Amount))
Click Submit to finish.