Jump to content

Export/Copy current found set of records (script)


Deee

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

Recommended Posts

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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

Link to comment
Share on other sites

  • 2 weeks later...

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

Link to comment
Share on other sites

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