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.

Function to determine if a record has a child record

James Gill
in Calculation Engine (Define Fields)

Featured Replies

I'm trying to find out if there is a way to determine if a parent record has any child records via a calculation. I know I can do this by creating a script and setting a variable of the parent record and then doing a search on the child table, but to me that just seems like a convoluted way to go about this.

... but to me that just seems like a convoluted way to go about this.

I would agree. You can have a searchable numeric field, instead.

In your Parent table, create a calculation resulting as a Number. Modify the following calc to fit your relationship and field ...

Count ( childrelationship::IDfield )

It's critical that the field being "counted" always have a value. Most developers use the ID field.

Hope this helps!

Or just:

not IsEmpty ( Child::Matchfield )

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.