Passing the sum of total in subsite to another list
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?
Dear Roo,
I'm not quite sure how to implement this functionality using Cross-Site Lookup, but let me suggest alternative ways:
1) Workflow Actions Pack: https://plumsail.com/docs/workflow-acti ... caml-query
2) JSOM: https://docs.microsoft.com/en-us/sharep ... sharepoint
I'm not quite sure how to implement this functionality using Cross-Site Lookup, but let me suggest alternative ways:
1) Workflow Actions Pack: https://plumsail.com/docs/workflow-acti ... caml-query
2) JSOM: https://docs.microsoft.com/en-us/sharep ... sharepoint
-
- Information
-
Who is online
Users browsing this forum: No registered users and 11 guests