title: Can a Google Form be auto filled and submitted, using data from a spreadsheet?
body: <p>I am trying to determine how to get a script to take data from a spreadsheet and fill out a form, then submit the form.  The script would be part of the spreadsheet</p>
  
  <p><strong>FORM</strong></p>
  
  <p>My Form has 3 text fields, one date, and one choose from a list field.<BR>
  User Name:       "TEXT"<BR>
  User's Manager:  "TEXT"<BR>
  Start Date:      "DATE"<BR>
  Location:        "LIST"<BR>
  Cube#:           "TEXT"<BR></p>
  
  <p><strong>SPREADSHEET</strong></p>
  
  <p>The spreadsheet has rows listing a variety of users, only some of which would need to have this form submitted.<br>
  The spreadsheet has a column relating to each of the form fields plus an additional column to indicate that the form should (or should not) be submitted for this user.</p>
  
  <p>I would also need the script to datestamp the cell that indicates the form should be submitted after the form has been completed.</p>
  
  <p>I've seen several posts about populating forms, but they all seem to be in the creation of the form, not the population of an existing form.</p>
  
  <p>I'm exceptionally new to scripting, so any help is much appreciated.  Please let me know if I need to supply additional information.  Thanks!</p>