Need to reference a field after user selects a relationship

Follow

Shawn Terry

• January 11, 2017 18:24

App layout:

Case:
text: CaseNum
relationship: CaseVolunteer

Volunteers:
text: Name

Events:
text: Title
relationship: Case-CaseNum
calculation: *Pull Volunteer Name from the selected case automatically*

Hopefully you can see that the calculation should automatically be populated from the selected case.  I did find where someone had discussed a similar thing but it was not what I was searching for.

0

• 

  Rainer Grabowski

  • January 11, 2017 20:03

  Hi Shawn,

  in the calculation field enter: 
  @all of  field.join()

  field = the field from which you want to pull the value. Type @all of  , a list pops up, look for the name of that field and select that token. If the list is too long and you can't see that field go on typing the field name.

  More help about calculations you find here: https://help.podio.com/hc/communities/public/topics/200101427-6-Calculations
  and here https://help.podio.com/hc/en-us/articles/201019358-Calculations

  Rainer

  0

  Comment actions Permalink
• 

  Shawn Terry

  • January 11, 2017 20:26

  Sorry :-/  I can't get it to work.  It will add it only if you've actually selected the name.  I want to choose the Case, then the connected Volunteer relationship from that Case.

  0

  Comment actions Permalink
• 

  Shawn Terry

  • January 11, 2017 20:45

  and by "selected" I mean that I added a relationship field in just to test.  I'd that that field not to be there at all.  Just the calculation field that grabs the name.

  0

  Comment actions Permalink
• 

  Rainer Grabowski

  • January 12, 2017 08:11

  In a calculation field you don't have access to a relationship field in the related item. Means: You can't pull directly the volunteer name.
  The workaround:
  1. add a caluculation field (e.g. called "Volunteer") in the app Case, which pulls the volunteer name (@all of name.join())
  2. in the calculation field in events: @all of Volunteer.join().
  
  You can hyperlink the name, which allows to jump directly from the Event item to the Volunteer item (if needed; there are some posts in the calculations section of this community which describe how to create the link).

  0

  Comment actions Permalink

Please sign in to leave a comment.