--
You received this message because you are subscribed to the Google Groups "GAM for Google Workspace" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-man...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/37d920f8-3529-483c-a745-d77e7013acc1n%40googlegroups.com.
Here is a sample JSON file, Sheet.json
N is the sheet ID.
Column X is the column that us...@domain.com can edit (columns are 0 origin)
Columns X+1 to Y-1 are not editable (the closing index is open)
gam us...@domain.com update sheet <DriveFileItem> json file Sheet.json
{"requests":
[
{"addProtectedRangeRequest":
{"protectedRange":
{"range": {"sheetId": N, "startColumnIndex": X, "endColumnIndex": X+1},
"editors": {"users": ["us...@domain.com"]}
}
}
},
{"addProtectedRangeRequest":
{"protectedRange":
{"range": {"sheetId": N, "startColumnIndex": X+1, "endColumnIndex": Y}
}
}
}
]
}
You received this message because you are subscribed to a topic in the Google Groups "GAM for Google Workspace" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/google-apps-manager/6UE47mgfNus/unsubscribe.
To unsubscribe from this group and all its topics, send an email to google-apps-man...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/CAJkvRS_2tQ5O3iOSjMxoatzLF_sNzUdJ%3DYaeNfmye1vYmOMa0A%40mail.gmail.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/CA%2B0bb36%2B8CGpZW4v_VBXV4UgeD3N81Da%3Dtc0SJKw6Tgx51FqFQ%40mail.gmail.com.
Gabriel
Clifton | Network Administrator
Fort Stockton ISD | Technology Center
gabriel...@fsisd.net | http://www.fsisd.net
Office (432) 336-4055 ext 2
Fax (432) 336-4050
1204 W. Second St., Fort Stockton, TX 79735
CONFIDENTIALITY NOTICE: The contents of this email message and any attachments are intended solely for the addressee(s) and may contain confidential and/or privileged information and may be legally protected from disclosure. If you are not the intended recipient of this message or their agent, or if this message has been addressed to you in error, please immediately alert the sender by reply email and then delete this message and any attachments. If you are not the intended recipient, you are hereby notified that any use, dissemination, copying, or storage of this message or its attachments is strictly prohibited.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/0c8a7cde-b312-4685-b017-75c2b0074c3an%40googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/4ca37ac2-a76e-48a5-9e55-6ee50bd8dc1fn%40googlegroups.com.
--
You received this message because you are subscribed to the Google Groups "GAM for Google Workspace" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-man...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/ba03c013-f20c-4a81-aa02-b0a032108952n%40googlegroups.com.
{"requests":
[
{"addProtectedRange":
{"protectedRange":
{"range": {"sheetId": 0, "startColumnIndex": 0, "endColumnIndex": 1},
"editors": {"users": ["us...@domain.com"]}
}
}
},
{"addProtectedRange":
{"protectedRange":
{"range": {"sheetId": 0, "startColumnIndex": 1}
}
}
}
]
}
Again, if you want additional help, contact me directly. We're never going to get what you want via email.
I'm in California (PDT, what time zone are yiu in?
Ross
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/CAMUDA4_U7dW0nB01e%3DUsHw50AOdrzks2%3D1Kx3vHvy_s5WOanqw%40mail.gmail.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/b11c14bc-5e00-411c-ab56-8bcff7399f5dn%40googlegroups.com.