Calculation of Relationship with Multiple References

Follow

Gabe Cinquepalmi

• July 28, 2017 16:09

Hi Podio experts!

I have app A (Properties) and app B (multiple entries for properties). I want to get a status from the latest entry from B to use in A. I can't seem to figure this out.

I've done this before with relationships with single references using @All of B[0] or something like that. With the relationship set to Multiple References, however, nothing shows up in the list when I begin typing "@All of". Since this is a multidimensional array, perhaps there is a different syntax?

I also tried coming at it from the other side, where the relationship was set in the B app, but I also can't seem to find a way to reference "Related Items" for A in the A calculation field either. 

Am I missing something?

0

• 

  Rainer Grabowski

  • July 29, 2017 08:01

  Hi Gabe,

  if A and B are referenced through a relationship field something shows up when you type @all of ...
  Did you try typing the name of the status field - @all of name of status field
  Even if you only type @name of status field it should be shown in the dropdown as @all of name of status field.

  If you want the latest to be shown:
  @all of name of status field.reverse()[0]
  or
  @all of name of status field[@all of name of status.field.length - 1]

  Rainer 
  
  

  1

  Comment actions Permalink
• 

  Gabe Cinquepalmi

  • July 31, 2017 00:59

  Nm. I was doing @all of "app" instead of "field". Derp.

  0

  Comment actions Permalink
• 

  Gabe Cinquepalmi

  • July 31, 2017 21:42

  Thanks, Rainer. The other issue I was having which took forever to figure out, was that once I made my calculation field return a number for a test, it was no longer usable to return text. I was losing my mind trying to figure out why I could only return a 0, but when I made a new separate calculation and copied it in, it returned my text no problem. Finicky!

   

  0

  Comment actions Permalink

Please sign in to leave a comment.