Customize UI
Change layout, hide fields & redirect on submit
Embed in website
Embed Google Forms in your website
Assign points
Assign different points for each answer & calculate score
File upload
Upload files in Google Forms without login
Autofill form
Transform emails into Google Forms responses using AI
Email notification
Email Google Forms response to your users & co-workers
All products
Enhance Google Forms into CRM
eSignature
Collect legally binding signature in Google Forms
Fillable PDF
Generate customized PDF from Google Forms responses
Signature workflow
Collect multiple signatures in Google Forms
Intake form
Create intake forms that accepts eSignature from patients
HIPAA form
Mask PHI fields in email & links for HIPAA compliance
Prefill & email
Prefill Google Forms & send as email to customers
Add legal & HIPAA compliance to Google Forms
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
Sell directly to customers & build your own brand
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.