Thank you for creating this video!! My dad has asked me to help him with his small business and I needed a free way to conveniently and accurately keep track of my hours. I've never used Apps Script, but it was so easy to follow along your instructions. I also like how you included your thinking process (and even mistakes!) in your final edit for this video -- it's very relatable and gives me hope that I can improve at my Google Sheets skills! This is one of the most helpful videos out there!

@BetterSheets

9 ай бұрын

Glad it helped!

Thanks for this, it is so helpful! Now, I might be getting overly ambitious, but is it possible to put more than one stopwatch in a sheet by basically duplicating this code in with a different A1? Also, I would love to change the color of the "button" in addition to the start/stop as another visual reminder. I hope I can figure out how to do that without messing up the lovely creation you helped me make so far! You've inspired me.

Thank you! This is exactly what I needed.

@BetterSheets

3 ай бұрын

Fantastic!

that's really awesome

@BetterSheets

9 ай бұрын

You are awesome!

It won’t save and gives me an error message sayin var is an unexpected token on line 14.

@BetterSheets

9 ай бұрын

where are you running the script from?

Where can we find written instructions for this? You go so fact I can't even tell what you clicked and can't possibly keep up to try and follow the video! Thanks!

@BetterSheets

4 ай бұрын

Transcripts available here and on better sheets. Also the sheets are available for download for Better Sheets members.

@SeanClarke

4 ай бұрын

@@BetterSheets thank you

Nice! Also, is it possible to have the stopwatch run as a stopwatch on a phone (with decimals)?

@BetterSheets

Жыл бұрын

Not in a live update kind of way. Maybe each minute can. With iterative calculations

Does this only work with Workspace account?

@BetterSheets

9 ай бұрын

as long as you have google sheets... you can do it. in Apps Script. Every sheet has Apps Script. go to the menu: Extensions > Apps Script

sorry can you help me When chescbox is enabled, the formula should stop working

@BetterSheets

5 ай бұрын

Try going through the whole video

Man, please slow down when you do your videos, how can anyone learn if you are speeding through the features in the video :(

@BetterSheets

9 ай бұрын

can't slow down the speed of the video? or pause?

@urbantekgames

9 ай бұрын

Usually, you'd be correct, however, I noticed at least one instance in your video above where I couldn't figure out what you'd done and that was because you didn't slow down and address it. Where you changed e.range.row to e.range.getRow. You made this change and then said it worked, however when you flashed back to the screen briefly I noticed you'd actually then added () at the end as well as adding .getColumn() and fixing the editColum var. For newbies, that can make it incredibly hard to follow your steps, especially if you're not providing the code in a document for them to access and you're expecting them to follow along. You might find for future videos that if you split your screen and keep your code on screen the whole time you're talking people following step by step can then slow down if required but can always view it. I really appreciate your efforts and this has been really handy however I did find following this extremely frustrating at times due to your speed and you editing out some of the changes you'd made. That said, keep up the great work mate.@@BetterSheets

I just love when tutorial videos move at lightning speed. Might be good to know your audience. Just sayin.

@BetterSheets

4 ай бұрын

Appreciate the feedback!

This is literally impossible to follow. Why not just show the code from top to bottom? You back track and refill old rows over and over

@BetterSheets

7 ай бұрын

Did you watch whole video?

@WhatKelsLoves

7 ай бұрын

Uh yeah. And then I asked AI. And it got it done in a fraction of the time with no back and forth.

@ImmZ69420

6 ай бұрын

I agree without a doubt

@user-cd6yn5ny7j

3 ай бұрын

That's almost what I want to do, but so sad, that you didn't explain those functions and classes better. It's really hard for me to understand...

@Mike_0325

10 күн бұрын

Same thought. Just provided an idea but not how to really do it. So thumbs down for this video.

Why didn't you do that step by step? First one with the usual check box, without changing any start/stop labeles? After you've mixed different tasks in one code, it's almost impossible to follow your way of thinking and coding... for non professional, like me😢 I'm rewatching this video again and again and can't find the solve of my problem. I just need to add time without additing any new rows, labels and checking logs...

@BetterSheets

3 ай бұрын

So you want to add time... based on a click?

What if there's nothing in my "executions?"

@BetterSheets

11 ай бұрын

It may take a moment to show up or no executions even happened.

After carefully reviewing your video, one thing I realized. You intend to mess up things because your intention is clearly not to teach at all but more on views so as others will rewatch your videos many times, and not really to be educational at all. Bad tactic. You deserve my thumbs down button.

@BetterSheets

10 күн бұрын

Thanks for the review.

Just did this in a fraction of the time with GPT.⌛ Create a button shape with Insert > Drawing. Click on the three dots by rolling over your new image and select assign script. Add this code (below)🔽🔽 and save. Job done! function startStopTimer() { const sheet = SpreadsheetApp.getActiveSheet(); const now = new Date(); const formattedDateTime = Utilities.formatDate(now, Session.getScriptTimeZone(), "MM/dd/yyyy HH:mm:ss"); const buttonCell = sheet.getRange("A1"); const buttonState = buttonCell.getValue(); if (buttonState === "Start Timer" || buttonState === "") { // Start the timer buttonCell.setValue("Stop Timer"); const nextRow = sheet.getLastRow() + 1; // Get the next empty row sheet.getRange("B" + nextRow).setValue(formattedDateTime); } else { // Stop the timer buttonCell.setValue("Start Timer"); const lastStartTimeRow = sheet.getLastRow(); sheet.getRange("C" + lastStartTimeRow).setValue(formattedDateTime); } }

@BetterSheets

7 ай бұрын

Not sure that is going to work for everyone.