Write a script that fills the table with data from another spreadsheet, Google App Script, Excel
You need to form a report card at the click of the button based on the unloading data. and save the Google report card with a specific name.
There is a FILE FROM 1C (attached file unloading.hl)
There is a SAGE sheet (what the final file should look like) (docs.google.com/spreadshe...)
There is a list of ANSWERS (where people contribute data)
There is a TABEL (formed file)
In unloading for one month for each group there is a list of the name and the mark of the visit by dates (n - absence, in - a day off).
In Google table ANSWERS make line data - name, group number and time period (start date and date of end), during which you need to put in the Table to put "N(n)" if the gap falls at least one day in a given month, for which the Report is formed (if the unloading on these dates is "in, then leave "in"). And on other days, if there is a "n" in the Unloading, then indicate in the Table "N(o)".
accordingly, when you press the "fill the report card" button, it should be:
there is a window in which you can select the Unload file, auxiliary fields are possible (for example, choose a month, select a group, but this data is in the Unloading), the Button Ok and Cancel.
Clicked on the Ok formed Table on the basis of The Template and Unloading - all data on the fio from the unloading should be in the Tablet, all the data on the dates of the visit changed - "n" from the discharge became "H(o)" or "N(n)" in the Table on the basis of Answers (if the period of time from the Answers of this name and group falls at least one day in the month "in" remained "in."
After the table is formed, the report is stored on Google disk in the folder "Formed" under the name "table number of the group".
22.12.2020 11:41