AnsweredAssumed Answered

List unique values in fields and count number found

Question asked by tteuer on Apr 29, 2018
Latest reply on May 13, 2018 by philmodjunk

Hi everyone,


I have a Filemaker database I've designed that is used for idea/suggestion submission for the company I work for. There are all sort of statistics that are generated using ExecuteSQL commands, but I can't figure this one out...


Background -- I have a free text field called "Name" where the user inputs their Name. I need a report/calculation to somehow generate a list of the unique names and count how many ideas they have submitted.


Is there a way this could be done?


Please let me know if any additional information would be helpful. I've been self taught Filemaker and this forum has been really helpful during the development of my database.