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.

zero related records

Featured Replies

Apologies if this has been answered elsewhere - or if the answer is obvious and I'm being stupid:

In FM 6 and earlier, if go-to-related-record found no matches, the Found Count would be zero. That seems no longer to be the case. I haven't discovered any Get formula that will allow me to display a message when there are no related records.

Where have they hidden it?

In FM7 or later, get(FoundCount) will return the number of records in the found set. In prior versions, use Status(CurrentFoundCount).

But for GTRR, you should test for the presence of related records prior to the Go to Related Records[] script step:

If [ count(relationship::recordID) = 0 ]

#No related records

Else

Go to Related Records [ relationship ; Show only related ]

End If

  • Author

Thanks a million. I knew it had to be there somewhere. It certainly was easier (fewer steps) the old way.

IsEmpty( relationship::recor dID ) may be a quicker test.

Create an account or sign in to comment

Important Information

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

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.