Displaying the number of records in a database
a simple question from a FileMaker novice: how do I display the total number of records in a database?
The previous poster was correct. the get totalrecordcount is what you want to use. Create a Calculation field in your database, change the View: "all functions by name" drop down to "get functions". In there you will find many useful functions including the get (totalrecordcount) function.
get totalrecordcount gives you what you are looking for.
greetings from germany
Thanks! But I'm afraid I have to ask another beginner question: where do I put this code? I want to show the total number of records in my database as a "field" in one of my database layouts.
Make sure the calculation field is unstored.
Thanks for your kind advise and patience everyone, now I have what I need.
Retrieving data ...