I love nocode, but sometimes, there's no alternative to writing some scripts haha.

I did this for a colleague last wk. A stopwatch INSIDE @googlesheets 🤯

Why? Easily sync up his Q's/notes to his audio recording.

A bit more info on how + results below 👇

#GAS #googleappscript
𝗛𝗢𝗪?
Google App Scripts

There are 6 simple functions:
1. Creates nav bar to access 2, 3, and 4
2. Starts the stopwatch
3. ⏸ the stopwatch
4. 🔄 the stopwatch
5. Adds the actual seconds to the stopwatch
6. Function to get the current stopwatch time
𝗥𝗘𝗦𝗨𝗟𝗧?
• Start, pause, & reset stopwatch easily
• See stopwatch at all times
• Easily record a time with simple copy/paste

𝗜𝗦𝗦𝗨𝗘𝗦?
• Can't click "undo" or it undoes the clock
• Can't write into the same field as formula
🤯 Isn't that cool?!

Happy to share the code with you for free if you wanna check it out (although disclaimer, uses french names haha), just like this thread and leave a comment or whatever.

GIFs are cool too
You can follow @thatdudedenis.
Tip: mention @twtextapp on a Twitter thread with the keyword “unroll” to get a link to it.

Latest Threads Unrolled: