Jump to content
Sign in to follow this  
noiseordinance

PDF Printing

Recommended Posts

Ok, I'm not super Filemaker savvy so forgive me if this is a dumb question. If I search for a record in Filemaker and it pulls up 7 records, and I need record 6 of 7 and I attempt to save that record as a .pdf (File > Save/Send Records As > pdf) it converts record 1 instead of record 6. Is there anything we can do to fix this? It does it on all workstations.

Thanks!

Share this post


Link to post
Share on other sites

Did you choose the "current record" option in the save dialog? Are you looking at a form or a list view?

Share this post


Link to post
Share on other sites

either turn on the 'current record' option in the print dialog or omit the record(s) you don't want to print with cmd-T.

Share this post


Link to post
Share on other sites

So CMD+T narrows it down to only the visible record? Is that correct? Also, what would the Windows equivalent to that command be? Thanks a ton for the help...

Share this post


Link to post
Share on other sites

Also, if I understand correctly, the cmd button is the open apple, yes? I'm not too Mac savvy. When we hit open-apple+T, it omits only the visible record...

Share this post


Link to post
Share on other sites

No Cmd-T or Ctrl-T is the keyboard shortcut to omit the current record. You can also omit multiple records.

You can print just the current record as Tom said.

* Edit P.S. I would LOVE a isolate record step...

Edited by Guest
Added PS

Share this post


Link to post
Share on other sites

Okay, sorry, you'll have to excuse me, I'm a little out of it this morning. You were saying to omit records with the cmd-T button. So, since a searchcan often pull up many results, what is the other method you mentioned? You were talking about something in the print dialogue...

Thanks again

Share this post


Link to post
Share on other sites

Somewhere in the print dialog (different for Mac and Windows, may be tab/submenu) are "FileMaker" options. There is "Records being browsed" and "Current record"; you want the later.

Share this post


Link to post
Share on other sites

The way to "select" the current record is:

Show All Records

Omit Record

Show Only Omitted

Share this post


Link to post
Share on other sites

Hi there, Vaughan!! :laugh2:

I see this suggested time and again on FM Forums and Cafe'. But it can break in multi-user if another User creates a new record after the Omit Record and before the Show Omitted Only. Rare, one might say? Not really, if there are many Users creating continual new records. And if it breaks, it can be very bad.

It has been discussed in great length and I believe the best script to use would be one which tested for only one record before continuing. Here is one by -Queue- which fits the requirement quite nicely, I think:

Freeze Window

Show All Records

Omit Record

Show Omitted Only

Loop

Exit Loop If [ Get ( FoundCount ) = 1

Go To Record/Request/Page [ Last ]

Omit Record

End Loop

UPDATE: Upon re-read of the entire thread, printing 'current record' seems more straightforward!

LaRetta

Edited by Guest
Added update

Share this post


Link to post
Share on other sites

"UPDATE: Upon re-read of the entire thread, printing 'current record' seems more straightforward!"

Yes it does, but there is still the problem that preview mode shows all records in the current found set.

Thanks LaRetta (and ~Queue~) for the tip. Gotta watch those multi-user gotchas!

Share this post


Link to post
Share on other sites

Let's be clear: the question was not about printing, it was about Save/Send Records As PDF.

If for some reason the "current record" option is not sufficient and you do want to isolate one record, the way I generally do it is to simply search on the ID field (assuming you have one - if not, you should). This can be scripted like so:

Set Variable( $id ; ID )

Enter Find Mode

Set Field( ID ; $id )

Perform Find

I'm not clear on whether you need to retain your original found set here. If so, let us know.

Share this post


Link to post
Share on other sites

For most of my own databases, I find it very handy to put a simple little checkbox or radio button field somewhere on the layout that I call "Tag". When I find myself browsing around for certain records I want to do something with (like printing an odd group of mailing labels) I click the Tag button and then just do a find for them when I'm ready. Then I clear the Tag field by doing an empty global replace when I'm done. (Or have a little "clear tag" button next to it). Works for a single record too. I know that doesn't help with the scripting scenarios but is real handy in day-to-day use.

Wickerman

Share this post


Link to post
Share on other sites

"For most of my own databases, I find it very handy to put a simple little checkbox or radio button field somewhere on the layout that I call "Tag". When I find myself browsing around for certain records I want to do something with (like printing an odd group of mailing labels) I click the Tag button and then just do a find for them when I'm ready. Then I clear the Tag field by doing an empty global replace when I'm done."

Think about how this will work in a multiple-user scenario, when more one user is "tagging" the records while another is simultaneously clearing the tag field...

... and compare it with a process whereby the records are "marked" by putting their record ids, paragraph-delimited, into a global field and using a self-join relationship to "find" them again with the GTRR script step.

Share this post


Link to post
Share on other sites

...and you do want to isolate one record, the way I generally do it is to simply search on the ID field

Why would you bother searching for a record you have already found, Tom? You are sitting on the one you want; a search again for it, simply to isolate it in a found set seems a waste of time particularly as the number of records grows. Isolating one record out of many is rather easy and very fast. :wink2:

But you bring up a point. The omit record method will not work if you want to preserve your found set. So you would want to open a new window and run the script from there. Then just close the window when done and you will again have your original found set.

LaRetta

Edited by Guest
Added sentence

Share this post


Link to post
Share on other sites

Isolating one record out of many is rather easy and very fast.

Yes, it is.

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  

×
×
  • Create New...

Important Information

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