Tally items from multiple apps in one relationship field

Follow

Veronica

• September 15, 2015 23:44

Hi,

I have a relationship field that allows for references from multiple apps. How do I calculate how many references there are for each app?

As an example, I have a relationship field in app "Recipe" called "Ingredients". I can populate "Ingredients" with items from apps "Fruits", "Vegetables" and "Meats".

How do I calculate how many "Fruits" are in "Ingredients"?

0

• 

  Heather Fox

  • September 30, 2015 01:56

  Hi, Veronica. You can do this in a calculation field by using @All of Fruits Name.length. This is a count of all the links to the Fruits app.

  0

  Comment actions Permalink
• 

  Veronica

  • September 30, 2015 15:28

  Hi,

  I think this is only possible if the field "Ingredients" only accepts references to the app "Fruits", but not if it also accepts references to "Vegetables" and "Meats"

  0

  Comment actions Permalink
• 

  Heather Fox

  • September 30, 2015 22:36

  It will work. :) You just need to reference the Fruits items only using @All of Fruits Name.length.

  In the calculation field, you will have access to all the apps you referenced in the Ingredients relationship field. You need to choose the @All of Fruits Name and not the @All of Vegetables Name nor All of Meats Name. You will have access to at least 3 "@All" in the calculation field. Whichever you select and then append with .length, the calculation field will count.

  Give it a go.

  0

  Comment actions Permalink
• 

  Veronica

  • October 04, 2015 20:34

  Hi Heather,

  I think I got it now. Thank you!

  0

  Comment actions Permalink

Please sign in to leave a comment.