Send Total of Child List to Parent List

rss

Posted by jennifer_little - Feb 27 ’17 at 08:33

Hello,

I have a parent list called Projects for example. I have a child list called tasks which is linked to the parent list with a unique project ID. I want to calculate the total of all related child tasks and input the project total into the parent list. Example shown below:

 

Parent List - Projects

Project ID      Project Name     Project Total

000-001         Project a             £15.00

 

Child List - Tasks

Related Project ID       Task name         Task total

000-001                       Task 1                 £10.00

000-001                       Task 2                  £5.00

 

Thanks

 

Jennifer

 

 

 

  • Dmitry Kozlov
    Dmitry Kozlov
    Admin
    Member for: 5 years 11 months
    #1 by Dmitry Kozlov Feb 28 ’17 at 02:20

    Hi,

    You can calculate the total either in a workflow or with JavaScript directly in a 'Project' form containing a Related Items control with the related tasks. Please, find a sample in the thread:

    http://forum.spform.com/forms-designer-for-sharepoint-20/related-items-sum-36758/

    If you need an assistance of our support team, send a request to [email protected]

Displaying 1 to 1 of 1 messages