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.

Revert record does not revert serial number

  •
Osman
in Layouts

Featured Replies

Hi,

I generally un-check "save record changes automatically" option in data entry list views.

But the problem is about serial numbers. Order No field is auto enter serial number field. If the user creates new record and don't save it, record automatically deleted but it does not roll back serial number.

I know this is not a bug of FileMaker but it is not the case I want.

So, I am searching for a best way to do it. The alternatives that I am considering are:

- New record script always set next serial value (this may be slow down in huge data)

- Trigger may help about this issue (but there is no onRevert trigger option)

- Control new record process within a script and new layout (doing this job on 6 tables may be time wasting)

I wonder is there any other alternatives? Or which is the best way, any opinion?

Thanks,

Osman Cabi

You can set the auto-entered serial number to be generated on commit only.

  • Author

Thanks

How could not I see that :

Create an account or sign in to comment
Go to topic listing

Important Information

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

I accept

Account

Navigation

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.