Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 5998 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

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!

Posted

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

Posted

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.

Posted (edited)

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
Posted

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

Posted

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.

Posted

The way to "select" the current record is:

Show All Records

Omit Record

Show Only Omitted

Posted (edited)

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
Posted

"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!

Posted

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.

Posted

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

Posted

"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.

Posted (edited)

...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
Posted

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

Yes, it is.

This topic is 5998 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

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