Create an Input Sheet with a Submit Button in Google Sheets to add Data to a Log: Apps Script part 2
20.3 هزار بار بازدید -
2 سال پیش
-
The Starter Sheet:
The Starter Sheet: https://docs.google.com/spreadsheets/...
In this tutorial, we add the Google Apps Script that
1. Collects the Data Input
2. Checks to ensure that there is data in each cell.
3. Adds a the current date-time and user email to the input data.
4. Submits the data to the data log.
5. Clears in the input sheet.
6. Send a update (toast) to the user that the task was completed successfully.
In the next video, we will handle a situation where an editor copies and pastes in data an we need to reformate the cells and add back in the data validation once they have submitted the data.
This tutorial is part of the: Building a Data Log in Google Sheets with Google Apps Script series. Link to the playlist here: Building a Data Log in Google Sheets ...
If you like the video, check out my website:
https://yagisanatode.com/
You can find out more about how to append and manipulate Google Sheets data in these tutorials:
- Copy and Paste Range Values from one Google Sheet into another with Google Apps Script Copy and Paste Range Values from one ...
- Google Apps Script – Copy Selected Columns in One Sheet and Add Them To The Bottom of Different Selected Columns in Another - https://yagisanatode.com/2018/11/17/g...
- Google Apps Script: Get the last row of a data range when other columns have content like hidden formulas and check boxes [updated Dec 2021] - https://yagisanatode.com/2019/05/11/g...
- Google Apps Script Course – Part 1: 2D Array Data Transformation of Single Question Item Data to Total Count of Choices in Google Sheets - Google Apps Script Course – Intro: 2D Array Data Transformation for Google Sheets - https://yagisanatode.com/2019/12/22/g...
- Creating Unique Ranges from 2D Arrays in Google Apps Script - https://yagisanatode.com/2020/10/26/c...
- Google Apps Script: Add and removed Google Sheets columns based on a search array - https://yagisanatode.com/2020/03/28/g...
00:00 Intro
01:33 The Code- Grab the SpreadsheetApp class
02:10 Retrieve the input data.
04:29 Check the cells are filled out.
09:09 Adding the date and the user's email to the data
11:25 Append the data to the log.
12:43 Clear the input data range.
13:38 Reporting back to the user with Toast.
14:16 Testing the code.
16:45 Up next.
Here is the link to just Google Apps Script tutorials:
https://yagisanatode.com/google-apps-...
#GoogleSheets #GoogleWorkspace #GoogleAppsScript #AppsScript #Spreadsheets
In this tutorial, we add the Google Apps Script that
1. Collects the Data Input
2. Checks to ensure that there is data in each cell.
3. Adds a the current date-time and user email to the input data.
4. Submits the data to the data log.
5. Clears in the input sheet.
6. Send a update (toast) to the user that the task was completed successfully.
In the next video, we will handle a situation where an editor copies and pastes in data an we need to reformate the cells and add back in the data validation once they have submitted the data.
This tutorial is part of the: Building a Data Log in Google Sheets with Google Apps Script series. Link to the playlist here: Building a Data Log in Google Sheets ...
If you like the video, check out my website:
https://yagisanatode.com/
You can find out more about how to append and manipulate Google Sheets data in these tutorials:
- Copy and Paste Range Values from one Google Sheet into another with Google Apps Script Copy and Paste Range Values from one ...
- Google Apps Script – Copy Selected Columns in One Sheet and Add Them To The Bottom of Different Selected Columns in Another - https://yagisanatode.com/2018/11/17/g...
- Google Apps Script: Get the last row of a data range when other columns have content like hidden formulas and check boxes [updated Dec 2021] - https://yagisanatode.com/2019/05/11/g...
- Google Apps Script Course – Part 1: 2D Array Data Transformation of Single Question Item Data to Total Count of Choices in Google Sheets - Google Apps Script Course – Intro: 2D Array Data Transformation for Google Sheets - https://yagisanatode.com/2019/12/22/g...
- Creating Unique Ranges from 2D Arrays in Google Apps Script - https://yagisanatode.com/2020/10/26/c...
- Google Apps Script: Add and removed Google Sheets columns based on a search array - https://yagisanatode.com/2020/03/28/g...
00:00 Intro
01:33 The Code- Grab the SpreadsheetApp class
02:10 Retrieve the input data.
04:29 Check the cells are filled out.
09:09 Adding the date and the user's email to the data
11:25 Append the data to the log.
12:43 Clear the input data range.
13:38 Reporting back to the user with Toast.
14:16 Testing the code.
16:45 Up next.
Here is the link to just Google Apps Script tutorials:
https://yagisanatode.com/google-apps-...
#GoogleSheets #GoogleWorkspace #GoogleAppsScript #AppsScript #Spreadsheets
2 سال پیش
در تاریخ 1401/03/20 منتشر شده
است.
20,346
بـار بازدید شده