I have a hidden date picker (ID: todaysDate) on my form so that when a user clicks the submit button (btnSaveForm), their form information along with today’s date is parsed into a Google Sheet. However, the formatting is off when it gets to the sheet, it looks like this “2019-09-16T04:00:00.000Z” - How would you recommend setting this up so that I get a simple mm/dd/yyyy into my Google Sheet? Would it be something like this:
export function todaysDate_onLoad(event) {
//Code that I'm not sure of
}