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

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

Recommended Posts

Posted

I have two layouts; Show day and Off Day.

I want to do a date range lookup which mixes Show and Off days. Each record has a Show/Off Day field.

Then I want to print these dates, in date order and to the correct layout, as a single PDF file. IE; as a tour book.

Is there a script step step to accomplish this?

The reason for this is that the layouts are written using Merge Fields and each field has a label. The example below is a Show Day layout. On the Off Day layout, the Venue and Promoter Sections disappear and are replaced by an "Off Day" image.

Many, many thanks for your help.

post-102845-0-81389400-1322836281_thumb.

Posted

You could find the records you want to include, sort them by date, then save the first record as PDF. Next, loop through the remaining records, appending each one to the same PDF. Switch to the appropriate layout for each record.

Posted

Thanks Comment.

I tried what you suggested but it was taking forever to do just 24 records and the append to PDF 'perform without dialog' wasn't working. I had to select the append button for each record. Each addition was taking about twice as long as the record before it. A 12 or 14 week tour could take hours to print.

In my mind, which is severely limited by the way, the scripts below should work but they don't. Maybe you can tell me why. Also I would also like to add a step that enters the preview mode so the user can proof read the entire document before submitting it for printing.

The problem is that every record is going to the same layout. In this case it's the 'Show Day' layout. if I reverse the ChooseLayout script so that the 'Off Day' step is first in the steps then every record prints to the Off Day layout.

Thank you so, so much...

post-102845-0-29821000-1323000932_thumb.

Posted

What I meant would be more like:

# FIND & SORT

Go to Record [ First ]

Set Variable [ $PDFpath ; Get ( DesktopPath ) & "Report.pdf" ]

Loop

 Perform Script [ Choose Layout ]

 If [ Get ( RecordNumber ) = 1 ]

  Save Records as PDF [ Restore; No dialog; “$PDFpath”; Current record ]

 Else

  Save Records as PDF [ Restore; Append; No dialog; “$PDFpath”; Current record ]

 End If

 Go to Record [ Next; Exit after last ]

End Loop

I have tried this, and it does take some time (though I don't think it would be hours).

Also I would also like to add a step that enters the preview mode so the user can proof read the entire document before submitting it for printing.

I don't think that's possible.

Perhaps it would be better to have a single layout, with some conditional formatting?

Posted

Conditional formatting would be great but since one of my clients uses FMP8, even the append script you wrote won't work. It does work perfectly though on my machine and I appreciate it very much.

Perhaps he is going to have to break down and upgrade.

This topic is 4738 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.