Nintex Forms 2010 - Calculated field to count number of items in a list created by current user

Perhaps you could add , on your list, a column named "createdYear" and use it on your query

Hi Mike,

See if these steps help:

1. As you already have it, create a calculated column to show Year from the Created date column.
2. Create a site workflow.
3. Create a current Year variable and store current Year value in it.
4. Query all the items from the list, get all the CreatedBy in the collection variable.
5. Perform collection operation to remove duplicates. This will give you unique users from the list.
6. Create For each loop with User (collection variable).
7. Query the same list again, Filter against Year variable = Year calculated column. Get ID's in the collection variable.
8. Use Collection operation to count ID's.
9. As a result you will have count of ID's for the current year for each Created By. You can store this data in a separate list.
10. When a person opens the form, you can do lookup against this list to show the count.