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

Export current record

Featured Replies

I've searched and come up empty....but it seems like it should be easy. I need to export to an xml file, but only the current record. The export (no dialog) script I have now is exporting the first of 54 records no matter which record I am on.

Export (records) always exports the found set. To export 1 record you need to have a found set of 1. There's a few ways to do this. It's also convenient to use a New Window, so you don't mess with the current found set of your records. I suggest this because you say 8 Advanced for this post (please update your profile from 6 if you've updated your app).

Low rent method:

New Window

Show All Records

Omit Record

Show Omitted Only

Export

Close Window (current window)

The reason I say "low rent" is because, in a (very) high-volume situation, another user might create a record in the split second after Show Omitted Only, and it would be added to your found set (since you didn't specifically omit it, FileMaker doesn't want you to feel left out :)-); at least that's my understanding. Unlikely, but possible.

Politically correct method:

New Window

Set global to unique ID

Commit Record

Go To Related Record [ self_global-to-ID::ID, show only related ]

Export

Close Window

Another "politically correct" method (courtesy of -Queue-):

Show All Records

Omit Record

Show Omitted

Loop

Exit Loop If [Get(FoundCount) = 1]

Go to Record/Request/Page [Last]

Omit Record

End Loop

Create an account or sign in to comment

Important Information

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

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.