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.

Trapping NO Records when using Get related record script step

Philt
in Relationships

Featured Replies

  • Newbies

I'm sure I'm missing something very simple. I've a number of self join relationships I use to display records on a custom form when users enter a response in a global field. How do I trap the situation when what they enter returns no related records. I presumed the Get Found Count = 0 method won't work in this case and sure enough it doesn't seem the right method to use.

Any help to point me in the right direction gratefully received.

Set Error Capture[on]

Go To Related Record[....]

If[Get(LastError)<>0]

Show Custom Dialog [There are no related records]

End If

Also:

If[isvalid(related::ID)]

Go To Related Record

Else

Show Custom Dialog [There are none]

End If

works

-Raz

  • Author
  • Newbies

Thanks VERY much to you both. So simple when you know how. Cheers

Phil

Create an account or sign in to comment

https://fmforums.com/topic/41690-trapping-no-records-when-using-get-related-record-script-step/
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.