Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
846 views
in Technique[技术] by (71.8m points)

debugging - Event object of onSubmit is empty in Google script

I have a Google form linked to a Google sheet. In that spreadsheet I have code that have this

function onSubmit(e){
  Logger.log(e)    
  Logger.log("Call onSubmit")
}

The trigger is setup as follow

Project: Spreadsheet's scritp 
Deployment:Head 
Event:From spreadsheet - On form submit 
Function:onSubmit

So whenever I submit the form, the log shows

[object Object]
Call onSubmit

The form has many questions, not an empty form. As I read the documentation, it seems like the event object has many information. Is there something wrong with my setup? I have resorted to read responses in the data sheets but that's not ideal. Too many things have to call and/or defined manually.

See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)

Unlike most browser debuggers, the Google apps script logger will only store basic string values. In most cases, this means that the documentation will be more useful for understanding complex values. In your case, the event object for submit events is quite simple, with a values key for a simple array and a namedValues key for an object lookup of what was submitted.


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...