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.

Return count of found records?

torifile
in Calculation Engine (Define Fields)

Featured Replies

This may have been answered previously but I'm still new to FM and I'm not sure exactly how I need to word my search...

I've got a database with things like appointment times, gender, treatment phase, etc. Let's say I want to run a query for all women who have appointments within the next 2 weeks. I've designed an interface for the find, but I want to format the found results to say:

________

Found xx records with your criteria

Jane Doe

Janis Joplin

...

________

Anyone have an idea how I can do this?

Get(FoundCount). To display, you can create a calculation field, unstored.

Then found <<field>> records with your criteria.

  • Author

That sounds easy enough, but where do I put that? Is it a script? (Like I said, I'm still new at this)

  • Author

Nevermind. I figured it out. Is it best to put it in any particular table or does it matter?

It is table-dependent. You'll need a calculation for it in every table that you want to display the found count dynamically.

Create an account or sign in to comment

https://fmforums.com/topic/25297-return-count-of-found-records/
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.