datalink Posted October 26, 2016 Posted October 26, 2016 Through a scripted routine a client system generates a new contract and exports as a pdf as a temporary file (Get(TemporaryPath). It then creates an invoice, exports as PDF and appends this to the contract and finally it sends the whole pdf out via email. This year the client would like to have a sales related pdf that is not generated in Filemaker be the first document in the process, appending the contract to that PDF and finally the invoice to that, so that the client receives one pdf that first has the sales piece, with the contract appended and finally the invoice appended. This all happens in a looping routine, moving on to the next client contract after the first one is sent. The issue is that FMP modifies the first PDF by appending to it. Subsequent contracts are appended onto the same file so the second customer gets the first customer's contract and invoice as well. Is there a way to do this without having an ever increasing document? Thanks in advance for any suggestions.
comment Posted October 26, 2016 Posted October 26, 2016 Obviously you need a fresh copy of the "sales related pdf that is not generated in Filemaker" for each customer. You did not say where it comes from, so I am not sure what to suggest next. 1
datalink Posted October 26, 2016 Author Posted October 26, 2016 The salesy document is a polished document that is produced by their marketing department. If it were a simpler document I would implement it in Filemaker and start there, but its richness makes it seem ill-suited to Filemaker. I suppose that I could do that if another method isn't an option. My attempted solution was to just put the file on the desktop of the machine that sends the contracts and coded Save as PFD script step to append to that PDF. Thanks for your thoughts on this. I appreciate it.
comment Posted October 27, 2016 Posted October 27, 2016 (edited) 7 hours ago, datalink said: My attempted solution was to just put the file on the desktop of the machine that sends the contracts and coded Save as PFD script step to append to that PDF. You should insert the file into a container field (say in a one-record Preferences table). Then have your script export the file to a known location, append the contract and the invoices of one client to it, send the resulting file and repeat. Test this to see if pauses are required so that you do not overwrite the resulting file before it is sent. Edited October 27, 2016 by comment
datalink Posted October 27, 2016 Author Posted October 27, 2016 This was a great suggestion. I exported to the temporary path and appended the additional documents to it. A great suggestion. Thank you so much!
Recommended Posts
This topic is 2948 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