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/Copy current found set of records (script)

Featured Replies

Dear FM Peoples,

G'day, My name is Dee and I have recently been introduced to the world of FM. I am currently trying to put together a little database and I am having some problems with scripting for copy as. What I want to do in the form of a script is to 'copy as' only the current found set of records from the database. Is there an uber script person out there that will take mercy on me and give me a few script hints to achieve this??

Thanks

If exporting is what you want to do follow this as an example to script:

1. Perform Find (to establish what you want to export)

2. Next you have to create a file to be saved to as well as the format i.e. .txt or .mer or.fp5

3. Export Records (select the Export Order)

Then open up the exported data in whatever format you exported into.

I hope this is what you are asking.

You can also use copy to capture data in the clipboard. Create a layout with the field or fields you want to have copied. Then script stepes for 1) the necessary find, 2) switch to the layout you created, and 3) use the Copy All Records script step. Then you can navigate to wherever you need to go and Paste. It can be into a field, or into another application, or pretty much anywhere you can paste.

Good luck,

Dan

  • 2 weeks later...
  • Author

Thanks for your help fellows. I'm afraid I didn't explain myself very well (typical newbie).

I did however solve the problem by creating a 2nd hidden database. Now I can copy as ' currently browsed records' from my hidden database with one button click from my main database.

Thanks,

Deee

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.