1 Reply Latest reply on Dec 10, 2013 6:28 AM by philmodjunk

    count contacts - help required



      count contacts - help required


           I have 6 potential contact fields on my customer table. How can I count the number of contacts based on if data is entered in 1 or more of the contact fields?

           I would like to display the predefined default contact and have a counter displayed where you can tap it to open the pop up displaying all the contacts.


           Thank you

        • 1. Re: count contacts - help required

               Instead of 6 different contact fields in your customer table, define a related table for this purpose where you have one record for each such "potential contact". Not only does this allow you to record from 0 to any number of such items, you can display this data in a portal on your layout--which can be inside a tab control if you want as well as still being able to open a new window to "pop up" a list of those records. And in FileMaker 13,you can put such a portal inside a pop-over or a slider as well.

               Count ( RelatedTable::NeverEmptyField ) will return the number of such related records.

               And if you decide to stay with individual fields, Count ( field1 ; field2 ; field3 ...) will count the number of those fields that are not empty.