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.

Looping record exports

Featured Replies

I have a number of found records and I am needing to create a single tab delimited file for each. I've already got the path and the $fileName set.

FileMaker apparently exports all the records in the found set- so I will need to be able to script a find of records which have not been marked as "exported" then somehow loop a script which will step through finding, exporting, and marking each record one at a time.

I'm stumped. Any help or a point in the right direction would be greatly appreciated.

So you want to export each record separately?

Why not make a calc field to concatenate the fields, then use the Export Field command.

Or:

http://www.fmforums.com/forum/showpost.php?post/279964/

See also:

http://my.advisor.com/doc/18846

http://www.fmforums.com/forum/showpost.php?post/293603/

http://www.fmforums.com/forum/showtopic.php?tid/184454/

---

keyword: isolate record

Why not make a calc field to concatenate the fields, then use the Export Field command.

I agree.

First, I'd add 2 fields:

Exported (text field with say an "X" in records that have been exported already) and

Exported Calc (calculation field as mentioned above)

Next, Decide on a sort field.

(quick version I have to go...)

Then script something like this,

Find records where Exported is empty

Sort

Go to record first

Loop

Export field contents

Insert text "X" into Exported

Go to record next exit after last

End loop

May have left something out but gotta run for now...

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.