Counting number of related apps

Answered

Follow

Art Harkin

• May 15, 2014 00:39

I would like to have a calculation field that shows the number of items in another app that are related to this item.

The calculation field provides Sum, Average, Max, Min of a field in another app, but what I want is a Count.

Any built in ways to do this or a suggested javascript that can count the number of items in another app related to the item in the app (where the calculation field resides)?

0

• Official comment

  

  Morten Siebuhr

  • November 13, 2015 14:45

  Hi Art,

  Pick any of the "[ ] All of X" for the desired relation. (That will return a list of X for all the related items). Type ".length" after that to get the length of the list.

  The entire script should end up like "@All of Title.length" and return a number.

  Comment actions Permalink
• 

  Stefan Ukena

  • May 17, 2014 16:15

  Hi Art,

  you will need to add an additional calc-field to the items you want to count. Then have that field always output 1. Now you can count these items by summing over that field in the original app.

  Does that make sense?

  Here is a calculation that always outputs 1:

  var foo = @AnyField; // only needed because otherwise Podio will not let us save the template
  1;

  That's it. Now use this to count the items in that other app.

  Best,
  Stefan

  http://www.diekollaborateure.com/go/podio/help

  0

  Comment actions Permalink
• 

  James Hayward

  • July 02, 2014 09:00

  Thanks Stefan - that worked a Gem... now to get into sum..

  0

  Comment actions Permalink
• 

  John Trickett

  • October 28, 2015 14:56

  This has stopped working for me. Has anyone else noticed an issue?

  0

  Comment actions Permalink

Please sign in to leave a comment.