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.

Guest
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 amerioca
      Hi everybody,
      looks like I do have a sort of rookie problem here. 
      I created a subsummary report which is sorted by a break field and all works fine. All is fine in layout and preview mode. Just in browse mode I seem to have a problem.  There is a large grey empty area just underneath of the subsummary part showing.  Anyone with an idea what it is I messed up here? I already googled but just found 1 similar report from 2010. Sort of optically annoying.
      Any help is highly appreciated.



    • By amerioca
      Hi everyone
      I am working with filemaker on and off for the last recent years but, no doubts about it, I am still a rookie.
      lately I have created a db similar to a booking engine for shore excursions for river cruise ships. Lots of modules, layouts, scripts etc. As I really have to work with my limited knowledge, it took a long time and is not really constructed in a way any pro would do it with a lot of workarounds and probably sort of unorthodox. However, it works just fine for me and I am sort of proud, to have gotten to the point where I am. However, I am afraid, that I corrupted the whole thing somehow.
      No I am trying to integrate a sort of an accounting layout consisting out of a summary or subsummary report. The report contains fields from  4 related tables. and a summary field. The db has some 5 different tables and around 35 different active layouts. First problem is that my subsummary part, which I created with the New Layout/Report assistant, does not show up at all in browse mode. I have tried to base the layout on all 4 tables, but it seems not to be working.
      The second problem is that the summary field is not working and producing some random weired numbers instead of the summary of the field it is assigned to. On the attached pics I have placed the summary field into the bottom in order to demonstrate the results. In every ordinary case it is located in the subsummary part. I have played around here a lot. deleted it, created a new field, created a new layout etc, etc, but it just won't calculate the value of the field it is assinged to.
      Anyone any idea, of what am I doing wrong here? Tnx for any help in advance.
       
       




    • By Caio Euzébio
      Hi Guys,
      There is any script who request user and password of user after click in a button.
      I have a check box in my solution with get username for log register and validation, i want to request user and pass to allow
      user enter this option.
       
      Thanks for all.
    • By Jhon Doe
      Hi, I hope you having a wonderful day,
      Currently I'm traying to create a dashboard with Filemaker, the idea is show several portals and grafics of differnets databases but with specific criterias. The case that i'm trying to resolve is the next one:
      There are three database related, one is for clients, another is the contract of this clients (services) and the last one is client's tickets, so we have the next relationships:
      tickets DB ------ Clients ------ Services  
      (I didn't create that DB distribution). The idea is show in the dashboard which tickets were created for clients who have certain services. The first thing i did was create a self join relationship of  Services to filter those clients who have the services i want to filter, next, i put this relationship into a portal in a layout based on the Services database and it works, but if i put into the portal a field related with the client's name, the portal doesn't match the results of the self join relationship whit the correct client, neither with the tickets that it supposed are related with the results of the self join relationships, how can I created a query in Filemaker taking into account more that one database? I made the  self-join in the manage/database/relationships menu.
    • By samarthmkt
      Hello Friends,
      As such any script which can close the popover portal when a certain field have value ''No'' and if ''Yes'' it remains open. 
       Popover portal is also open by script. Applying the following script steps but not succed
      Thanks

×
×
  • Create New...

Important Information

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