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
Let's say the fixed shipping fee per item is $2. We can write a simple calculation to multiply the order quantity by 2 to calculate the total shipping fee. We can use the CURRENCY function to display the calculated value as a currency. CURRENCY("$", Order quantity * 2)
Example #1: Let's say the shipping fee for the first item is $10 and for each additional item, the shipping fee is $5. If a user orders 3 items, the shipping fee would be $10 for the first item and $5 for the other two items. The total shipping fee would be $20. Formula to calculate the total shipping fee: CURRENCY("$", 10 + (Order quantity - 1) * 5) Example #2: Let's say the shipping fee per item is $2 and you get a discounted shipping fee of $15 for a pack of 10 items. If a user orders 22 items, the shipping fee would $30 for 20 items plus and additional $4 for 2 individual items. Formula to calculate the total shipping fee: CURRENCY("$", Math.floor(Order quantity / 10) * 15 + (Order quantity % 10) * 2) Math.floor function returns the largest integer less than or equal to a given number. For example Math.floor(22/10) will return 2. We can use this function to find the number of 10 packs in the order quantity. The remainder operator % returns the integer left over after dividing one number by another. For example, 10 % 3 will return 1. 22 % 10 will return 2.
Click Submit to finish.