


This application allows you to set permission to folders. Iobit Protected Folder is a software that provides the security of files and directories. It offers a 2-way encryption method for security.Passwords can be easily set to external drive or USB.What I have tried is to implement my own following locking mechanism using a dedicated cell of the spreadsheet containing a semaphore value using the following logic but it's error prone to implement and use, not totally reliable in locking and I assume also slow considering the extra reading and writing of spreadsheet cells: Script S1 (and similarly for scripts S2, S3. Another thing is that it leads to a need of special shared storage of finer "sublocks" in case one doesn't want to settle with using really just one global lock for the entire time of all the critical sections - that gets complicated and slow. In the worst case this might be used but it solves only the special case when all the scripts are run by the same user. GetUserLock() Gets a lock that prevents the current user from concurrently running a section of code. Mutiple script files are running their own code so this doesn't help either. GetScriptLock() Gets a lock that prevents any user from concurrently running a section of code.

This one looks pretty close but it gets a lock of the "current" document which doesn't make sense with standalone scripts and doesn't allow an arbitrary document to be specified. GetDocumentLock() Gets a lock that prevents any user of the current document from concurrently running a section of code. Thinking in terms of Java-like locking using an arbitrary object, locking using the object of the Spreadsheet being modified would be sufficient.Ĭlass LockService seems to lack that option, as there are just these three: I need a lock that would enable me to sync code from all those Apps Script files. I have a Spreadsheet modified by code from two or more standalone Apps Script files.
