Count Phone Number Occurrences For Loyalty Program
Im trying to make a loyalty program in file maker and was in the process if trying to use phone numbers as a method of figuring out number of visits. I was wondering if there is a way that I can could the amount of times a specific phone number appears in the phone number field?
Say A person has the phone number 555-555-5555 and each time this person comes a new record is created with this phone number. The counter for times this person has been at the store should reflect the amount of records with this specific phone number inputed.
Is this possible?