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.

Best way to check if there are related records?

Featured Replies

I have a script that checks field validations in a portal from a related table.

The script needs to check if there are not any related records, so it can skip the validation checks if this is the case

I had been using a 'Go To Related Record' script step and checking the LastError result to see if there are not any related records.

Is there a more standard way or stable way? Perhaps a field in the master table with a RecordCount of related recs?

Begin your script with:

If [ IsEmpty ( relatedTable::keyField ]

... do whatever because no related records exist

Else

... do whatever because you have related records

EndIf

Replace 'relatedTable::keyField' with your true relationship name and whatever field is the join key between the tables.

  • Author

ah yes...the obvious! thanks LaRetta!

Create an account or sign in to comment

Important Information

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

Account

Navigation

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.