Hello!
I have made a macro that fills in my invoices in Pages.
It prompts me with user input and has some if loops for clients included into the macro so I don’t have to fill in address info multiple times.
Essentially it just is a find&replace macro for my template in Pages with a lot of variables.
However, this system is pretty inflexible when invoicing for new clients. I’m wondering if there’s a smarter way to do the same thing or log different clients/ create a basic database outside of the macro. Anyone got any ideas? Attached two screenshots for background.
Would love to hear any ideas!
(I have replaced the address for obvious reasons, but this should make the system more clear; the rest of the macro is essentially based around find&replace and pasting in the variables).

