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
Let's take the example of a subscription form. The users select the start date and their preferred subscription term, and the form should automatically display the end date based on this selection. We will use the ADD function to dynamically add the months from the subscription question to the start date entered by the user and calculate the end date.
The subscription is a dropdown question with three number answer choices: 3, 6 and 12. We can use this directly to add the months to the start date and calculate the end date.You can add months to a date by specifying "months" as the term in the ADD function.Syntax: start_date.add(number_of_months, "months") Note: To enter start_date and number_of_months, type @ in the calculate option and select the start date and subscription question from the list.
If you want to use text answer choices such as 3 months, 6 months and 1 year for the subscription dropdown question, you will have to use the IFS function to assign the numerical values for each of the the text answer choices. For example:start_date.add(IFS(subscription == "3 months", 3, subscription == "6 months", 6, subscription == "1 year", 12, 1),"months")Note: To enter start_date and subscription, type @ in the calculate option and select the start date and subscription question from the list.
Click Submit to finish.
To use this feature, you need our Gsuite addon. Install this addon to customize Google Forms.