1 Reply Latest reply on Apr 15, 2010 7:51 AM by raybaudi

    Need help with a field content counter



      Need help with a field content counter




      How do I count and display how many times a certain first name occurs in a file.

      So when I browse records, near each field will be a number that show how many times that same name is used in the whole table.




      FirstName: Steve [4]

      LastName: Jobs [1]


      Seems like a simple task, but I can't get this working.


      I'll appriciate your help.


      FileMaker 11 Advanced

      MacBook Pro / Snow Leopard


      PixelMac :manhappy:

        • 1. Re: Need help with a field content counter



          you'll need to create a new selfjoining table for each field to count.


          So, if you have now:


          Table:: FirstName
          Table:: LastName


          you have to create two seljoining tables Table 2:: FirstName and Table 3:: LastName.


          Then you can create into Table two new calculated fields:


          CountFirstName = Count ( Table 2:: FirstName )
          CountLastName = Count ( Table 3:: LastName )


          Note that those are unstored calculations, so use them ONLY if you real need.