What are you trying to achieve?
I want to create a daily report from Modnay.com to Google Sheets which contains this outputs structured this way (explained below).
For each Optik, write one row with:
- date (today)
- optik (name)
- countZapisG = number of records from yesterday
- countZapisR = number of records older than 7 days
- countKlient = total records for that Optik
- avgZapis = (leave empty for now)
- redKlientNames = client names older than 7 days, comma-separated
Steps taken so far
I have created example data structure as is in Monday to test it and save operations, but I can not figure it out how to exactly map data so they belong to right Optik and pasted in Google Sheets in bulk, so I can save operation.
I would really appreciate any help, because I am cooked right now with this.
Thank you all in advance!
