title: Triggering Script in google Sheets after Forms Submit
body: <p>I have a working script in one of my google sheets projects, but now I want it to be triggered when I hit the submit button on a Google Form I have. Basically, the data from my Google Form gets exported to my Sheets form, but then I have a script to analyze the data entered. For some reason, it seems like it's doing nothing when the onSubmitForm() function is triggered. It's clear there's a problem because my logger test line displays for the onSubmitForm function but not for the EvaluateResults function.</p>
  
  <p>The code in my Google Form is simple:</p>
  
  <pre><code>function onSubmitForm(){
     Logger.log("onSubmitForm Running");
     a.EvaluateResults();
  }
  </code></pre>
  
  <p>The code in the Google Sheets is simple as well:</p>
  
  <pre><code>function EvaluateResults(){
    Logger.log("evaluation running");
    var ss = SpreadsheetApp.getActiveSpreadsheet();
    var sheet_results = ss.getSheetByName("Sheet2");
    var sheet_userForm = ss.getSheetByName("Form Responses 1");
  
    sheet_results.getRange("C24").setValue((sheet_userForm.getRange("A2").getValue());
  }
  </code></pre>