OnRecordCommit

Performs a script before a record that has been changed is committed.

Actions that cause a record to be committed include:

  • a user changes data in a record and moves to another record
  • a user changes a record and immediately accesses the Manage Database dialog box
  • a user presses the Enter key
  • a user clicks the layout outside of the activated record after the record has been modified
  • script steps that move focus to a different record if the previous record was modified
  • a script performs a Commit Records/Requests script step

When the script runs 

Before the event has been processed.

Modes in which the trigger can be used 

Browse and Find modes.

Result 

You can use the Exit Script script step within the triggered script to return True or False.

  • True: The event that triggered the script proceeds.
  • False: The event that triggered the script is canceled.

Compatibility 

Product Supported
FileMaker Pro Yes
FileMaker Go Yes
FileMaker WebDirect Yes
FileMaker Server Yes
FileMaker Cloud Yes
FileMaker Data API Yes
Custom Web Publishing Yes

Originated in version 

10.0

Notes 

  • In a portal that displays records from a related table, moving from record to record inside a portal does not cause a commit; those changed records are committed when the focus leaves the main record to which they are related.

  • This script trigger activates only when there are uncommitted record changes. However, it is not activated within a transaction (that is, between the Open Transaction script step and the corresponding Commit Transaction script step).

  • Exiting a record that had keyboard focus activates this script trigger only when the record being exited was changed.

  • See Actions that don't activate script triggers for a list of other actions that do not activate this script trigger.