I use Numbers to generate invoices for freelance work. I have the form I use saved as a template, but I wonder if there is a way to have the template automatically change the invoice number when I open it? This is in Numbers 09.
MacBook Pro, OS X Mountain Lion (10.8.2)
Not within Numbers.
Possible with an AppleScript, may be possible with Automator. The script could run through these steps:
Open the template
Read the value in the cell containing the invoice number,
Add one to the value.
Insert the changed value in the same cell.
Save the result as a Template (using the same name)
Say 'yes' to the alert that warns the template already exists and asks it you want to overwrite it.
Opens the Save dialogue with "Invoice "and the current number inserted, and stops.
You then enter the customer name and click Save.
Translating that to a script is outside my knowledge area, but there are others here who might find it a good starting point.
Regards,
Barry
Numbers used to create invoice, automatically increase invoice number in template?
