title: Google Form Script to Add Pre-Filled Text
body: <p>I have a Form that my staff uses to send me data through out the day. </p>
  
  <p>One of the sections is a " long answer text" box for any comments.</p>
  
  <p>Usually there are no comments so it is left blank.</p>
  
  <p>My question is - </p>
  
  <p>is there a way to automatically pre fill text in a google form and how?</p>
  
  <p>I have used the pre filled link but if the user decides to submit another form (which they always do), it will take them back to the original form link and not the pre fill link.</p>
  
  <p>This data is sent to a spreadsheet with a custom dashboard with the most recent data.</p>
  
  <p>If there is a blank in the comment column, it will grab the last non blank cell in the column section and give off the wrong comment for that data.</p>
  
  <p>I havent found a way to fill all the blank cells with "no comment" in google sheets without filling all the cells that have not been used for google form submissions. Figured it might be easier to start with any script magic from google form instead of google sheets.</p>
  
  <p>Thank you in advance</p>