Jump to content

Showing # of new records


This topic is 5731 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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.

Link to comment
Share on other sites

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?

Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is 5731 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

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