Writing a few Google Apps Script/JavaScript

Budget: 1600 UAH Deadline: 1 day

I welcome.I have a very rich experience with Google’s ecosystem in general and Apps Script in particular.The complexity of projects - up to corporate tools for several hundred users.The tasks:
1) there may be nuances associated with the running scripts, and more precisely with the actions of these scripts (they may require the script to be authorized, which is not available in Simple Triggers.And to track the tab can only be the "Selection change" trigger, which can only be Simple).So there’s a moment with the “Selection change” trigger – if the user is “moving” too quickly, then some events can be missed and not reacted.But often you can find a crossroads path, everything depends on the details of the task.2) there are also nuances with authorization and users.The document itself cannot install the trigger without a "call" from the user.It is possible from the "main" to set the trigger in the new document, but there are nuances regarding whose face the trigger will be launched.As in the previous task, everything depends greatly on the details.3) There is a demonstration of the problem.I prefer permanent cooperation.The fee is $20 / hour
2 hours of work.It is very likely that these 3 tasks in these 2 hours will enter, but the devil lies in details.