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 CRM
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
Prefill Google Forms & send as email to customers
Formfillable
Generate customized documents from Google Forms responses
Mailrecipe
Signature workflow for Google Forms
Make your Google Forms compliant
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 with community features
Google Forms Addon
Calculate order amount in Google Forms
Peergateway Addon
Accept payment in Google Forms
Take online orders using Google Forms
Let's create a form to capture the goals and objectives for next week. Instead of asking the users to enter the week start date and week end date, we will automatically upload the start and end dates for next week. In this example, the week starts on a Sunday and ends on a Saturday. Please follow the instructions below to add the date calculations for automatically updating the dates.
We can use the getDay() function to determine the day of the week and use the ADD function to calculate the next week start date as shown below.TODAY().add(7-TODAY().getDay(),"days")
You can calculate the week end date by adding 6 days to the week start date. We will use the ADD function as detailed below.weel_start_date.add(6, "days")Note: To enter week_start_date, type @ in the calculate option and select the week start date from date question from the list.
Click Submit to finish.