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.

zero found count and scripted sorts

Ocean West
in FileMaker Pro v7 – v11

Featured Replies

It appears there is a change with 10 that I discovered when running a script.

In a list view layout with header / body / grand summary / footer, the grand summary will stretch to fill the gap between the header and footer depending on how many body rows there are.

If you omit all records from the found set all you will see is the header / grand summary / footer.

In this space I have used either a field or web viewer - calculated to show record count or "End of List" or "No Records Found" occasionally add a button. As i don't mind the user landing on a list with zero found.

However in 10 it appears that the sort operation is evaluated even when the found count is zero, the result is that all body parts are blanked (WHITE)

The quick fix is to wrap the SORT step with If [ Get(FoundCount) ] to exclude the sort step when no records are found preserving the grand summary.

Create an account or sign in to comment

https://fmforums.com/topic/64452-zero-found-count-and-scripted-sorts/
Go to topic listing

Similar Content

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.