title: Populate a Google Form responses from a Google Spreadsheet
body: <p>I am trying (and not succeeding at the moment) to populate a Google Form from a Google Spreadsheet using the items that I have picked up from this website and this extremely useful answer provided by Mogsdad <a href="https://stackoverflow.com/questions/20108511/is-it-possible-to-prefill-a-google-form-using-data-from-a-google-spreadsheet?lq=1">here</a>.</p>
  
  <p>Ideally, I'm looking for:</p>
  
  <ol>
  <li><p>The Logger.log (URL) logs URL's for all the data stored in the spreadsheet, is it possible to just log the last entry and use this to generate the URL?</p></li>
  <li><p>Is it then possible for the pre-filled URL to auto submit once populated with the data? I have found this useful article <a href="http://justingale.com/2013/09/03/url-tricks-for-google-forms-pre-populate-and-automatically-submitting-responses/" rel="nofollow noreferrer">here</a> which suggests that this can be done?</p></li>
  <li><p>The data that is stored in the Google Spreadsheet is data captured from another Google Form. This is due to the need of using Excel (lack of Internet connectivity) with a concatenate formula to merge all cells with data into one. This is then submitted on the other Google Form which has <a href="http://www.googlegooru.com/text-columns-google-spreadsheets/" rel="nofollow noreferrer">this</a> script to split the data out by column ready to answer the questions with. Will this impact the trigger needed to auto submit when a submission is made?</p></li>
  </ol>
  
  <p>May I add that I have a rather limited understanding on this so please go easy if this seems rather easy to do!</p>