And what do you do when you get two users with the same name? Even if you get this to work, that will be a problem. Also, people change their names and so what matches by name one month may need to match be a different name the next. You really need a table of users where each user is assigned a UserID value that is not their name and that never ever changes.
You can then link tasks to the user record by UserID in a relationship and Count (as well as other methods) can then count the number of Task records. But note that my last sentence assumed a great number of details that may not reflect the current design of your tables.
We only have 6 users and it will never be more than 10. No one changes their name, it's not actually the FM username we use, it's just what they're known as to us.
I've experimented with the Count function but how do I get it to look for particular text? It's not the fields I want it to count, it's the instances of a particular name within those fields of text.
You may still find IDs a better option than names. "No one changes their name" seems unlikely in the long term. There can also be issues with mis-entering a name and later needing to correct it--only to find that this creates a mis match and you don't connect to the records you need to connect to.
I've experimented with the Count function but how do I get it to look for particular text?
You don't. Either you set up a relationship that matches only to the records you want to count or you use other methods to count the records you want to count.
Users::UserID = Tasks::UserID
From the User record for "Fred", Count ( Tasks::UserID ) will count all Tasks records linked to Fred's users record. But it won't discriminate between different Tasks linked to Fred--that would require either a different relationship or a different approach.
And there are quite a few different ways that you can count specific groups of records in FileMaker.
So what you're saying is that I need to have a separate field that only contains the UserID/name (and no other text) within my Tasks Table, if I want to count the number of records in which the user's UserID/Name is appearing?
That would be one approach.
A summary report based on the Tasks table could also be used to count records linked to each user.
Thanks PMJ, I think I'm going to come back to solving the task when I have a better understanding of FM.