Jump to content

Find Record


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

Recommended Posts

I want to find a record in my filemaker database Which has about 5 forms in it.

The name of the Database is FMTEST and the form I want to do the Find is NEWFORM. The field is Called NAME in the fm database that I want to enter my param1 into and then find the record. Then after that record is found then Return the values in these two other fields as strings

2nd step is to return the text that is in Field "PHONE" as X

and Field "CITY" as Y

On run (param1)

tell Database "FMTEST" of app "Filemaker Pro"

Find Record

Set cell "NAME" of Find record to param1

End tell

End run

Link to comment
Share on other sites

Hi, i'm not really an AppleScript wizz, but this has been working for me:

To perform a find and get some info in:

tell application "FileMaker Pro"

show (every record of database "mydatabse" whose cell "recordnumber" = anAppleScriptVariable)

set cell "myfield" of current record of window "mydatabase" to "OK"

------------------

or to send a variable value to the field:

set cell "myfield" of current record of window "mydatabase" to thevariable

------------------------------------------------

to get data from Filemaker into an Applescript variable:

set TheApplescriptVariable to {cell "FileMakerField" of current record of window "mydatabase"}

------------------------------------------------

hope this is OK

jeff

Link to comment
Share on other sites

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