Print current record from a found set

[SueP]

What script would I use to print the record being viewed. This record would be in a found set and the print page would be a different layout than the one used to select the record. I would like the print command to execute automatically without dialog and it would need to be cross-platform.

This seems so simple but I just can't seem to get the script to work!

[RalphL]

If you are a single user you can use the following script steps:

Show all records

Omit record

Find omitted.

In a multi user make a self relationship based on the record id (serial number) and use go to relared record show on related.

[Lee Smith]

Hi Sue,

Here is how I would do it.

FileMaker will remember the last performed Print that you do. So First perform a Print of a current record in the file where you are going to print from. Then immediately create a Script using the script step "Print" in a script.

Print [No dialog]

To go from one layout to a different layout to print, you need to add the Go To Layouts steps in your script like this:

Go to Layout [

[SueP]

Thanks Lee and Ralph - Actually I was asking for how to select and print a current record in a round about way and I should have given all the detail. I kind of figured out how to print the record being viewed but what I really needed to do was to return to that same record after it was printed. I thought perhaps there was a Filemaker command that would just select the one record for printing like using StatusCurrent...something.

I'll give more detail...

The project is a registry of historic houses in my town which I plan on putting this on CD or the internet at some point. It will be used cross-platform by people who will have no earthly idea as to what Filemaker is. I plan on making it dummy-proof.

The scenario that I'm stumped over is this... I have a layout that has streets on it. When the viewer clicks on a particular street, the program does a find of all houses on that street and goes to another layout. This new layout shows a picture of each house with descriptive text. A person can use a forward and back button to do a "Virtual Walking Tour" of each house on the street. If a person wants to print information about a particular home, I want them to click a print button that goes to a different layout, print the current record that was being viewed, then return to the previous layout with that record still being the one shown - still in the found group of records of that street. I tried the following script which works... but it always goes back to the first record of the found set - not the one that was just printed.

- COPY Record Number (copies the number of the current record viewed)

- MODIFY LAST FIND

- PASTE Record Number

- PERFORM FIND

- GO TO LAYOUT Print Individual House (prints the record being viewed)

- PRINT

- GO TO LAYOUT Original

- MODIFY LAST FIND

- CLEAR Record Number

- PERFORM FIND

Hmmm, any other ideas? I've never used the "status" formulas but it seems like perhaps that might be the solution? Thanks again and sorry I didn't give enough detail.

[-Queue-]

There should be no need to isolate the current record. Just do what Lee said. The 'print current record' option will do the work for you.

[SueP]

Hmm, well let me tell you something that I didn't tell you before. I also have another layout that prints a list of houses (with thumbnails and text) based on the search criteria. Hmmmm.... any other ideas? Are there any formulas? Functions? My main concern is returning back to the same record after the record prints in another layout...

[-Queue-]

You can set the current record's serial in a global, create a relationship from that global to the serial field, and when you want to return to that record Go to Related Record [relationship]. Add 'Show only related' if you want the record to be the only one in the resulting found set.

[SueP]

Will this still have my found set but simply bring the record selected to the screen when I return to the previous layout?

[-Queue-]

If you don't select 'Show only related', yes.

[SueP]

Terrific! Thanks so much... I knew it just had to be a simple thing. I was just making it too complicated.

Thanks, Sue