Script to create new sheets that are protected (Google sheets)

Script to create new sheets that are protected (Google sheets)
0

#1

I already have a script for a button that save and create a new sheet of the saved version. The goal is to modify a cashier sheet and to create a copy with the date and the name of the cashier. The only part missing for this script is that everytime a new version of the sheet is created it would be protected. For example, on the picture, the first sheet is called Auberge and it’s the one that we modify. Now, I would like that all the new sheets that we create when we press on the button Save, like the one called Alex 4 août, be protected automatically. Then, only the manager could modify the final versions of the cashiers sheets. The employees would only be able to modify the sheet called Auberge and then save it.


#2

Firstly, welcome to the forums.

While we are primarily here to help people with their Free Code Camp progress, we are open to people on other paths, too.

With your current questions, we don’t have enough context to know what you already know or don’t know, so it is impossible to guide you without just telling you the answer (which we won’t do).

It is pretty typical on here for people to share a link to their project code, to show what they have tried so that anyone helping has more of an idea of what help is actually helpful.

Happy coding :slight_smile: