dwyl Invoicing: bugs & fixes

[rub1e]

Freelancer invoicing at dwyl is done through a google form which is saved to a spreadsheet, converted into a PDF, and sent to the freelancer and Xero

Currently known bugs are:

• 423 - multiple emails generated

  • FIX: just ignoring it seems to work; DO NOT act on emails from Autocrat saying you need to give it permission to run - that's the problem!
• All the rows have disappeared 😱
  • FIX: this is probably because the sheets have become unlinked somehow. For some reason, 300 rows were also hidden. So to fix:
  • unhide all the rows; find the first empty cell (probably A2);
  • there should be a button saying something like "Give permission to link sheets" (I stupidly didn't take a screenshot); press it!
  • Don't touch the spreadsheet for a few minutes as it takes a while to re-populate the sheet
  • Once it's done and all the rows are back, go to Add-ons > Autocrat > Open and press the play button to run the job. And then everyone receives their invoices 😄

[iteles]

@rub1e From point 2, it sounds like we need to regularly back up data until we build something better!

[rub1e]

Actually, we're ok on that one - all the PDFs are sent to Google Drive so they're all backed up automatically

And the rows weren't actually deleted - it just looked that way because the cells were empty, which in turn was because they were trying to compute formulae without the data (which was just on another sheet)

Basically, we cool!