Microsoft Office supports “data sources” to accomplish e.g. letters, invoices, abode stickers and added repeating abstracts based on Microsoft Word arrangement and Microsoft Excel data. This is a actual accepted baby business botheration and Office has had a band-aid for it from mid-90s. Google Apps, the billow based another to Microsoft Office, do not action agnate functionality natively (or at atomic if they do they adumbrate it absolutely well). However, you can absolutely calmly actualize your own certificate architect appliance Google Apps scripting as continued as your are accomplished in programming. In this blog cavalcade I’ll appearance an archetype how to actualize such a calligraphy and apprentice the basics of Google Apps Scripts.
We accept afterward the afterward inputs for our business problem
In my case the use case was breeding arrangement texts for the barter based on their amount and affection of annual data. Again I aloof exported and emailed the consistent Google Docs as PDF.
All of these are stored on your Google Apps annual in Google Drive. All alteration happens through Google Apps user interface, no alien accoutrement needed.
Example of antecedent abstracts (obfuscated with obfuscate.js)
Example of the arrangement certificate (obfuscated with obfuscate.js). You can see the antecedent labels, unfilled.
Example of the consistent certificate – labels abounding in and no best in adventurous (obfuscated withobfuscate.js)
Google Apps Scripts can be invoked in two ways
Because we are not alive on the spreadsheet we charge to use the above approach.
The calligraphy is accomplished on the server-side and you accept a non-fancy localized browser based UI to adapt and alter your script.
So my accessory complains include, but are not bound to
Debugger in action
Things could be better, but in the end I managed to get done what I was attractive for and I am still not advantageous a penny for Google Apps, so I am happy. Also, I do not ambition to go aback to Microsoft Office unless I charge to address well-formatted book documents… Google Docs is a toy what comes to abundant and graphically acute certificate assembly like offers…. Or presentations… area Keynote is the king.
In the alpha of the calligraphy you accept constants which ascertain on which abstracts to operate. You could body an user interface authoritative the calligraphy to abounding web application, but this is too bulky admission for such a baby task. The UI architect seemed nice, but absolutely an overkill. Admitting there abide Google Apps Calligraphy API methods for assuming simple prompt() catechism in the browser, for some acumen they were not accurate in standalone scripting… so the fastest admission to access abstracts into the calligraphy was artlessly adapt the calligraphy itself afore anniversary run. I sooo started to absence command line… aboriginal time in my life.
So, in the alpha of the calligraphy you ascertain the antecedent data
Then the calligraphy artlessly replaces words with data. The keyword to be replaced in the arrangement certificate are articular as the cavalcade labels (1st row) in the spreadsheet data. I am appealing abiding there would be added able methods to do this, but I did not ambition to absorb time to go to knee abysmal to GS to amount out its nuances.
And again the script… amuse feel chargeless to adapt to your own needs (generator.gs):
Spreadsheet Invoice Template Google Docs Seven Lessons I’ve Learned From Spreadsheet Invoice Template Google Docs – spreadsheet invoice template google docs
| Encouraged to help my website, within this moment I’m going to teach you in relation to keyword. Now, this is actually the very first picture: