Skip to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Commit records

Featured Replies

FM 11 Adv. I don't understand when the Commit records script step should be used. Can anyone explain this?

Whenever a record is being edited, FileMaker locks it so that no other users can change it at the same time. The commit steps tells FMP to check that the edits are valid (based on the field-level validation rules that have been defined) then save the changes and un-locks the record so somebody else can have a turn.

So basically, in every script you should explicitly commit the record when finished editing the record. There are some steps that implicitly commit the record -- changing to another record and changing layout are two -- but it's good habit to do so yourself.

You should also trap for commit errors. Records won't commit if the validation fails: say if it's a duplicate value (or empty) in a field that has been defined to be unique (or not empty).

Record commit is important even if the solution in not intended to be used with multiple users: a record lock can occur when multiple windows are showing the same record and the record is being edited in one of them. (This caught a lot of developers when FMP 7 first released, it was the first version that allowed multiple windows of the same table to be open.)

BTW also read up on the Open Record script step, it's used to work out whether a record is locked.

Create an account or sign in to comment

Important Information

By using this site, you agree to our Terms of Use.

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.