Fred(CH)

Find Matching Record [*;MyField] fails when script trigger

Discussion created by Fred(CH) on Aug 22, 2016
Latest reply on Aug 25, 2016 by Fred(CH)

Product and version

FileMaker Pro 15.0.1 > 13.0.5

OS and version

OS X 10.11.6, 10.10.5 And Windows 10

Hardware

iMac Retina 5K Retina 27'', MacBook Pro Retina 15''

Description

The Find Matching Records step fail to perform at the end if a field was specified in step options and any script trigger is installed when "OnModeEnter". An #5 error is generated and user is left in Search Mode.

Sounds like when a script is fired, the field option is simply lost down the road since Error 5 is :

"Command is invalid (for example, a Set Field script step does not have a calculation specified)"

And by the fact if no field is specified and the field is manually activated by the user, the action could complete correctly.

How to replicate

  1. Open my test file in attachment "FindMatch.fmp12".
  2. Make sure all records are displayed
  3. Click the button ISOLATE
  4. See the result
  5. Click the button WITH/WITHOUT TRIGGER
  6. Redo the test
  7. See the second result

Workaround (if any)

Don't use this trick to isolate a record (even it is often recommended in this forum for its great performences on hosted files ;-))

Attachments

Outcomes