Ohgo_Ohgo Posted June 9, 2007 Share Posted June 9, 2007 (edited) 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, 2007 by Guest change name add example Link to comment Share on other sites More sharing options...
bruceR Posted June 13, 2007 Share Posted June 13, 2007 Nice work. Thanks for the credits! Bruce Robertson Link to comment Share on other sites More sharing options...
bruceR Posted June 13, 2007 Share Posted June 13, 2007 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 Link to comment Share on other sites More sharing options...
Ohgo_Ohgo Posted June 13, 2007 Author Share Posted June 13, 2007 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 ! Link to comment Share on other sites More sharing options...
bruceR Posted June 16, 2007 Share Posted June 16, 2007 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 Link to comment Share on other sites More sharing options...
Recommended Posts