CODEWITHSUNDEEP
formsgoogle-apps-scriptgoogle-forms
Steve_12345
Steve_12345

Reputation: 111

Prefill current date in Google Form with Google Apps Script

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?

Upvotes: 9

Views: 5836

Answers (2)

barryku
barryku

Reputation: 2584

I put a static HTML page on S3 with a few line of Javascript for redirecting. See https://jsfiddle.net/barryku/3etd8qf0/

var formId = "1FAIpQLSc_acGSzp2VeJIyG0tNJwqcNdUPOweLROGenY0Fe56I635VGQ";
var dateField = "entry.1608430301";
var formsUrl = "https://docs.google.com/forms/d/e/"+ formId + "/viewform?usp=pp_url&" + dateField + "=$$today&entry.747437339=Yes";

var today = new Date();
var redirectUrl = formsUrl.replace("$$today", new Date(today.getTime() - (today.getTimezoneOffset() * 60000)).toISOString().split('T')[0]);
window.location.replace(redirectUrl);

Upvotes: 1

oshliaer
oshliaer

Reputation: 4979

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]);

Upvotes: 3

Related Questions