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.

Record ID match field

Featured Replies

In past versions of FM, the issue of uniqueness of the record ID was raised and several schemes were suggested for making a record ID match field other than FM's native Auto Enter Number.

I use an auto enter calculation: Get(HostDateTime) & Get(UserName) & Right(Random, 12). There is a theoretical chance of 1 in roughly 1,000,000,000,000 in one second that a duplicate will be made. Since my scripts make a single record per user button click, this is not possible. (for fun, I tested a looping new record script and was able to make about 3 records per second.)

With the new version of FM, is the ID number uniqueness issue irrelevant? Can I now just use the AutoEnter number feature without the long and bulky calculation above?

Thanks

OS

There has never been a problem with using auto-entered serial numbers unless you need to import or synchronize data in some way.

What issue are you talking about? Serial numbers auto-created ahve been unique for as long as they have been there.

I might add that Record ID's are different than serial numbers. The Record ID is an internal FileMaker marker.

Steven

  • Author

Thanks

OS

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.