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.

Validation

smugcat
in FileMaker Legacy fp3 and fp5

Featured Replies

  • Newbies

I have a repeating field which was initially just text. Now any new entries come from a looked-up list. Is there any way to validate entries which occurred before the new validation, ie find any entries that are NOT from the looked-up list but were typed in.

Attached is a simple file that does what you want, using the "EXACT" function, and by replacing the paragraph returns with a "pipe" character, so the list can be manipulated. It works for both exact case matching and for case-insensitive matching. To expand for a repeating field, use the GetRepetition function in an inner Loop.

data_validation.zip

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

Similar Content

Important Information

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

I accept

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.