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?