#New tab for google sheet code

#New tab for google sheet code

In my example screenshot above there are 7 items, but yours may have 5 or even 25!! We do not want to count this list ourselves each time, let the code do it for you. To avoid an error, you can not duplicate names or have blank rowsĮvery time you use this code there may be a different number of items in the list. For this project we are keeping it simple. If you have not already, type some things into column A. If you want to specifically define a sheet even if it is not the active sheet you may want to try using var sheet = ss.getSheetByName(‘Sheet1’) Listįor this script, we are assuming you have a list of tab names in column A. It will be important that the active sheet is the one that has a list in column A. Whatever sheet you are looking at when you run the code will be what the code is run on. Var sheet = ss.getActiveSheet() Get Active Sheet After identifying the variable ss to indicate the entire spreadsheet, define a variable to identify a particular sheet. When coding a spreadsheet you want to identify if you are applying the code to the entire spreadsheet, a particular sheet or a particular range. Var ss = SpreadsheetApp.getActiveSpreadsheet() Sheet In this case we are coding SpreadsheetApp. Your first line of code is almost always to identify which Google App you are coding in Google Apps Script. Create a blank spreadsheet and use the Tools menu to choose “Script editor.” Create a sheet for each name in the list with that tab name. If you want to borrow some of the code or to tweak my project use the Tools menu and choose “Script editor.” Objective Use the template at /rostertab to do this without any coding. I previously coded RosterTab to allow you to easily take a roster of your students and create a named tab for each of them. This tutorial will help you to create additional sheets in a Google Sheets spreadsheet. You can find more tutorials at /scripts scroll all the way to the bottom.

Here is a scripting activity to help you practice your Google Apps Script skills. It is based on JavaScript, but you need to know very little to be able to do Google Apps Script. Google Apps Script allows you to customize what Google text docs and Google Sheets can do for you.