Prefill current date in Google Form with Google Apps Script

Question

I have a Google Form to a spreadsheet and I need a date field pre-filled with the current date.

Something like an "onOpen trigger", which updates the date field or a date field with now().

Is this possible in Google Apps Script?

Answer 1

In your case, some of the points of using the Form remain unclear. Suppose that you have the ability to edit a link to the Form or your users agree to add the bookmarklet to their browser.

Common code

let id='1FAIpQLScx-1H1moCzBfkTEOZnVgBScbJeHZ4YE5E6IY2mNZvMuVcOXA';
window.open(
  `https://docs.google.com/forms/d/e/${id}/viewform?usp=pp_url&entry.1000000=`+
  (new Date()).toISOString().split('T')[0]
);

Bookmarklet

Just add the next string to the bookmarks bar

javascript:let id = '1FAIpQLScx-1H1moCzBfkTEOZnVgBScbJeHZ4YE5E6IY2mNZvMuVcOXA'; window.open(`https://docs.google.com/forms/d/e/${id}/viewform?usp=pp_url&entry.1000000=` + (new Date()).toISOString().split('T')[0]);