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

    Need help with a field content counter

    pixelmac

      Title

      Need help with a field content counter

      Post

      Hello,

       

      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.

       

      Example:

       

      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
          raybaudi

          Hi

           

          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.