I have a time sheet set up so that when I click a button it enters the current time on a certain line but I can’t formulate it to enter new time on the next row when I click it again…
Column D
Monday Current Time <---Entered correctly but does not move to next row
Tuesday Row 11
Wednesday Row 12
Thursday Row 13
Friday Row 14
Saturday Row 15
Sunday Row 16
This is what I have so far:
function Clear() {
var spreadsheet = SpreadsheetApp.getActive();
spreadsheet.getRangeList(['C3', 'C9:D15', 'C19:D25']).activate()
.clear({contentsOnly: true, skipFilteredRows: true});
};
function ClockIn() {
var spreadsheet = SpreadsheetApp.getActive();
spreadsheet.getRangeList(['C9', 'C10', 'C11', 'C12', 'C13', 'C14', 'C15']).activate()
var date = new Date();
date.setFullYear(1899, 11, 30);
spreadsheet.getActiveRangeList().setValue(date)
.setNumberFormat('h:mm am/pm');
};
function ClockOut() {
var spreadsheet = SpreadsheetApp.getActive();
spreadsheet.getRangeList(['D9', 'D10', 'D11', 'D12', 'D13', 'D14', 'D15']).activate();
var date = new Date();
date.setFullYear(1899, 11, 30);
spreadsheet.getActiveRangeList().setValue(date)
.setNumberFormat('h:mm am/pm');
};
So how can I formulate this to go to the next line in the column when the button is pressed, and how can I loop it back to the beginning after so many entries? Any Ideas…?