restrict other users from modifying others data in google sheet

[Getnet Demil]

hello, I have created a google sheet of 6 users shared in editor permission to the sheet.

each users input their own data and they only can modify it later.

But I want to restrict other users from modifying other's data in google Sheets?

I don't want others can change someone data

so if anyone with the app script code to restrict modifying  others data, please help me?????????

[Brian Pugh]

You can set the permissions on each tab so that only you and each user can edit that tab.

Brian Pugh, IT/Educational Technologies Associated Hebrew Schools | Danilack Middle School p: 416.494.7666, | e: bp...@ahschools.com w: www.associatedhebrewschools.com 252 Finch Ave W., Toronto, ON M2R 1M9

This email is confidential and is intended for the above-named recipient(s) only. If you are not the intended recipient, please delete this email from your system. Any unauthorized use or disclosure of this email is prohibited.

--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/80fa4e0b-5d1a-40bd-912a-75213aa34265n%40googlegroups.com.

[Getnet Demil]

I dont get you.

You received this message because you are subscribed to a topic in the Google Groups "Google Apps Script Community" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/google-apps-script-community/um6fbucdf4c/unsubscribe.
To unsubscribe from this group and all its topics, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/CAJBn2DQL8umossuuZHu3OwRYYOHOSTuZevmwv4ES8FCj53iK%2BQ%40mail.gmail.com.

[Jonathan Butler]

Go to the arrow at the bottom of the screen and hit protect sheet. Then restrict the range to custom. Add the person you want to edit that particular sheet.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/CAB04-Y3rLPSGuhy-TbWc%2Bo02%2B%2BXPZV-YmGJzGBRgCC9%3D02fdsw%40mail.gmail.com.

[Getnet Demil]

I want to restrict within the same sheet 

when someone types for the first time 

the system will automatically identify him 

and will only allow him to modify. 

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/CAE9k5yBjuU92AuH_f1QCRSkgcRLy%3DPqtwaxpYfvP4p2Tdx8Euw%40mail.gmail.com.

[אוריאל בלמס‎]

היי 

במענה לשאלתך..

אין לי ידע מקצועי בעניין הזה..

אך מהתכתבויות של אחרים שראיתי במקרים דומים ...  נראה שבאמצעות "סקריפט" לא שייך להגביל את שם המשתמש הנוכחי.

ראה התכתבות בקישור להלן:

https://stackoverflow.com/questions/38624196/how-to-lock-a-sheet-for-current-user-with-google-script

וכן בקישור להלן:

https://stackoverflow.com/questions/45622778/google-sheets-use-script-to-prevent-edits-from-current-user

באם בכל זאת מצאת פיתרון בעניין הזה אשמח להתעדכן...

בברכה

אוריאל

ב-יום שני, 16 במאי 2022 בשעה 16:11:50 UTC+3, getn...@gmail.com כתב/ה:

[Getnet Demil]

still no one answered my question

I want to restrict modifying the inputs based on who first ytped the data.

that means if I first type in the row then I only will modify it.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/bc2e2671-24cb-43b8-a361-4ee3051e8bf6n%40googlegroups.com.