Filemaker has a user FIND MODE. A Sort Records is also available

FMP Scripting can restore preprogrammed Finds and Sorts but You have to program them and than program

like....... IF this do that else if do something else .......

THIS is a DEMO for a dynamic way to do all this with

a Scriptparameter send to a FileMaker native AppleScript !

It understands the following Commands

FIND............. more FIND for OR Searches

OMIT............. to omit certain records(multi)

EXECUTE.....to FIND and OMIT the whole List of commands

SORT............to sort the found set of records

It is limited to the Layout You put the Find Button on !

You can use that to find any kind of data with only ONE Find Script

You can store and recall Finds and Sorts

End Customer can Do and store and recall their own Searches

Works with any kind of Field as long it’s on the Layout ! Also with related fields !

Understands all “signs” from native Find ( ><#@ ... etc ).

Example Parameter (works with FMP 7 +)

Find|Last Name|Adams|City|Boston~

Find|Last Name|Leads|Street|Moscone~

Find|Date|1.1.2007...1.3.2007~

Omit|First Name|Tiara|~

Omit|First Name|Emma|~

Execute~

Sort|Zip|A|Last Name|A|First Name|A|~

Credits:

Delimited Scripting by Bruce Robertson January 23, 2001

FindMachineV1.zip

Edited June 10, 200718 yr by Guest
change name add example

Nice work. Thanks for the credits!

Bruce Robertson

I have made some changes to the file including adding an option to perform a script; and more feedback in the error messages.

FindMachineV1.1.zip

I have made some changes to the file including adding an option to perform a script; and more feedback in the error messages.

Hi BruceR , Thank YOU !! You are the Specialist !

Give me a few days to look at the changes.

Took me a while until I understood Your original work in the first place ;-)

I use it with great success in a Layout Navigation System with Properties and Print System with Properties in a Restaurant Solution.

For me actually amazing that some things can relatively easy be done in AppleScript but no way direct in FMP

So Thanks Again for Your original Work !

Attached is an updated version that adds a new feature - sequences. You can string actions together to allow the user to make sequences based on previously created actions. Go to Layout is now also added as an action choice.

One benefit of this method is that it ensures that an action is completed before going to the next item in the sequence.

FindMachineV2.zip