0

I am working on SharePoint 2013 Enterprise.
I am looking for a functionality so I can sum item chosen in a list.
As an example I have a list call Bus which is the parent list. enter image description here
The second list is the number of passengers which have a lookup column from the Parent or the Bus list.
enter image description here The functionality that I am looking for is to set #Passenger in parent List depend on passengers belong to that bus. For instant in the example the #Passenger of Bus number 1 should be 3 because 3 people belong this bus.
enter image description here

1 Answer 1

1

One way you could do this is to open up SharePoint Designer and create an item workflow in passenger list(triggered on Create or Modified) for the passenger list. Create a parameter in the workflow for each bus type and for add a value to the correct parameter based on some if statements.

Once you have those parameters you could loop through the items on the bus list and update their bus items. Use the Update Item action.

I'll leave you to work out the actual logic on this one, I suspect there is an easier and more elegant method. Certainly, you could also achieve this with some javascript customisation following a similar logic.

Another way, would be to run the workflow and just target the bus item and add or subtract when item is added/updated/deleted.

There may also be a way to do this using calcultated columns, I'm sure that's worth researching.

2
  • Thanks for your answer! Actually I already tried workflow or JavaScript but I believe always there is a better but hidden way in SharePoint! For sure I will try your solution and researching.
    – Shaghayegh
    May 16, 2016 at 9:53
  • 1
    No problem, other than calculated columns, workflows and javascript are pretty much your only options client side. If you can write javascript then you can easily write a script to handle this, just go back through your logic and see if you can find another approach. Good luck!
    – GrantMcW
    May 17, 2016 at 4:44

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.