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.

Multiple records on one Portal Row??

Featured Replies

  • Newbies

How can I show multiple records from two fields which sometimes match and sometimes don't, on one portal row?

I'd like the end result to look like this:

txt_Name.fp6 Ptl_Associated record(s).fp6

Fred 1,7,99

Joe 4

Rick 2,3,5

Etc...

#1.) I cannot figure out how to derive Txt_Name.fp5 from two different fields: Txt_Composer.fp6 and Txt_Author.fp6, where Txt_Composer.fp6 sometimes matches Txt_Author.fp6, only return one record/ match. Where Txt_Composer.fp6 and Txt_Author.fp6 don't match, it should return two seperate records.

#2.)I cannot find a way to make a portal show the way I've specified above. Is this possible? Am I using the wrong tool? Please help.

  • 2 weeks later...

Not sure I'm understanding what you want to do, but here goes:

If the records are in another related file, they can be referenced via two relationships, I'll call them Rel.Composer and Rel.Author. For instance, Rel.Composer would relate the field in this file, Txt_Composer.fp6, to a key field in another file, say Key_Composer.fp6.

I'll call the fields you want to return in Rel.Composer Record1, and in Rel.Author Record2

c.Txt_Name.fp5 is a calculation field in the main file:

If( Txt_Composer.fp6 = Txt_Author.fp6,

Rel.Composer::Record1,

Rel.Composer::Record1 & " - " & Rel.Author::Record2

)

BTW: are you naming fields with .fp6? I'd discourage you from doing that, since the .fp6 is a well-known file extension having nothing to do with a Composer...

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.