Depending on how frequent the total worked hours need to be updated, you could go for one of the following:
- Scheduled site workflow to run at night and going through project list items and lookup for each project the worked hours in the task list.
- List/re-usable workflow on the Tasks list which runs when worked hours is changed, triggering a site workflow which for the current Project item ID gets all tasks and sums the worked hours
Keep in mind that calculated columns may prove tricky to access in some of the workflow actions.
Hi,
I've tried to create a site workflow but don't get it to work. Can you give me a detailed description of how to set it up? I'm new to nintex and these kinds of workflows.
In the (scheduled) site workflow, you start with collecting all item ID of the Project list items using a Query List (if required you can filter on active projects only), and store the result in a collection wf var (e.g. collProjects).
Next you have a for each loop using collProjects, storing the current item in idCurrentProject,wf var. For this you get the Project no (Set Variable or Query List, eg txtProjectNo). This you use in a Query List on the Task list, filtering on Project No = txtProjectNo, and store the found hours in the collection collProjectHours. Set a wf var numSum to 0 and use a Foreach on this collection to add the current value to numSum. Next you can store the numSum value in the current Project list item.
Is this short description enough to get you going?
Thank you. I have a couple of questions since I don't get it to work. What kind of variable is idCurrentProject? I have stored it as a List Item ID. Is that correct? And I have problem with "For this you get the Project no (Set Variable or Query List, eg txtProjectNo)". What are the steps? I don't get it to work and I think this step is were I have done wrong. And just to be on the safe side, numSum is variable type: number. Right?
Hi Amie,
idCurrentProject is indeed of wf var type List Item ID; I often put the type in lowercase at the start of the workflow variable.
And numSum as such is indeed of type Number.
When you loop through each found project, you only have its list item ID. Because you want to lookup all associated project hours, you need to first get the project's Project No, for which you can user either Set Variable (to set txtProjectNo with a List lookup in Project List where ID equals idCurrentProject and retrieve Project No) or Query List (nearly the same config as the Set Variable). With the resulting txtProjectNo you can lookup the hours in your Tasks list.
