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.

FM3: verify by calculation

DonH
in FileMaker Legacy fp3 and fp5

Featured Replies

I'm baaaaaaaaaaaack. wink.gif

Here is the situation. There is a date that needs to be entered under certain circumstances. The date has to be within the last year. That is no problem. HOWEVER, what has come up is people entering the date when they shouldn't and since there is a verification by calculation on the date, it won't allow them to delete the date.

So I'm trying to figure out how to set the verification up for EITHER blank or within the last year.

I tried IF(IsBlank(theDate),'',figger it is in the last year)

But it just told me that I had to enter a date.

Any suggestions? confused.gif

FileMaker Version: 3

Platform: Windows 2000

Hello DonH,

I suggest you add:

IsEmpty(theDate) or

before your existing validation calc. That ought to do it. wink.gif

  • Author

Mahalo nui loa. I knew that! Sheeesh. Putting in a new system for the ultrasound machines and that is sucking my brain dry.

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.