Since you get the data you need to construct the file name, this should be possible.
You can use Set variable to set a variable to the file path to the PDF file. This would be both the file name and the directories that enclose it. Then Insert File, Insert PDF or Insert Picture could use that path to insert the file into a container field.
Can you help me with this a bit more. I am new and i have been trying
to figure this out. I understand the basic concept you are saying. I
have gone on youtube to try and find videos. But I am unable to get it
The order id number would be 201412345, the pdf file name that I want to
insert into the container file would be DN_201412345.pdf.
I store the pdf files in a dropbox folder on the desktop of one the
So using the GET command, I would first go the the location of the PDF
file (Windows 7 machine) on the windows machine.
How would I insert file name so it can be find the correct file in the
Once the correct file is found it would be inserted into the container
field for that record.
And what is the path to that drop box folder?
You need to know that before you can combine that with your file's name To get the file path.
How are you importing the CSV file? Since it's located in the same folder, that may be a way to produce the needed file path.
First insert the PDF into a global container field. Use getcontainerattributes to put the file name into a variable.
Use secret FileMaker techniques to get the id number from the file name and find the proper record.
Set that records container field to the global container field contents, your pdf.
Really easy, no?