python (65.2k questions)

javascript (44.3k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (13k questions)

Questions - spreadsheet-protection

Apps Script for Google sheet protection and giving permission to edit for multiple users

I need help for a code to protect Google sheet and giving editing access to multiple users the ability to edit the protected sheet. I have tried the code below but I was able to allow myself to edit b...
test-img

LM Ong

arrays

google-apps-script

permissions

editor

spreadsheet-protection

Votes: 0

Answers: 1

Latest Answer

Althogh I'm not sure whether I could correctly understand your situation, about I have tried to change the line for protection.addEditor(me); and add an array protection.addEditors([me,'abc@gmail.com'...
test-img

Tanaike

Protection formula looping in appscript

I have the data of 300*8 cell in that 3rd row contains email on based of that i m protecting row by appscript. I m new to appscript and no background of coding or computer. I have made the formula and...
test-img

Urmil patel

for-loop

google-apps-script

google-sheets

spreadsheet-protection

Votes: 0

Answers: 1

Latest Answer

Try This: function myfunk() { const ss = SpreadsheetApp.getActive(); const master = ss.getSheetByName("Master sheet"); for (let i = 0; i <= 10; i++) { var value = master.getRan...
test-img

Cooper

Posts

Questions

Blogs

Jobs