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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Who Viewed the Topic

    1 member has viewed this topic:
    cfmartinez1090 
×
×
  • Create New...

Important Information

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