Amazing, you just made my life easy to track hours for my employees without paying anymore memberships THANK YOU SO MUCH
@tanveerhussain38813 жыл бұрын
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-qc8ek9 ай бұрын
WAW COOL I'm a new cs student, 43 yo I'm much more excited!! thank you bro !!! :))
@dmitry87322 жыл бұрын
Exactly what I was looking for.
@Nate-ix1mo3 жыл бұрын
Was looking for something like this, thank you!
@DevonTheInspiredFilmmaker3 жыл бұрын
This worked GREAT! This is exactly what I needed! Thanks for the tutorial!
@sonukumar-bo7qk3 жыл бұрын
Hello, can u please help me with the code
@brig90873 жыл бұрын
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-eq8sv9yc9o11 ай бұрын
Did you ever figure this out? When I edit the time the total hours dont adjust properly
@iclx78442 жыл бұрын
do you have a link to a template??
@CodeWithCurt4 жыл бұрын
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
@armymoaengenecarat59553 жыл бұрын
copied and pasted this but im getting this error
@armymoaengenecarat59553 жыл бұрын
TypeError: Cannot read property 'getLastRow' of null
@kristinemoffett60173 жыл бұрын
How did you get all the codes? I followed your video and don't know how you found them
@cpoornimal2473 жыл бұрын
same problem
@chrissharpe85982 жыл бұрын
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!
@centralcomputer75453 жыл бұрын
i was try,but At Total Hour Not Replace, please Can you help me
@paconogara65272 жыл бұрын
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?
@Awhienk4 жыл бұрын
One subscribe from Indonesia
@user-eq8sv9yc9o11 ай бұрын
Okay got this working... MOSTLY.... what about editing the clock in and out times? the total hours does not properly adjust
@biancalaroza77323 жыл бұрын
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?
@gianliv043 жыл бұрын
what if I wanted to separate the date and time? That would result in totals the name and time and the total accumulated hours?
@mimitv77843 жыл бұрын
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:"
@southerntagalogcommand29943 жыл бұрын
kindly help me out, it keeps saying that the lastRow is not define, line 12 base on your turial. what should i DO?
@mustaphaighchane42652 жыл бұрын
if you know how plz tel me
@hnag1907 Жыл бұрын
Name your sheets exactly like the video and also the pages
@raimondas273 жыл бұрын
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.
@dmitry87322 жыл бұрын
If the script concatenates time values instead of summing them. Where can be an error?
@sarahgolder11 ай бұрын
Mine just brings up apps script and then says clockin and clockout cannot be found
@lalitobodoque2 жыл бұрын
It works in a smart phone with the app of google sheets?
@premdavid31313 жыл бұрын
Hi , I have typeError Cannot read property 'getlastrow' of null
@hnag1907 Жыл бұрын
Name the sheet and pages exactly as in the video
@SunilKumar-ob6vs2 жыл бұрын
Can it handle days count also means if out time in next day ...if yes please update...
@user-tc9mm4dd1z11 ай бұрын
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?
@DevonTheInspiredFilmmaker3 жыл бұрын
Quick question, to clear all the information, just delete the boxes?
@CodeWithCurt3 жыл бұрын
Yes to start over just clear the google sheet cells
@kenneithmind45973 жыл бұрын
where is the coding?
@rebeccaduran11953 жыл бұрын
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
@dantyr1110 ай бұрын
WHY can't I find what in excel
@akashtakvani48644 жыл бұрын
I typed everything. But getting "typeerror : cannot read property 1 of undefined. " Please help
@CodeWithCurt4 жыл бұрын
Posted Code in Comments
@mischelsanmiguel2007 Жыл бұрын
how to change the timezone?
@merrychristinedalusung37274 жыл бұрын
Kindly share the functions? 😊
@CodeWithCurt4 жыл бұрын
Posted Code in Comments
@imadethisformcds9893 жыл бұрын
Can you post the code in the comment plz
@JeykNeyra4 жыл бұрын
Where is the Code??
@mhonzregis36493 жыл бұрын
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
@CodeWithCurt3 жыл бұрын
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);
@RaneeA3 жыл бұрын
@@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
@thomastdg88203 жыл бұрын
@@RaneeA dit you manege to fix this problem?
@brigittea11183 жыл бұрын
@@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.99873 жыл бұрын
Drop down not working on Mobile device
@manuelmezquita94623 жыл бұрын
IDK y i get getlastrow error like i did everything to the letter
@jsbeardessentials3 жыл бұрын
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
@manuelmezquita94623 жыл бұрын
man its not working
@akashtakvani48644 жыл бұрын
Code not shared :( too much disappointed.
@CodeWithCurt4 жыл бұрын
Posted Code in Comments
@mimitv77843 жыл бұрын
@@CodeWithCurt I couldn’t find it 🥺
@llawliet35522 жыл бұрын
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);
@elia66882 жыл бұрын
Can you do an app version ? Will pay for it:)
@arturitojoestar2 жыл бұрын
do you still need?
@lorraine55582 жыл бұрын
Good question
@noeme174 жыл бұрын
I hope he shares the code so we don't have to type everything
@akashtakvani48644 жыл бұрын
I typed everything. But getting "typeerror : cannot read property 1 of undefined. " Please help
@akashtakvani48644 жыл бұрын
I typed everything. But getting "typeerror : cannot read property 1 of undefined. " Please help