Formfacade

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

Formesign

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

All products

Make your Google Forms compliant

Neartail

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

How to add a simple calculated field to a google form?

Add a short answer question in your Google Form and use our add-on to write the expression to dynamically calculate the value for this short answer question.

Add a short answer question in your Google Form and use our add-on to write the expression to dynamically calculate the value for this short answer question.

Google Forms does not support dynamic calculations, but you can use Formfacade for calculating and displaying calculated values in your form. For example, you can calculate the total amount in order form based on the price and order quantity entered by the user.

How to show dynamic text using form data?

Step 1: Open your Google Form > Click on "Add-on" menu > Select "Formfacade" > Formfacade popup menu will be shown. Select "More options" > Click on the "Customize" button.
Step 2: Formfacade customize admin interface will open in a new tab. Click on the gear icon next to the desired field label (question) to open field settings screen.
Step 3: Select the "Answer" tab and write the text/expression in the "Calculate" option. When you enter @, you will see the list of all the fields in the form. Select the required form field. It will automatically insert the field.

How to do simple calculations using form data?

Let's calculate the total amount by multiplying order quantity & price form fields.

The calculations can only be performed on number fields. Add the "IsNumber" response validation for Short Answer question. Any question with IsNumber field will be automatically treated as number so that you can do calculations on those fields.

Click on the gear icon next to the "Total amount" label. Field settings popup will be displayed. Select "Answer" tab and write the formula Price * Quantity in "Calculate" as shown below.
Dynamically calculate the total amount based on price and quantity form fields and display this in real-time to the user filling the form.
Made with formfacade