Jump to content

Applescript FMP5 Multiple Find


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

Recommended Posts

  • Newbies

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

Link to comment
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

Link to comment
Share on other sites

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