Date of data entry to Google Sheets

Hi, Can you tell me how I would add the date that a row was entered from Articulate to Google Sheets?


August 23, 2021, 3:20 am

Click for thumbs down.0Click for thumbs up.0#1

At the time you are saving the rest of the data, you can save the date in a separate column. If you are not sure how to get the current date with JavaScript, you can reference online resources on JavaScript. Here's one example:

If you use this approach, your trigger will look something like this:

var today = new Date();
var dd = String(today.getDate()).padStart(2, '0');
var mm = String(today.getMonth() + 1).padStart(2, '0'); //January is 0!
var yyyy = today.getFullYear();
today = mm + '/' + dd + '/' + yyyy;

August 25, 2021, 6:10 pm

Click for thumbs down.0Click for thumbs up.0#2