I need a Google Script that extracts all attachments in a Gmail Label into a shared folder Google Drive.
I would like to have the folder to have the following feature:
1) When a PDF file in the folder is opened, I would like the user to be able to type in his name and date he is approving this invoice at the bottom left corner of the opened file, for example: Mark 11/10/17.
The trick is to NOT to have to manually select with mouse the bottom left corner of the opened file and NOT to have to manually create any text boxes. The purpose is to make this process of verifying invoices (name and date) as quick and efficient as possible, as users have to go through 100s of invoices in one sitting.
2) I'd like to have this file automatically moved to another folder once it's verified based on the name written. So, if Mark verifies an invoice (i.e Mark 11/10/17), I'd like that invoice to automatically go to another folder in Drive called "Verified by Mark". We have only a few people verifying, so no need to have a script that adjusts with new names as the names are known and won't change.
3) The invoices can only be deleted by one person. No deletion is allowed for anybody else to avoid losing invoices accidently and having to manually print them.
P.S. Any better ideas will be taken. We use MYOB and we are trying to make the process of verification less time consuming, and paper free to eliminate incidences of loss paperwork.
6 威客就此工作平均出价 $30
i am willing to work on anything right now so much free time i have Relevant Skills and Experience word & excel / web scrapping / form filling... Proposed Milestones $25 AUD - work