Applescript for Numbers to PDF on Invoice

Question

Level 1

8 points

Applescript for Numbers to PDF on Invoice

I have an invoice template that I use on Excel but I want to migrate it over to Numbers if possible. I'm struggling with transferring the Macros to an Applescript format, that I believe Numbers requires?

Currently the Macros I use have the following purposes:

To save the template as a PDF & naming the file based on company name (A12) and invoice number (D12).
To clear the enquiry data (Cells A12, A14 & A19 to D34) and incrementally increase the invoice number by 1 after each save (Cell D12).
The PDF file also needs to save to the same network folder location each time.

The only formulas within the spreadsheet are for today's date under "Date", a sum formula for both totals and a simple 20% formula for the VAT (tax).

Can anyone shed light on how best to write this? (screenshot of current template below)

For reference

iMac Line (2012 and Later)

Posted on Apr 26, 2021 6:43 AM

Reply

Answer 1

SGIII

Level 8

38,148 points

Apr 26, 2021 8:05 AM in response to Incognito_13

Scripting this is possible but sounds complicated to me! It may not be worth the effort.

If you already have a working solution in Excel, my recommendation would be to stick with Excel, especially if your business depends on it.

SG

Reply

Answer 2

Incognito_13 Author

Level 1

8 points

Apr 26, 2021 8:07 AM in response to SGIII

That was where I was leaning too. Only issue is that the newer versions of Office for Mac don't allow for automatic saving to a network folder, from what I can tell, so I'm left using the 2011 version at the moment.

Reply

Answer 3

SGIII

Level 8

38,148 points

Apr 26, 2021 8:25 AM in response to Incognito_13

Incognito_13 wrote:

ewer versions of Office for Mac don't allow for automatic saving to a network folder, from what I can tell, so I'm left using the 2011 version at the moment.

That's a tough choice. 2011 Office for Mac is not nearly as good as current versions. If you can't use OneDrive can you live with turning off Auto Save?

SG

Reply

Answer 4

Incognito_13 Author

Level 1

8 points

Apr 26, 2021 8:28 AM in response to SGIII

With the volume of quotes we typically do (shared between 2 people also), I think it's crucial to keep the auto save and auto-naming aspects. For now I may just have to endure!

Reply

Applescript for Numbers to PDF on Invoice

Similar questions