Time Tracker Google Sheets: How to create an app using Google Apps Script

[@AdminAtlas]

Amazing, you just made my life easy to track hours for my employees without paying anymore memberships THANK YOU SO MUCH

[@tanveerhussain3881]

World's Best Teacher Best Quality Learn Easy and Understand I Love And Like All Video

[@ronmariani]

Brilliant and to the point !! Well Done Sir

[@AG-qc8ek]

WAW COOL I'm a new cs student, 43 yo I'm much more excited!! thank you bro !!! :))

[@dmitry8732]

Exactly what I was looking for.

[@Nate-ix1mo]

Was looking for something like this, thank you!

[@DevonTheInspiredFilmmaker]

This worked GREAT! This is exactly what I needed! Thanks for the tutorial!

[@sonukumar-bo7qk]

Hello, can u please help me with the code

[@brig9087]

Please Help! I don't know what to do next.. this is the error after I run the codes.. TypeError: Cannot read property 'getLastRow' of null

[@mischelsanmiguel2007]

@@brig9087 hi! did you resolve yours? i just tried it now and got the same result. what did you do to fix it?

[@nitanew1]

Great video...you are AWESOME!! Can you manually edit the time entry? For scenarios in which they begin work but forgot to clock in, thus need to adjust the time.

[@user-eq8sv9yc9o]

Did you ever figure this out? When I edit the time the total hours dont adjust properly

[@iclx7844]

do you have a link to a template??

[@CodeWithCurt]

Google Apps Script Code used in Video Below: function clockIn() { //DEFINE ALL ACTIVE SHEETS var ss = SpreadsheetApp.getActiveSpreadsheet(); //DEFINE MAIN SHEET var mainSheet = ss.getSheetByName("MAIN"); //LAST ROW ON MAIN SHEET var lastRow = mainSheet.getLastRow(); for (var j = 5; j

[@armymoaengenecarat5955]

copied and pasted this but im getting this error

[@armymoaengenecarat5955]

TypeError: Cannot read property 'getLastRow' of null

[@kristinemoffett6017]

How did you get all the codes? I followed your video and don't know how you found them

[@cpoornimal247]

same problem

[@chrissharpe8598]

When i fill out the rest of the sheet with formulas or drop boxes it resorts to the last cell is there anything i could change so it only focuses on A, B , C?

[@nurazizah8063]

Hi, I have implemented the code and it's awesome. I'm just wondering, I've tried several "test" and it goes until row 19, if I wanted to start using it, how to delete all of the previous data since it is not gone even though I deleted it. Waiting for your answer, thanks!

[@centralcomputer7545]

i was try,but At Total Hour Not Replace, please Can you help me

[@paconogara6527]

Is it possible to capture multiple "Start time and End Time" punches if the sheet is shared to multiple users using different devices/PC? Like for example user1 punches 1:00am then user2 punches his start time at 1:02am is it possible that their punches will be recorded at the same time?

[@Awhienk]

One subscribe from Indonesia

[@user-eq8sv9yc9o]

Okay got this working... MOSTLY.... what about editing the clock in and out times? the total hours does not properly adjust

[@biancalaroza7732]

how can set the code if i wanted my time stamp to be started on a specific column and with a column freeze from A to J. I wanted to start the Clock In and Out in Colum K onwards because columns A-J will be used for a different data and that is where i will freeze the column. i have data from A to J columns and rows, since we are using the lastrow script it will time stamp to the last row i used from A to J column but i wanted to record the time at the starting rows of columns K to Z. Can you help me?

[@Cloud-mo4vv]

Can you add a code where the employees can see what time they need to return? Something like a 15minutes break tracker, and they need to clock back in before the 15minute break time

[@kyleelizaespinoza6749]

Is there a way, that an employee can only click the In and out, only for his/her name? and not for the other employee?

[@gianliv04]

what if I wanted to separate the date and time? That would result in totals the name and time and the total accumulated hours?

[@mimitv7784]

Thank you so much :) but how can i show an error box that says OVERBREAK when you clock out and the result is beyond 45 mins. and it will also ask a question "Reason for overbreak:"

[@southerntagalogcommand2994]

kindly help me out, it keeps saying that the lastRow is not define, line 12 base on your turial. what should i DO?

[@mustaphaighchane4265]

if you know how plz tel me

[@hnag1907]

Name your sheets exactly like the video and also the pages

[@raimondas27]

How to restrict to only one employee clocked in at any given time? Before next can clock in the active one needs to clock out.

[@dmitry8732]

If the script concatenates time values instead of summing them. Where can be an error?

[@sarahgolder]

Mine just brings up apps script and then says clockin and clockout cannot be found

[@lalitobodoque]

It works in a smart phone with the app of google sheets?

[@premdavid3131]

Hi , I have typeError Cannot read property 'getlastrow' of null

[@hnag1907]

Name the sheet and pages exactly as in the video

[@SunilKumar-ob6vs]

Can it handle days count also means if out time in next day ...if yes please update...

[@user-tc9mm4dd1z]

why is the total hours not summarized, even though the code entered is exactly the same, thank you

[@asramakiis6902]

how to change the total hours into minute ?

[@redefyneemployees899]

Has anyone gotten this to work on a tablet or mobile with the sheets app? OR does this have to be run on a desktop/laptop?

[@DevonTheInspiredFilmmaker]

Quick question, to clear all the information, just delete the boxes?

[@CodeWithCurt]

Yes to start over just clear the google sheet cells

[@kenneithmind4597]

where is the coding?

[@rebeccaduran1195]

Hi can anyone share the code? It's not in the comment. TIA for the reply 😊

[@hnag1907]

On the RHS top there is a button "Share" Click there and send

[@dantyr11]

WHY can't I find what in excel

[@akashtakvani4864]

I typed everything. But getting "typeerror : cannot read property 1 of undefined. " Please help

[@CodeWithCurt]

Posted Code in Comments

[@mischelsanmiguel2007]

how to change the timezone?

[@merrychristinedalusung3727]

Kindly share the functions? 😊

[@CodeWithCurt]

Posted Code in Comments

[@imadethisformcds989]

Can you post the code in the comment plz

[@JeykNeyra]

Where is the Code??

[@mhonzregis3649]

I want the output of hours to be in a duration format or hh:mm:ss how do I do that, I trie changing .setNumberFormat("#0.00") to .setNumberFormat("hh:mm:ss") but its giving me an incorrect total of hours

[@CodeWithCurt]

Below is the replacement code to get HH:MM:SS For Function clockOut() var totalTime = (mainSheet.getRange(j,3).getValue() - mainSheet.getRange(j,2).getValue()); mainSheet.getRange(j,4).setValue(new Date(totalTime).toISOString().substr(11, 8)); For Function TotalHours() var rate = mainSheet.getRange(j, 3).getValue() - mainSheet.getRange(j, 2).getValue(); mainSheet.getRange(5+i,7).setValue(new Date(totals[i][1]).toISOString().substr(11, 8)).setFontSize(12);

[@RaneeA]

@@CodeWithCurt I tried this replacement, but it turned out that the "starting interval line is too short" In the cell of hours, the time appears correctly in the format hh: mm: ss, but in Total Hours nothing appears in the name of the cell to the right of it

[@thomastdg8820]

@@RaneeA dit you manege to fix this problem?

[@brigittea1118]

@@CodeWithCurt Hello Sir, good day.. do you have codes for In and Out but will be reflected on the column H (In), column I (Out), column (J) for calculated duration of time (h:mm:ss)?? please help. this is my assignment. I would like to change the reference to column C (instead of column B1). thank you so much...

[@rdlowesinc.9987]

Drop down not working on Mobile device

[@manuelmezquita9462]

IDK y i get getlastrow error like i did everything to the letter

[@jsbeardessentials]

I did the same and I caught an error on line 12. Couldn’t figure it out.

[@hnag1907]

Name the sheet and pages exactly as in the video

[@manuelmezquita9462]

man its not working

[@akashtakvani4864]

Code not shared :( too much disappointed.

[@CodeWithCurt]

Posted Code in Comments

[@mimitv7784]

@@CodeWithCurt I couldn’t find it 🥺

[@llawliet3552]

Good day, Sir, why is the script won't add a new record every time it read on this part? and sometimes it takes more than a minute running the script. // ADD CLOCK IN RECORD mainSheet.getRange(lastRow+1,1).setValue(mainSheet.getRange('B1:B1').getValue()).setFontSize(12); mainSheet.getRange(lastRow+1,2).setValue(new Date()).setNumberFormat("MM/dd/yyyy hh:mm:ss A/P").setHorizontalAlignment("left").setFontSize(12);

[@elia6688]

Can you do an app version ? Will pay for it:)

[@arturitojoestar]

do you still need?

[@lorraine5558]

Good question

[@noeme17]

I hope he shares the code so we don't have to type everything

[@akashtakvani4864]

I typed everything. But getting "typeerror : cannot read property 1 of undefined. " Please help

[@akashtakvani4864]

I typed everything. But getting "typeerror : cannot read property 1 of undefined. " Please help

[@noeme17]

@@akashtakvani4864 had the same error too

[@ericsonreyes2220]

Syntax Error

[@akashtakvani4864]

@@noeme17 what will next if u can help me

[@rileymorrissey5688]

do you have a link to a template??