AnsweredAssumed Answered

OnRecordLoad Not Triggering If PopUp Menu Selected

Question asked by CraftICT on Jun 11, 2013
Latest reply on Jun 13, 2013 by philmodjunk

Summary

OnRecordLoad Not Triggering If PopUp Menu Selected

Product

FileMaker Pro

Version

12.0v4

Operating system version

Windows 7

Description of the issue

I believe this to only occur using Windows and kind of relates to the support page at http://help.filemaker.com/app/answers/detail/a_id/7131/kw/onrecordload/session/L3RpbWUvMTM3MTAxNDY3Mi9zaWQvKnE0NTd4c2w%3D but in reverse and proving a pain to us.

If having just selected a value from a pop-up menu and navigate to the next or previous record the OnRecordLoad script trigger will not run until the record is committed, which has to be done manually with a mouse click or Enter key. The Mac version of FMP works as expected with the trigger firing immediately without user interaction.

Steps to reproduce the problem

Create 2 fields on a layout, set one as a pop-up menu for a simple value list. Set an OnRecordLoad script trigger.

Navigate between 2 records and the script triggers. Click in the pop-up menu, select a value and immediately navigate to a previous/next record. On a Mac the script triggers, on Windows it doesn't.

We often use SQL generated conditional value lists with global fields for data entry into portals. Navigating between records requires these value lists to be built dynamically using the OnRecordEnter script trigger. As the trigger doesn't fire without user interaction, an incorrect value list can be displayed for a record.

Expected result

We would expect consistency between the 2 operating systems(!)

Actual result

Windows - script doesn't trigger

Exact text of any error message(s) that appear

No error messages

Configuration information

Waiting for an OnRecordExit trigger ;-)

Workaround

Use custom menus and hijack Go to Next/Previous records to take focus away from the fields containing value lists before navigating.

Outcomes