Thanks Laurence! Very interesting! With the code shown in this video, how would you change the code to reference a cell on a tab that is holding this information? I would assume you would want to create a variable to reference this cell that is holding the 'sheet ID'? I am just trying to get away from having the Spreadsheet ID hard coded in the Apps Script, for if you send a copy of the file to someone else to test, they will have a different spreadsheet ID after they save the file on to their drive. I hope this makes sense. I too have subscribed to this channel!
You can make the code in a bound script, but that would also be complicated if a copy was made and the permissions would need to be reset. Would they need a copy , why wouldn't they be able to work off the original set view permissions?
For example, lets assume I have a spreadsheet called "DATA", where in cell C3 I have the entered value of the Sheet ID. Is there a way to get this ID into the Apps Script, so it is not hard coded?
Very good Laurence. I've already subscribed to his channel.
Cool, thanks
Thanks Laurence! Very interesting! With the code shown in this video, how would you change the code to reference a cell on a tab that is holding this information? I would assume you would want to create a variable to reference this cell that is holding the 'sheet ID'? I am just trying to get away from having the Spreadsheet ID hard coded in the Apps Script, for if you send a copy of the file to someone else to test, they will have a different spreadsheet ID after they save the file on to their drive. I hope this makes sense. I too have subscribed to this channel!
You can make the code in a bound script, but that would also be complicated if a copy was made and the permissions would need to be reset. Would they need a copy , why wouldn't they be able to work off the original set view permissions?
For example, lets assume I have a spreadsheet called "DATA", where in cell C3 I have the entered value of the Sheet ID. Is there a way to get this ID into the Apps Script, so it is not hard coded?
I can't find the part two? Where can I locate it?
I've uploaded them all on TH-cam
@@LaurenceSvekisCourses I have gone through the playlist to figure out the second video. Would you please show me the video url?