Tally items from multiple apps in one relationship field
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"?
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 Nameand not the
@All of Vegetables Namenor
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.
Please sign in to leave a comment.