Creating a Google Apps Script which Automatically Executes on Upload -
i have interesting simple problem trying solve @ loss on proper code working correctly.
basically, have old local application running allow me print receipt of transaction. have ability enable receipt printed specific file within specific directory on computer or can set print out automatically printer on computer. print data out file, copy contents of file , paste word document template , manually go through , format data looks clean (i should note data prints out in fixed field format requiring specific font , size pasts correctly. after done email word or pdf document out.
essentially trying here automate method , thought should possible using google apps script.
my thought here should possible to:
- save original files application specific directory on computer
- sync folder google drive
- have google apps script automatically execute upon upload
- have google apps script automatically use specific document template create header/footer , paste contents new file uploaded
- have google apps script pattern match elements within contents of document , format it.
- save document specific location specific file naming convention
- automatically email document doc or pdf based upon specific regex matched field within source document.
could provide specific code example demonstrates how google apps scripts can utilized monitor contents of specific google drive folder trigger event after new file uploaded?
thanks in advance!
Comments
Post a Comment