How to open a URL in google apps script?

Question

[https://docs.google.com/spreadsheets/d/1owEwaLhddXvSfI11AA7ZWmuQh4oeKoVSZkiu9LSlRLU/edit?usp=sharing ]

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.

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);

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 ??

Answer 1

I have non-coding solution to this problem that only takes a couple of clicks.

In this sheet I have put on the end time column the formula =now(). When you change the yes or no column the end time column will update automatically. All you need to do is click on the timestamp for that row press ctrl+c to copy and ctrl+shift+v to paste. This will paste just the time without the formula making the timestamp permanent.