Google Script - Automatic Invoice Numbering
Another foray into creating a script to help make a process more efficient. We had a program that spent a LOT of time with the invoicing process. They were hoping that they could use a Google form to gather information for invoices, then use the Add-on Autocrat to create the invoice which could then be shared with appropriate parties. The problem was that each invoice needed to be assigned a unique number. Enter a script to add to the spreadsheet. After creating it, I realized that this simple script could be used in a variety of ways so thought I'd share (I've already used it for two other applications!). 1. Create your form to collect the data (not covering this here - I am assuming you know how to create a Google Form) 2. In the result page, select to create spreadsheet so you can view the data in a spreadsheet 3. Go to the Tools Menu and open the Script editor 4. Delete out the default text Replace with this script (all in highlighted gray including...