14. Google Sheet in Hindi | Absolute & Relative Reference | Lock Rows, Lock Columns, Lock Ranges etc

[@shanesharma3195]

Clear explanation thanks🙏

[@rahulthementor4846]

Thanks

[@kanhaiyalal5558]

It was new for me. Thanks for covering this topic

[@rahulthementor4846]

Glad it was helpful!

[@Motivationalvines.01]

"recently found your channel, and was regretting why I've not seen your video before. Highly blessed with this wonderful content of yours😇😇😇💖"

[@rahulthementor4846]

Thanks. Keep supporting and keep sharing

[@umasharma6615]

Good learning

[@rahulthementor4846]

Thanks for liking

[@inderdelhi]

Kya aap FMS, PMS, IMS bhi bta sakte ho kaise create kiya jata hai, mujhe google sheets automation sikhna hai

[@rahulthementor4846]

Will do it further but pls check my all videos. It will also help you in creating fms

[@vernavong]

Hello , I want to share to my collaborator and after they entering the data for 1 hour, that row will be Lock automatic , would you please write script for us please !

[@rahulthementor4846]

What kind of data you have? If you have some limited columns then you may use google form and share the link with collaborator for data entry purpose and you will find all entries with correct timestamp. Secondly, pls do not share master sheet just import the data from master with limited time frame. Let me know if it fine for you.

[@vernavong]

@@rahulthementor4846 I am not prefer google form

[@rahulthementor4846]

@@vernavong There are multiple way to do this task but you are not willing to work in google form. I am giving you small idea hope you were asking the same thing. please copy and paste code in script editor of sheet which you want to lock. function prtect() { var sheet = SpreadsheetApp.getActive().getSheetByName("Sheet22"); sheet.protect(); } Instead of Sheet22 you will have to put the sheet name there or you may rename your sheet to Sheet22. After that you will have to set up time trigger on the basis of your requirement. However i have not start app script but for your requirement small code for you.

[@vernavong]

@@rahulthementor4846 I tried what you suggested, by copying this code and paste to the script editor with changing sheet to "sheet22". After that add trigger , select event source = Time-driven , select type of time base on trigger and select minute ! but when i share to my collaborator after he add for few minutes lather he can edit again ! It doesn't work

[@rahulthementor4846]

@@vernavong I personally tested and tried before sharing to you. Right click on tab and checked is there protection added or not. Secondly, before sharing this sheet to collaborator you must set up all configuration. You might have already given edit permission to collaborator. If you still feel issue share file with me.