title: How to open a URL in google apps script?
body: <p>[<a href="https://docs.google.com/spreadsheets/d/1owEwaLhddXvSfI11AA7ZWmuQh4oeKoVSZkiu9LSlRLU/edit?usp=sharing" rel="nofollow noreferrer">https://docs.google.com/spreadsheets/d/1owEwaLhddXvSfI11AA7ZWmuQh4oeKoVSZkiu9LSlRLU/edit?usp=sharing</a>   ]</p>
  
  <p>This is my sheet in which i fill the start time for first row manually. I open the link manually for the first time and mark my judgement for "Purchasable" Column as Y/N. As soon as i mark my judgement i want the "end time" column to fill automatically and the link in the "URL" column of the next row to open up automatically and repeat the same series. Is it possible by app script as I need to perform this task on google spreadsheet.</p>
  
  <pre><code>if(r.getColumn()==4){
  var endCell=r.offset(0,4);
  if(endCell.getValue()==='')
  var date=Utilities.formatDate(new Date(),timezone,timestamp_format);
  endCell.setValue(date);
  var startCell=r.offset(1,-1);
  startCell.setValue(date);
  </code></pre>
  
  <p>Now this could fill up the start and end time for a sample when i fill up the purchasable Column but I cant figure out how to open the next URL without clicking on it ?? </p>