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.

Displaying x of x records found

Featured Replies

Hi

I run a script on a button to perform a find

This finds the records based on the users criteria then takes them to a new layout to display the results.

On this layout i would simply like to add a line of text that says "Displaying X of X records found" just as it does in IWP.

Is there an easy way of doing this or am I looking at using calcualted fields to do this.

I know there are certain symbols you can use on a layout to display username, version, last modified etc I was wondering if the same is true for current record of current found records?

I dont know if this makes a difference but it is a hosted database on FMSA 9 with clients perfoming finds in FMP 9

Many thanks

This will work. Make text changes to say what you want.

Create a global field. Set as a calculation. Add the following:

Let([

Fc = Get(FoundCount);

Tc =Get ( RecordNumber )];

"Viewing " & Tc & " of " & Fc) &

" records."

You need a calc field, result text, unstored:

RecString = Get (foundcount) & " records found out of " & Get (recordcount) & " total records."

You can put this as a merge field in the footer of your list view. I put one of these in each table.

  • Author

I was along the right lines with my calc field - just found the issue was storage - do not store calculate when needed...

Thanks both for your help

Create an account or sign in to comment

Important Information

By using this site, you agree to our Terms of Use.

Account

Navigation

Search

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.