title: Google Apps Script - How to get corresponding record in destination spreadsheet in onFormSubmit (Google Forms Event)?
body: <p>I catch this event when a respondent sends a response</p>
  
  <p><a href="https://developers.google.com/apps-script/guides/triggers/events#form-submit_4" rel="nofollow noreferrer">https://developers.google.com/apps-script/guides/triggers/events#form-submit_4</a></p>
  
  <p>Inside this function, I want to add some information into the corresponding row (Google creates this row automatically) in the destination spreadsheet</p>
  
  <p>In order to do that, <strong>first I need to find this row</strong></p>
  
  <p>The best way I can find at the moment is by using <code>sheet.getLastRow()</code></p>
  
  <p><a href="https://developers.google.com/apps-script/reference/spreadsheet/sheet#getlastrow" rel="nofollow noreferrer">https://developers.google.com/apps-script/reference/spreadsheet/sheet#getlastrow</a></p>
  
  <p>But there is concurrency problem with this method: Serge insas said it here: <a href="https://stackoverflow.com/a/17751544/2667212">https://stackoverflow.com/a/17751544/2667212</a></p>
  
  <blockquote>
    <p>There are a few risks to use that simple "strategy" as there might be
    concurrency issues when 2 or more people send a form simultaneously</p>
  </blockquote>
  
  <p>Is there any correct way to achieve this?</p>