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
483 views
in Technique[技术] by (71.8m points)

google apps script - How can I be getting multiple unwanted event blocks from the same onFormSubmit Trigger?

I created a one question form this morning because I wanted to look at the event block for myself. However, the process took an unexpected turn for me. My description follows:

I'm logging the onFormSubmit event with the following code:

function testFormSubmission(e) {
  var lock=LockService.getUserLock();
  try{
      if(lock.tryLock(30000)) {
      var ss=SpreadsheetApp.getActive();
      var sh=ss.getSheetByName('LogSheet');
      var tA=[Utilities.formatDate(new Date(), Session.getScriptTimeZone(),"d/M/yyyy HH:mm:ss")];
      tA=tA.concat(e.values);
      tA.splice(tA.length-1,1,e.triggerUid,e.range.rowStart,e.range.columnEnd,JSON.stringify(e.values));
      sh.appendRow(tA);
      lock.releaseLock();
    }
  }
  catch (e){throw("Couldn't get lock for 30 seconds");return;};
}    

I have two images of my spreadsheet below:

There's actually only two columns in e.values one is the date and one is the answer to the question which is either "green" or "blue". The blank columns come from the fact that I started with three questions and collecting emails but decided to remove two of them for simplicity, since I'm generating the submissions myself.

Anyway the responses that don't have either Green or Blue in columnC just shouldn't be there. Column J is simply JSON.stringify(e.values) and it seems to suggest that e has incorrect values in it...I think? Yes/No

Here's an image of the Spreadsheet. (some of it)

This is the Form Responses 1 Sheet:

enter image description here

This is the LogSheet:

enter image description here

So my question is simply where are the unwanted appended lines in the Log Sheet coming from?

I updated my title question because I don't think I'm getting multiple submissions otherwise I'd expect to have multiple lines in Form Responses 1 sheet.

For your information columnH in LogSheet is rowStart so it's easy to figure out what row in Form Response 1 correlates.

Question&Answers:os

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

1 Answer

0 votes
by (71.8m points)

Getting spurious onFormSubmit Triggers

As @J.G. pointed out I was getting more that one trigger from each submission of the form.

I noticed by logging the e.values into a spreadsheet that I was not getting any of the answers. So to eliminate these unwanted triggers I just used the following logic.

if(e.values && !e.values[1]){return;} where e.values[1] was a required question.

My log:

enter image description here

The lines with no value in column C are unwanted triggers.


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

...