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.

Get number of portal rows related to specific record

poly_paparas
in Portals

Featured Replies

Hi All,

I want to be able to get the number of portal rows in a record (essentially count the number of records in the related table for one given record).

My setup is as follows.

I have a layout pulling records from a table called patients, with the patient's details. There is a portal in this layout, pulling data from a related record called visits, which holds the patient's visits so far.

I want to be able to put a count of the number of visits on the layout. I tried various things, but I get the total number of records in the visits table, not the ones related to the particular patient

Any help would be appreciated.

George

Try a calculation field (in the Patients table) =

Count ( Visits::PatientID )

---

P.S. Please update your profile with your version and OS.

  • Author

Try a calculation field (in the Patients table) =

Count ( Visits::PatientID )

---

P.S. Please update your profile with your version and OS.

Thank you very much for your help.

It worked like a charm...

Create an account or sign in to comment

https://fmforums.com/topic/76371-get-number-of-portal-rows-related-to-specific-record/
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.