Can I concatenate a text field and the information selected in a relationship field?

Follow

Cheryl Cartwright

• November 18, 2015 05:45

I want to create a title that concatenates name (text field) and suburb (relationship to an app with all the suburbs listed). Can't seem to do it as seems to want to have two text fields to work with.
Thanks

1

• 

  Rainer Grabowski

  • November 18, 2015 06:28

  Hi Cheryl,

  you can do it. The suburb you get with: @all of FieldWithSuburbName.join() So your code should look like:

  @nameField + " " + @all of FieldWithSuburbName.join() 
  

  Rainer

  0

  Comment actions Permalink
• 

  Cheryl Cartwright

  • November 18, 2015 06:50

  Thank you!! Greatly appreciated. My first question here and great quick response.

  0

  Comment actions Permalink
• 

  Tony Barlow

  • November 23, 2015 15:35

  Is there a limitation on what @all... can fetch? I have an app which cross reference with 2 other apps. The primary app is a booking request app. Related apps are customer details and employers' details.

  By using @all... in calculation field, I can only see customers' details in drop down list but no sign of the employers. I've even tried @all of [entered a field name from employer's app].

  0

  Comment actions Permalink
• 

  Rainer Grabowski

  • November 23, 2015 18:48

  You can only fetch data from the directly related app. If your employers' details app is related directly to booking request you should be able to get the data. Try @titleFieldName (without all of) of employers' details, the list should offer you "@all of "of this field.

  0

  Comment actions Permalink
• 

  Tony Barlow

  • November 25, 2015 20:36

  Thanks for the answer. I use the suffix of .join() which did the trick. However, I'm still frustrated that I cannot call up a calculation field inside a task description field created through Workflow. Thanks anyway.

  0

  Comment actions Permalink

Please sign in to leave a comment.