Passing the sum of total in subsite to another list
Posted: 05 Dec 2018
Hi
I have two lists.
1.Personnel.
2.Absence. (In a sub-site)
What I want to do is take the total of a field called “daystaken” in the absence and apply the sum of the total to a field called “Absencetotal” in the personnel list. Criteria: Where the employee_name of both lists are the same AND where the “Daysold” field in the Absence List is less than 365. Then run this on a timed workflow.
The problem is, I believe I cannot run a workflow with subsite and site. Therefore I was wondering if this was possible within the cross-site lookup functionality?
I have two lists.
1.Personnel.
2.Absence. (In a sub-site)
What I want to do is take the total of a field called “daystaken” in the absence and apply the sum of the total to a field called “Absencetotal” in the personnel list. Criteria: Where the employee_name of both lists are the same AND where the “Daysold” field in the Absence List is less than 365. Then run this on a timed workflow.
The problem is, I believe I cannot run a workflow with subsite and site. Therefore I was wondering if this was possible within the cross-site lookup functionality?