Lucky Posted August 7, 2007 Share Posted August 7, 2007 Hi I need to be able to run a script once a week that performs a search for all outstanding work still out on approval that's more than 60 days old. I then need it to sort by customer and then email that customer just his work in a pdf file. The problem I have is being able to email the individual customers just there work unless I have 60+ scripts running one per customer. We do not always have oustanding work on approval for all customers. Is there a way that the script could seperate the found jobs into customers and then email that customer a pdf show just his work. Peter Link to comment Share on other sites More sharing options...
Vaughan Posted August 7, 2007 Share Posted August 7, 2007 I'd do it from the Customers file: run through each customer record, and use a relationship to "find" the outstanding work records and then do the pdf thing. Link to comment Share on other sites More sharing options...
Lucky Posted August 8, 2007 Author Share Posted August 8, 2007 Hi Thanks for replying I created a script that finds the outstanding work in the customers database as you suggested. For example I have found 12 customers that have outstanding jobs. What I need it to do now is send each customer his layout showing all his work which is in a portal. How can I script FM to send each record to a different email address. In customers I have a field that contains the required email address. Any ideas? Peter Link to comment Share on other sites More sharing options...
Søren Dyhr Posted August 8, 2007 Share Posted August 8, 2007 Go to the related record of the portal, and make a subsummary report, save it as a .pdf ... Since you're on fm7 might this plugin be thriftiest way to accomplish what's posible with more present versions: http://www.schubec.com/en_pdfplugin.php Although a fair dose of shell scripting will make you do it as well, called from Perform Applescript. --sd Link to comment Share on other sites More sharing options...
Lucky Posted August 9, 2007 Author Share Posted August 9, 2007 Thanks for the advice I now have it working just right. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6267 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now