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.

Search/Sort Portal Records

Featured Replies

Is it possible to search through and/or sort records found in a portal?

I have a portal that displays fifty lines of info... the way i have it setup right now is that, on each line, i have placed two fields that are read-in from another file called BillableX and TestsPerformedX, respectively. In the file that these fields are read-in from, I have fifty value-list-fields ("yes" or "no") that tell the user whether or not a certain test has been completed and if it is billable (these fields go down the page vertically); each field is numbered, i.e. Billable1, Billable2, ... Billable40. Adjacent to each value-list-field, are fields that tell what test was performed; these fields go down the page vertically as well and are numbered TestsPerformed1, TestsPerformed2, ... ,TestsPerformed40.

So, all this info goes into a portal in another file. What I want is to be able to, say, go into find mode, type in one of the BillableX fields, run the search, and then have only the fields with the value "YES" show up in the portal as well as the adjacent/related TestsPerformedX info next to it.

It doesn't quite work when I try it... I think my main problem might be that FileMaker has no way of knowing which BillableX field is "attached" to which "TestsPerformedX" field. Or maybe portals can't do this anyway? You think I should post this same question into the "Relationships" section of posts?... yeah, I probably should. smile.gif

Any help, comments, suggestions would be appreciated.

Regards,

Lutfi

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.