🕑AUTOMATIC DATE and TIME when CLICK ON CHECKBOX [Google App Script] Google Sheets
18,330 views
About :
Let's learn how to automatically insert the date and time when clicking on a Checkbox in Google Sheets with the help of Google App Script to further automate this process within our Spreadsheet. 👉Link to the Spreadsheet we will work with: https://docs.google.com/spreadsheets/... 👉How to make a copy of the Spreadsheet: 🔴 • ✅EASY - Copy Google Sheets that ... Let's work with Google App Script to make another automation within Google Sheets, in this video lesson I will teach you how to automatically insert the date and time when editing the Google Sheet, in this case inserting the date and time when clicking on the Checkbox, you will learn the step by step and all the points you should pay attention to when writing this code. If you have never worked with Google App Script, I have already made a video lesson with an introduction to this free Google tool. Google App Script - Getting Started and How to Access: 🔴 • How to create a custom function (... It is also possible to use Scripts to integrate with all Google applications and thus further optimize our time, there is already a video lesson here on the channel teaching how to integrate with G-mail, so it is possible to send an automatic email directly from our Spreadsheet, all with Google App Script. Lesson on how to send automatic email with Google App Script: 🔴 • SCRIPT to SEND EMAIL WITH ATTACHMENT d... Remembering that all important links will always be here in the description for better learning and access to the documents and handouts of the video lessons. ⚠️If you want to master Google Spreadsheets, even if you already know something but still want to learn more about this free Google tool or even if you know nothing and want to learn from complete scratch, from the basics to the advanced in exclusive Google Sheets content, subscribe so you don't miss any new video lessons on the channel! Playlist Link to Master Google Sheets: 🔴 • How to pull data from other tabs in the pl... Teaching from scratch to advanced Google Sheets, Google App Script and Data Studio, with tutorials, step by step of Google Sheets, step by step of Data Studio and step by step of Google App Script. So if you want to learn about Google Sheets once and for all, you have come to the right channel, subscribe and follow all the video lessons on the channel. A big hug and success in spreadsheets!!! Chapters: 00:00 - Insert automatic date and time when clicking on the Checkbox 01:50 - Rename Google App Script project and files 02:30 - How to declare a Global CONST 04:00 - Get the active row and column in Google App Script 06:10 - Return the Date and Time with Java Script 08:20 - IF condition within Google App Script 11:10 - Necessary adjustments to avoid problems #googlesheets #googlesheets
333,897 views 1 day ago
559,134 views 1 day ago
109,772 views 16 hours ago
375,625 views 18 hours ago
1,205,629 views 3 days ago
559,134 views 1 day ago
1,291,205 views 2 days ago
523,888 views 3 days ago
523,888 views 3 days ago
Google AdSense
336 x 280
336 x 280
Up Next
DebbyG
16,327 views
8 hours ago
8 hours ago
DebbyG
16,317 views
3 weeks ago
3 weeks ago
Il diario della mia Vita
8,683 views
3 weeks ago
3 weeks ago
DebbyG
25,487 views
8 days ago
8 days ago
Chiaretta Alfredo
20,971 views
2 weeks ago
2 weeks ago
DebbyG
18,221 views
3 months ago
3 months ago
Rosy home shelter
11,188 views
3 weeks ago
3 weeks ago
DebbyG
16,439 views
3 weeks ago
3 weeks ago
Davide Albanese
376 views
10 hours ago
10 hours ago
Francy G
7,699 views
2 weeks ago
2 weeks ago
Nicole Gimondo
10,491 views
3 weeks ago
3 weeks ago
Ben e Holly - Italiano
270,568 views
6 months ago
6 months ago
JaneLK Ideas
286,563 views
3 years ago
3 years ago
Artes e dicas Lilis Souza
77,995 views
4 years ago
4 years ago
Sachelandia Laços
17,584 views
3 years ago
3 years ago
El mundo de Anita
180,614 views
10 years ago
10 years ago
JaneLK Ideas
770,862 views
4 years ago
4 years ago
tamyarteiraoficial laços
116,197 views
4 years ago
4 years ago
Google AdSense
336 x 280
336 x 280