Skip to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Loop through records and print

Featured Replies

  • Newbies

Hello! I hope someone can help me, please!

I create benefit statements and I have a fm database containing over 1000 records that I need to save into individual pdf's. I am trying to write a script that will start at the first record, print/save to pdf, then go to the next record, and repeat till the last record. Currently with the script I have it just stays on the first record and never loops to the second. Any ideas on how to fix it.

This is what I have so far:

Goto layout["Statement"]

Go to Record/Request/Page[First]

Loop

Go to Record/Request/Page [Next]

Print[]

Exit Loop if ["Status (CurrentRecordNumber) = 1000"]

End Loop

Thanks Much smile.gif

I think this will work for you:

Enter Browse Mode

Goto layout["Statement"]

Go to Record/Request/Page[First]

Loop

Print[]

Go to Record/Request/Page [Next] [Exit after last]

End Loop

  • Author
  • Newbies

Thanks! It works! But I do have one more question for you.....

When the script is running I don't actually see the records changing, is there anyway I can have fm flip through the records? Reason I am asking is I am saving each file by the persons last name, and if is doesn't flip through each record I have to get the name off another list and run the risk of making an error. Does that make sense?

Thanks again:)

Try using a Refresh Window step before or after the Print step.

  • Author
  • Newbies

YOU ROCK!!! Thanks so much! Have a wonderful thanksgiving smile.gif

Create an account or sign in to comment

Important Information

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

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.