2 ms·
Use Google Forms and have the result sent to a Google Sheet. Generate the invoice as a Google Doc using Google Apps Script pulling from the Google Sheet. I beli
by paulcole 3y ago
Use Google Forms and have the result sent to a Google Sheet. Generate the invoice as a Google Doc using Google Apps Script pulling from the Google Sheet. I believe GAS will let you turn that Google Doc into a PDF and attach it to an email draft in the office person’s inbox.
If somebody needs to edit something, let them edit the Google Doc and build a Google Docs extension that gives them a little button that lets them regenerate the PDF. Or they can just save it from the Google Doc themselves.
https://www.google.com/script/start/ https://www.google.com/script/start/
The documentation is quite good.