Jump to content

pass or export fields to other programs?


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

Recommended Posts

  • Newbies

Is there a way to pass certain field information to another program without having to export the information in FMPRO first?

Currently I have a script that exports the info I need to a data file, then I have FMPRO run a perl script which retrieves the data and does what I need for it to do (actually it then creats a batch file, which FMPRO then runs as the third step).

The problem is that when I put this ALL in one script (activated by a button), I think when script is run and FMPRO exports the data my perl script is run at the same time, thus the data file (the exported file) isn't created yet....so I have to run the script again to get the data from the previous run. I could probably do some type of delay, but I was hoping there is something simpler?!?

Is there an easy way to use *send mail* or some other script function and pass along parameters based on my filemaker pro fields?

I'm sure there is an easy solution to this, I just can't seem to find it.

thanks,

David H.

Link to comment
Share on other sites

  • Newbies

ok thanks. I think I found a workaround by doing just that (looping until file is made).

one more quickie. When I perform a find/search in FMPRO and it pulls up X matches, how do I just select the current record I am viewing only, so that the other 29 records won't export along with my *export script*?

is there a way to do this in the script dialog?

thanks again.

David H.

[This message has been edited by David H (edited February 20, 2001).]

Link to comment
Share on other sites

To isolate the current record in a found set, I would use a relationship. Create a global field (number is fine) gRecord. Give each record an auto entered serial number field called SerialNo. Create a self relationship between gRecord <--> SerialNo.(call it SelfBySerial). Then the script to isolate the current record in a found set is:

Set Field (gRecord, SerialNo.)

Go to Related Record (SelfBySerial, Show only related records)

-bd

Link to comment
Share on other sites

This topic is 7837 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
 Share

×
×
  • Create New...

Important Information

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