title: Is the timestamp for a Google Form response event always the same as the timestamp in the linked spreadsheet?
body: <p>if I get a timestamp for a Google Form submit event, using for example:</p>
  
  <pre><code>var timestamp = event.response.getTimestamp();
  </code></pre>
  
  <p>a time is returned e.g. </p>
  
  <blockquote>
    <p>Fri Sep 26 17:54:02 GMT+12:00 2014</p>
  </blockquote>
  
  <p>and in the linked spreadsheet the timestamp 
  is displayed in column one.  </p>
  
  <p>Are both timestamps always identical (i.e. is the event timestamp passed to the spreadsheet) or can they be different and the timestamp on the spreadsheet is actually the timestamp of the write to the spreadsheet?</p>
  
  <p>Background:  I'm making an application where when a form is submitted an email is sent to the person who has filled in the form with a confirm link.  Using a query url and a webapp on the form's linked spreadsheet I can get the parameters from the query url.  I now need to have a unique id to find the entry in the spreadsheet in order to to mark it as 'confirmed'.  Timestamps seem a suitable way of doing this, but better ways may exist.</p>
  
  <p>Thanks in advance,</p>
  
  <p>Trevor</p>