I am working on a reporting system with FM Pro 12, where users keys in data, and a report is generated in pdf and sent as an attachment to specific people defined by a distribution list through email. Due to the size of the pdfs (as it includes photos) mailboxes are getting filled up quickly.
Working on an alternative where, instead or emailing out with attachment, im trying to write a script to store these reports into specific folders within google drive,depending on the report type. After which and email will be sent out to those in the distribution list, with a URL link to view the reports stored in google drive.
Do you think this is achievable ?
I have found threads online to look further into these 2 URLs.
After reading these 2 sites, I still dont have a clue how to start.
Any help or pointers would be greatly appreciated.