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.

Showing # of new records

iNcR3d1bl3
in Calculation Engine (Define Fields)

Featured Replies

Hi!

I'm fairly new to filemaker and I was wondering how I could show the # of total new records. I am already showing the total of all the records but I need to show the # of newest records. How do I go about accomplishing this?

Any help appreciated, thanks.

How would you like the records displayed? In a portal on a Main Menu for instance? And what is considered 'the newest?' Any created the same day they are viewed? Are these related records you want displayed in Parent? Or are they the records created in the same table you will be viewing them from?

  • Author

Hi,

I would like them to be displayed as a # in a main menu, the newest is considered of that day, and they are in same table

thanks

Hi

you have to create 3 fields:

CreationDate = a date field with option of auto-enter the creation date

Flag = UNSTORED calculation field, result number and calc:

Case(

Get ( CurrentDate ) = CreationDate;1;

0

)

ToDayRecords = summary field = Total of Flag

  • Author

Works like a charm, thanks for all your help :)

Create an account or sign in to comment

https://fmforums.com/topic/41751-showing-of-new-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.