6 Replies Latest reply on Aug 25, 2016 3:08 PM by Fred(CH)

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

    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 ;-))