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.

Field validation when field is from external FMP data source

GC GYM
in Calculation Engine (Define Fields)

Featured Replies

I have data validation on a field in the main database, however when I edit that field using a separation model, the validation does not seem to work, it allows invalid values.

I can see in the help topic that ODBC data sources do not bring across data validation from the data source. Is this also the case if the data source is FMP? If so, do I just need a script trigger in the separation file to do it's own validation?

Field validation works with the separation model. Can you give a specific example?

  • Author

It is a date field, validated by calculation, Self ≤ Get(CurrentDate)

Only during data entry, display custom message.

A forward date does not cause a validation error in the separation file. Client machine and FMS have correct sysstem date/time.

 

  • Author

Just tried replacing "self" with <DateField> in the validation calculation but same result

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

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.