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.

Grouping data from related records

Featured Replies

Hello guys,

I am totally new to Filemaker. So forgive me if I don

At first glance, this is nothing complicated.

If you know in advance what your categories are, create orphans records with just the category filed with each of your categories.

cSort = Category&aspect will be used as your sort key for this relationship so that the Categories would appear in the correct order.

If you need some indent, then use a calculated display field.

If you don't know your Categories in advance, you would need a new Table Occurrence with a Relationship on the Category field, and then some more settings, but nothing impossible again.

The second scenario would be slower than the first.

Tell us if this makes sense.

  • Author

Thanx Ugo DI LUCA for replying.

I did a sort on category and aspect and also created a script which I use to copy the data to another table. In preview mode it all looks good. Only in browse mode I couldn't get it working. I don't know if that's possible? Still the solution is good. Thanx for your help.

Greetings, Auditiaan

I'm assuming you are using subsummary parts, which are only visible while previewing or printing.

  • Author

Yes Queue, I am. I was hoping to see the same in browse mode, but I didn't. But that isn't a problem anymore... smile.gif

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.