AnsweredAssumed Answered

Survey123 - Pre-populate date based on another date

Question asked by jadavis101699 on Feb 27, 2020
Latest reply on Feb 28, 2020 by jadavis101699

Hello,

 

I've created a form using Survey123 Connect that features a date entry (as type) with a default of today()...for example it would populate the form with Thursday, February 27, 2020.  Today's date.

As an fyi...I added a new row just below this one (text as type) to reformat this date...for example the new date format is illustrated as 02/27/2020.  In using Google Sheets in tandem with Integromat it is necessary that the date be represented as such or you get a very strange entry.  Anyway...

 

Further down in my sheet I have another date entry.  I would like to take today's date and automatically populate this entry with a date 1 year out from today.

The auto-populate entry for that date would then read 02/27/2021.

 

Can this be done?

Thanks.

Jeff

Outcomes