Jump 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.

Lock Record After Status Change

Featured Replies

I've got an order entry system in Filemaker 8.5. Each order has a status. After the status is changed to "billed", I'd like to be able to lock the record so it is viewable only and cannot be edited.

I do have 2 privilege sets created -- Staff and Admin. I'd like the Admin to be able to still edit the record if necessary, but it to be totally locked by the Staff.

Is there a way to lock the record based on the status of the order?

Yes. Use a record level access calc. In the Staff privilege set, set the edit capability to only allow edit if status ≠ "billed".

You may also consider a second layout for an order, a "locked" layout. Navigate to this layout when the status = billed. The fields on this layout do not allow enter in browse mode. Coupled with the rla calc, you've protected the data from edit.

Create an account or sign in to comment

Important Information

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

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.