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.

FMP 4.03 for Windows

tmac
in Calculation Engine (Define Fields)

Featured Replies

I use an identical db on my Mac at home as I use on my Win98 at work. On the Mac at home, a calculated "full name" field validated for uniqueness presents a message box with a beep whenever a name first & last name is entered that matches a current record. It then presents the user with the choice of "revert field" or "OK."

On the Win db, configured identical to the Mac, the message box comes without a "revert field" option, just the "OK" button. Is there a simple fix for this that I'm missing?

Hi,

No simple fix. We find it a serious bug on FM Windows and we also found this problem on FM 5.0 and FM 5.5. Even on other ocassions this missing "revert"-button can lead (depending on field-validation) to a circular hang of FM on Windows.

We have reported this to the FM development team for correction.

Erwin.

  • 5 months later...
  • Newbies

quote:
Originally posted by tmac:

I use an identical db on my Mac at home as I use on my Win98 at work. On the Mac at home, a calculated "full name" field validated for uniqueness presents a message box with a beep whenever a name first & last name is entered that matches a current record. It then presents the user with the choice of "revert field" or "OK."

On the Win db, configured identical to the Mac, the message box comes without a "revert field" option, just the "OK" button. Is there a simple fix for this that I'm missing?

Hi, i'm sorry for kicking this topic up from so deep, but i figured it wiser to search before i asked.

what i want to do is create a unique feeld consisting of 2 fields. so i created 2 fields, and 1 field to be unique.

the one field is a text field calculated and unique, except! it isnt! i can hit in as many identical records as i want, it wont error me... it also doesnt update when i edit one of the other fields...

can you explain me, how have you created the unique calculated field ?!

Take a look at the FileMaker TechInfo Database Article #104191: it discusses a technique for unique validation of a calculation field. It's neat because technically you cannot validate calculation fields!

You'll find the TechInfo database on Filemaker Inc's web site. http://www.filemaker.com/

Create an account or sign in to comment

https://fmforums.com/topic/3091-fmp-403-for-windows/
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.