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.

Unique Calculation field

Stanley Tran
in FileMaker Server v7 - v11

Featured Replies

  • Newbies

Hi,

Is there a way to have a unique calculation field? This calculation field is the result of three other text fields. The combination of these three fields has to be unique in the database. FMP doesn't give me the option of unique when creating the calculation field. Is there a work around for this?

Thanks

Stanley

How can FMP insure that the result of a calculation is Unique?

You can force the other 3 fields to be unique, and thus the calculation would be unique.

What is this for? There may be a better way to go about this.

Agreed,... Concatenated fields should be used for display purposes only. When it comes to IDs, allow FMP to create one unique sequential number. Of course there are always extenuiating circumstances.

Create an account or sign in to comment

https://fmforums.com/topic/17173-unique-calculation-field/
Go to topic listing

Important Information

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

I accept

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.