Jump to content

Outstanding Work


This topic is 6160 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

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

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

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

This topic is 6160 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.