Count tasks based on field

[Jacob Talbot]

Hello

I am fairly new to FileMaker - and wanted to know the best way to count records based on a field, as a global calculation so it can be listed on every layout.

For example - I have an "assignee" field which is a username, I would like to count the records based on the logged in user.

[Lee Smith]

Look at the get functions, start with the Get(RequestCount)

[comment]

5 hours ago, Jacob Talbot said:

to count records based on a field, as a global calculation so it can be listed on every layout.

There are several techniques you could use - but none would be well-suited for a global calculation field. Global calculation fields are stored and will not refresh unless a referenced field in the current record is modified.

Can you explain what you mean by "listed on every layout"? Do you want to display this number on layouts of tables other than the table in which the Assignee field is defined? For what purpose?

Also, please update you profile to reflect your version and platform.

 

2 hours ago, Lee Smith said:

Look at the get functions, start with the Get(RequestCount)

Can't see how that would help with the described problem..