I created an attendance tracking workflow that issues numerical "points" for each missed day and then emails the user letting them know they were issued points. I would like to include the total points that the user has outstanding in the email notification.
The points column is a standard number field, I need the workflow to query this column for the selected user, sum the points and dump into a variable for me to use in a notification. New to Nintex, Any ideas?
I would just query the list to get the points column.
The query list action could be filtered for a user that could be obtained from a start form.
Then just pull each item from the collection one by one and add it to a total.
Use the total where ever you want.