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
All products
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
Show consent screen while submitting Google Forms
Mailrecipe
Signature workflow for Google Forms
Make your Google Forms compliant
Form builder
Take online orders from your Instagram & Facebook fans
WhatsTarget
Take online orders from your WhatsApp contacts
Peergateway
Create registration, membership form for Schools & Sports clubs
Site builder
Create website for new users to learn about your brand
Google Forms Addon
Take online orders using Google Forms
Peergateway Addon
Accept payment in Google Forms
Take online orders from your social media fans
Calculated fields allow you to compute a field with values from other fields. Calculated fields can perform arithmetic on number fields, manipulate text & date. For example, you can calculate the total amount in order form based on the order quantity and shipping option chosen by the user.
We have simplified the calculations for standard use cases such as calculating total amount and displaying order summary in order forms, calculating scores and providing verbal assessments for surveys and questionnaires. Order forms
Let's create a simple order form and learn how to add a calculated field to compute and display the order amount to the user filling the form. Users can order one or more bottles of perfume using the order form. The standard price is $60, but if they order 10 or more bottles of the perfume, the price per bottle is $50. There is a standard shipping fees of $25, but this fees is waived off for orders above $150.Calculations to be added in the order form:Product price = $60 for < 10 bottles of perfume; $50 for >=10 bottles of perfumeOrder amount = Quantity * PriceShipping fees = $0 for order amount > 150; $25 for order amount =< 150Total amount = Order amount + Shipping fees
Google Forms does not support dynamic calculations, but you can use Formfacade's calculate field option to automatically compute and display the data in real-time to the user filling the form. Open your Google Forms > Click on the addon icon > Select Formfacade > Select Customize this form > Click on the Proceed button to open the Formfacade customize interface.
We have to add the order amount and shipping fees to calculate the total amount. It's a simple addition.Order amount + Shipping feesIn the Formfacade customize interface, click on the gear icon next to the Total amount field. Field settings screen will be displayed. Select the Answer tab and write the above formula in the Calculate option.To use a form field in the calculation, type @ and you will see the list of all the fields in the form. Select the required form field to add the field. You will see the display name of the field, but internally it uses the entry id for the calculations.
The standard shipping fee is $25, but this fees is waived off for orders above $150. To implement this calculation, we have to check if the order amount is greater than 150. You can use the IFS function to write conditional logic. 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
The formula to calculate the shipping fees is: IFS(Order Amount > 150, 0, 25) In the Formfacade customize interface, click on the gear icon next to the Shipping fees field. Field settings screen will be displayed. Select the Answer tab and write the above IFS formula in the Calculate option. Note: To use a form field in the calculation, type @ and you will see the list of all the fields in the form. Select the required form field to add the field. You will see the display name of the field, but internally it uses the entry id for the calculations.
Order amount = Quantity * Price Quantity is entered by the user. Based on this quantity entered, we have to calculate the price. The standard price is $60, but if a user orders 10 or more bottles of the perfume, the price per bottle is $50. We can use the IFS function to determine price and then multiply it with quantity to calculate the order amount. IFS(Quantity >=10 , 50, 60) * Quantity In the Formfacade customize interface, click on the gear icon next to the Order amount field. Field settings screen will be displayed. Select the Answer tab and write the above formula in the Calculate option. Note: To use a form field in the calculation, type @ and you will see the list of all the fields in the form. Select the required form field to add the field. You will see the display name of the field, but internally it uses the entry id for the calculations.
You can test this order form using the link below. https://bit.ly/formfacade
Click Submit to finish.
To use this feature, you need our Gsuite addon. Install this addon to customize Google Forms.