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.

recordID uniqueness across import/export

Featured Replies

So how unique is the recordID when importing and exporting data between similar files that originate on separate FMS 10 servers?

If I use the calculated field:

myRecordID = Get(CurrentRecordID)

and use it as the matching field when importing with create, am I setting myself up for a big disaster?

Or would it be wiser to use a compound index field using the date/time, user name, and some large random number? Hoping that the multiple servers (7 btw) would not create two duplicate numbers, ever, ever, ever, for millions of records?

Or am I screwed either way?

Maybe one is a more kind screwing?

Get (RecordID) is unique within a table - not even within a file, and certainly not across files. Why don't you use auto-entered serial numbers, with a unique prefix for each source?

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.