Skip to content Skip to sidebar Skip to footer

How To OnFormSubmit(), Two Separate Google Source Spreadsheets?

I have two google separate forms that submit new client data to two separate spreadsheets. How would I use the onFormSubmit() on two separate spreadsheet sources in one app script

Solution 1:

function onFormSubmit(e) { 
  var formObj={LinkedSheet1:FormName1,LinkedSheet2:FormName2};//you provide this from a knowledge of the connection between the form and linked sheet 
  var form=formObj[e.range.getSheet().getName()];//this returns the form for each sheet
  switch (form) {
    case 'FormName1':
      //code for FormName1
      break;
    case 'FormName2':
      //code for FormName2
      break;
  }
}

onFormSubmit Event Object


Post a Comment for "How To OnFormSubmit(), Two Separate Google Source Spreadsheets?"