Jump to content
Sign in to follow this  
RH Design

Applescript FMP5 Multiple Find

Recommended Posts

APPLESCRIPT PROBLEM: I need to write an applescript to perform a multiple FIND on a Mac FMP5 database.

For example: To show records whose field "Name" contains "A","B","K", or "N"

(in manual FIND mode I would simply use Command N to add each new criteria)

My starting point is:

tell application "Filemaker Pro"

show (every record in database "myDatabase" whose cell "Name" = "A")

end tell

This successfully shows the "A" record.

Many tries later, I still can't find the correct language to extend the command to show all four records ("A","B","K","N").

It can't be that hard. Can someone please embarrass me?

BobH

Share this post


Link to post
Share on other sites

Hello,

A simple way to work is working with "requets" and "find".

try this :

set theRequests to {"A","B","K","N"}

tell application "FileMaker Pro"

show every record of database "myDatabase"

delete every request of database "myDatabase"

repeat with x from 1 to count theRequests

set crre to create request

set cell "Name" of crre to (item x of theRequests)

end repeat

find

delete every request of database "myDatabase"

end tell

Share this post


Link to post
Share on other sites

JM -- Perfect solution...You have only been registered 4 days

and you have saved at least one project already!!! Many thanks.

Share this post


Link to post
Share on other sites

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
Sign in to follow this  

×

Important Information

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