Formfacade

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

Email notification

Email Google Forms response to your users & co-workers

All products

Enhance Google Forms into CRM

Formesign

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

All products

Add legal & HIPAA compliance to Google Forms

Neartail

Meal Prep Software

Meal prep software for weekly changing menu

Online Canteen

Take canteen orders for weekly changing menu

Order form

Calculate order amount in Google Forms

WhatsApp form

Take online orders from your WhatsApp contacts

Payment form

Accept payment in Google Forms

Website builder

Create website with community features

All products

Take food orders for frequently changing menu

Promptrepo

Autofill form

Transform emails into Google Forms responses using AI

Support forum

If your answer turns aggressive, we'll help you tone it down.

Finetuning

Build your own AI model using data in Google Sheets

All products

Extract structured data from customer conversations

How to calculate the end date based on the start date and term duration selected by the user?

You can use the ADD function to dynamically calculate the end date based on start date and duration selected by the user.

You can use the ADD function to dynamically calculate the end date based on start date and duration selected by the user.

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.

Step 1: Add a date question in Google Forms.
Step 2: Click on the Addon icon > Select Formfacade > Select Customize this form > Click on the Proceed button.
In the Formfacade customize interface, click on the ⚙️icon next to the end date question.
Step 3: Field settings screen will be displayed. Select the "Answer" tab and write the formula to add subscription chosen to the start date.

Number answer choices in the subscription question

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.

Step 4: Write the formula in the Calculate option for end date question as shown below.

Text answer choices in the subscription question

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.

Step 5: You can use ADD and IFS function to dynamically calculate the end date as shown below.
Made with formfacade