Update to moved / modified timesheets with better error reporting

coderbunker / gas

G-Suite Google Apps Script (GAS) used with Coderbunker documents

3 stars 0 forks source link

Update to moved / modified timesheets with better error reporting #15

Open rngadam opened 6 years ago

rngadam commented 6 years ago

Since last data update, Leads & Opportunities has been splitted into two spreadsheet (one for Leads, the other Opportunities). Some other formats have been modified to.

Also: Improve error reporting by writing back to the spreadsheet when expectations are not met (timesheet not found, error).

lenzai commented 6 years ago

I fixed the performance issue in the opportunities spreadsheet, with a very tiny timesheetdb that contains 1 record per week. ( a 3rd file timesheet db holds the heavy calculation and acts as a view) We could potentially merged back opportunities and `leads into 1 single file. Although it makes sens to keep leads separate in the long run.

andiechu commented 5 years ago

@rngadam Have you resolved this issue?

andiechu commented 5 years ago

Should be resolved together with #41