title: Create and update time in google form responses
body: <p>Is there away to get google form (response) submit time and update time?</p>
  <p>I have created google form and responses are being recorded in Google sheet. As soon as response is submitted it automatically captures time under first column that is &quot;Timestamp&quot;. Now, if the response is updated ( for an example after three hours) then the time recorded initially (Timestamp) also gets updated. By the way i have created script which generates link to edit response in last column so that users can update their responses anytime. Is there any work around to get response submitted (created) time and update in different columns?</p>
  <p>Any help is appreciated.</p>
  <p>As suggested by Ruben,</p>
  <p>I've created below script but it is not working</p>
  <pre><code>    function assignEditUrls() {
      var form = FormApp.openById('1UoHiwgl2Kw6RK5c7- 
      0kp1iFP0CPPR_LDbvSm1hw9xLg');
      var sheet = 
      SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Form 
      responses 1');
      var data = sheet.getDataRange().getValues();
      var urlCol = 16;
      var responses = form.getResponses();
      var timestamps = [], urls = [], resultUrls = [];
      for (var i = 0; i &lt; responses.length; i++) {
      timestamps.push(responses[i].getTimestamp().setMilliseconds(0));
      urls.push(responses[i].getEditResponseUrl());
      }
      for (var j = 1; j &lt; data.length; j++) {
      resultUrls.push([data[j][0]?urls[timestamps.indexOf(data[j] 
      [0].setMilliseconds(0))]:'']);
      }
      sheet.getRange(2, urlCol, 
      resultUrls.length).setValues(resultUrls);
  
      {
      var blankRow=sheet.getLastRow(); //identify the next blank row
  
      // date function to update the current date and time as 
      submittted on
      var value = sheet.getRange(blankRow, 19).setValue(new 
      Date()).setNumberFormat('dd-mm-yyyy h:mm:ss'); //Submitted On
      sheet.getSheetValues(value);
      }
  
      }
  </code></pre>
  <p>It is updating time in the last column, but if I update the form response then again it gets updated. I want create date which should be entered in the initial entry. Please help me with the correction in my script.</p>