Jump to content
Sign in to follow this  
David Kachlon

fmp17 a beginner...

Recommended Posts

Hi. So, I just downloaded FileMaker pro and I have a few question. Question #1. Is it possible for me to import the contents of a PDF file into a database simply by adding a "button" where the user loads the PDF file from a FileMaker app. Number two, once I have this information, is it possible to add to my PDF file and then save it back as a PDF file. If someone can help me do this on the Trial version, I will certainly buy the full version. Thank you!

Share this post

Link to post
Share on other sites

Hello David

Manipulating PDF's in a sophisticated way is not a standard feature of FileMaker (it is tool for creating business apps based on databases at its core).

However, to your questions :-

1) You can certainly import PDF's into fields in FileMaker. Create a field of type 'Container' in File->Manage->Database->Fields. Create a layout with that field on, and add a button that layout.

Then in 'Button Setup' make that button perform a script, with the script steps

Go to Field [myContainer]
Insert PDF

This will allow the user to select a PDF from their computer or device, and it will be inserted into the field that you specified in line 1.


2) FileMaker can 'Save Records as PDF' (that is a script step), and one of the options is to 'Append to existing PDF'. Therefore, you can export some data from one of your layouts to a PDF already existing on the users computer or device, and FileMaker will add new pages to the end of that PDF, rather than overwrite it.

So if you have a report saved in a container field, and you want to export some more data to extend that PDF report, then you would do something like

// Tell FileMaker where yo would like to store the existing PDF while it is being appended-to
Set Variable [ $path ; Get (DesktopPath) & "fileName.pdf" ]

//Export the existing PDF from the container to the path you defined
Export Field Contents [ myContainer ; "$path" ]

//Go to the layout that generates your report and find the right fields, sorted into the right order
Go To Layout ["myPrintLayout" ]
Perform Find
Sort Records

//Export your records as PDF, but append them to the PDF we exported at the beginning
Save Records as PDF [Append ; "$path" ; Records being browsed]

//Now import the newly extended PDF back into your container
Go to Field [myContainer]
Insert PDF [ "$path" ]

If you want to do more sophisticated PDF editing, you can use the MonkeyBreadSoftware plugin, which has many PDF functions. On a Mac they are easier, on a PC you have to also purchase the PDFKit software to enhance the Windows capability.

Hope this helps.

Share this post

Link to post
Share on other sites

360works has a plugin, Scribe,  that allows you to send and get data from pdfs. However, I am curious about your workflow. Are pdfs part of an old workflow that you'll retire once filemaker is in place?

Share this post

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Similar Content

    • By Tondats
      Hello, good afternoon!
      I'm from the Philippines and I really need help here regarding how to send SMS using Semaphore. Semaphore is an alternative for Twilio. I use Semaphore since this is a SMS Gateway for Philippines and it's every cheap as well.
      Here's is my script using Insert from URL:
      "httppost://api.semaphore.co/api/v4/messages?apikey={{KEY_REDACTED}}" & "&number"=SendMessage::mobileno & "&message"=SendMessage::textmessage When I try to click the "Send" button that I created, it always give me an error (see the image below).
      Hope someone can help me. Thanks!

    • By ChangeAgent
      Is this at all possible?
      I want to have two buttons that will each do the following. 
      Have one button to ‘Strike Thru’ text that is highlighted before.  Means not all the text in the field will be changed.
      And one button to change the text colour to Red, again highlighted before.  Means not all the text in the field will be changed.
      Any tips how to do this?  Please bare in mind I am a FMP beginner.  Thanks. 
    • By lutfishah
      Dear All,
      I am trying to put a conditional formatting validation which turns Red when the value is entered wrong. Basically all my tries have failed so I would like your help here.
      The criteria of entering a value is 
      1. Length of value is  = 19     OR      this should be a 16 digit number, in groups of 4 separated with dashes
      2. Non-Digits characters are not valid.
      Please could you help me with this and I will really appreciate. 
      Many thanks
    • By Koonce
      I have filemaker server on virtual server, I have a script that exports emails and or names i cannot get the file to be saved to the local desktop it tries to save to server with an error when i do manually it works fine so i am doing something wrong...
      Thanks in advance
    • By ThomaStudios
      I have been using FM17Adv for some time.  I am on a MacPro 12-core tower and I had been running macOS Sierra.  All the internal scripts I had in one database worked perfectly.
      I recently updated to High Sierra and now I am getting script errors I don't understand.  And this is from the same exact file I used previously.  I have one script where I want it to open a folder in Dropbox so I can access files there.  But I am getting this error:  Can’t make "Dropbox" into type integer.  Then I get a -1700 error dialog immediately after that.  Can anyone explain how I can fix this.  I have not been able to find anything online.
      The script is a native AppleScript, and I suspect that has something to do with this.  Here is the script:
      tell application "Finder"     activate     open folder " Pieces 2011" of folder "Teaching Material" of folder "Dropbox" of "  ThomaStudios 4TB"     select Finder window 1 set position of Finder window 1 to {2877, 167} end tell
      J D Thomas ThomaStudios
  • Create New...

Important Information

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