Hi , is there any way to create copy of original spreadsheet when user open original and show this copy to specific users speratly instead of original spreadsheet for them to edit as per users?
Unhelpful. How do you get to Season 1 ? You click on something and Season 1 comes up? How do I get Season 1 to come up? I googled 'how to open google sheets app script' and this video came up, which is totally unhelpful. Can you please change the name on this video. Thank you
The problem with this is that, unless the spreadsheet is opened in the browser, you can't alter it! let ss = SpreadsheetApp.openById(ssFileId); Logger.log(ss.getName()); //so it's actually opened on the server only //NOTE: the following does absolutely nothing! //create a tab/sheet called Data, and a second called Summary ss.insertSheet('Data', 0); ss.insertSheet('Summary', 1);
These short videoss help to keep concentration. Things never getting boring so far. Let's see how this gonna end.
Thanks for posting this.. learning just for fun!
@David Weiss, in gs, these functions do need to called in order to execute? all functions are executed in order from top to bottom? thanks
Hi , is there any way to create copy of original spreadsheet when user open original and show this copy to specific users speratly instead of original spreadsheet for them to edit as per users?
How do you close it?
great content man keep it up
Thanks a lot!
Another very good video, congratulations! A question, how do I create a new table tab with code? Thanks.
Unhelpful. How do you get to Season 1 ? You click on something and Season 1 comes up? How do I get Season 1 to come up? I googled 'how to open google sheets app script' and this video came up, which is totally unhelpful. Can you please change the name on this video. Thank you
Awesome
The problem with this is that, unless the spreadsheet is opened in the browser, you can't alter it!
let ss = SpreadsheetApp.openById(ssFileId);
Logger.log(ss.getName()); //so it's actually opened on the server only
//NOTE: the following does absolutely nothing!
//create a tab/sheet called Data, and a second called Summary
ss.insertSheet('Data', 0);
ss.insertSheet('Summary', 1);