Developed by Google script

Good afternoon and happy holidays, dear developers!

I describe my task:
On a daily basis, the project is managed by GoogleLablic.
There are several products in the project and for each of the products there are several types of work.

Google tables have the following structure:

date statustextschotted by employeeThe number of lines in the tables cannot be determined because the tables are maintained based on the daily situation.

At the same time, for each of the products for each type of work, there is a planned weekly volume, less than which the performers should not perform.

In a separate Google Table there are sheets broken down by products. The structure of the tables in them is as follows:

Type of work, week 1, planned volume, actual volume, % of completion. Then Week 2 and so on for a whole block.

Task:

Write a Google script that:

It will copy from all the tables of daily work into one Google book - this is necessary so that the client can at any time look at what is being done there, but does not go through a bunch of tables of performersFrom these data to update daily how much was done this week - substituting summarized values for the product and type of work in the plan / fact. Give a daily summary for me of how the performers perform everything on all products and types of work, what deviation from the current weeks plan and what deviation from the plan cumulatively.

Next, Im looking for performers for some low-code solution to transfer this all and much more to the web interface (of those studied so far the closest in terms of data structure - appsheet and ninox, but we will think)


The current task is urgent. A big request to respond to those who can take it on, without delay.