You have several options.
- From a table of imported filePaths, you might be able to use Open Url to open the PDF. A web viewer might even be set up to show the contents of the PDF.
- And a calculation field could be defined that takes the file path in your text field and reconfigures it into the format needed for a container field with "container" selected as the result type.
- You could even move a folder of all your PDF files into your computer's documents folder and use a script that first pulls up a list of all files in the folder and inserts them one at a time into the container field of a series of records that it creates in a table for that purpose. (Get ( DocumentsPathListing) can return a list of all files and folders inside the documents folder.)
- A fourth option is much like the the 3rd, but uses a file manipulation plug in or a system script to get the list of file paths. This can then be done from a folder located anywhere on your computer, not just inside the documents folder.
Are you available to consult? I am familiar with MySQL but a newbie on Filemaker, although I believe it is pretty sleek and has great potential.
I tried to use the Open URL (not familiar with how to run scripts and could not figure out how to do a wild card to get to link to 600 + diff title names) and the calculation field (did not know which calc to select??).
What is the best way for us to connect? Sype, email etc? How do we talk further. Not familiar with using this forum and protocol yet.
I tried to use the Open URL
Are you using Mac or windows? Please note that I said that this might be possible. It works in windows, but others have had trouble using Open URL to open a file.
Basically, in windows, if you can get your web browser to open a file on your computer, the code you see in the URL box at the top of your browser window is the type of text Open URL would need to use to open a file.
And just because Open URL might work, does not mean that it is the best option for what you want to accomplish with your database.
To discuss possible consulting, click the Icon that reads "Caulkins Consulting" and send me a private message.