I love nocode, but sometimes, there& #39;s no alternative to writing some scripts haha.

I did this for a colleague last wk. A stopwatch INSIDE @googlesheets https://abs.twimg.com/emoji/v2/... draggable="false" alt="🤯" title="Explodierender Kopf" aria-label="Emoji: Explodierender Kopf">

Why? Easily sync up his Q& #39;s/notes to his audio recording.

A bit more info on how + results below https://abs.twimg.com/emoji/v2/... draggable="false" alt="👇" title="Rückhand Zeigefinger nach unten" aria-label="Emoji: Rückhand Zeigefinger nach unten">

#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. https://abs.twimg.com/emoji/v2/... draggable="false" alt="⏸" title="Doppelter vertikaler Strich" aria-label="Emoji: Doppelter vertikaler Strich"> the stopwatch
4. https://abs.twimg.com/emoji/v2/... draggable="false" alt="🔄" title="Pfeile abwärts und aufwärts in offenem Kreis gegen den Uhrzeigersinn" aria-label="Emoji: Pfeile abwärts und aufwärts in offenem Kreis gegen den Uhrzeigersinn"> 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& #39;t click "undo" or it undoes the clock
• Can& #39;t write into the same field as formula

https://abs.twimg.com/emoji/v2/... draggable="false" alt="🤯" title="Explodierender Kopf" aria-label="Emoji: Explodierender Kopf"> Isn& #39;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