1 Reply Latest reply: Jan 29, 2014 10:44 PM by Barry
AVGeek94 Level 1 Level 1 (0 points)

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)
  • Barry Level 7 Level 7 (29,210 points)

    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