Using the Results of a Relationship to form part of a Formula

Follow

Michael Petersen

• January 19, 2016 16:07

Hi Team. 

I have linked Apps through a Relationship. I am trying to use the results of the entry into the relationship fields to form parts of a formula in another field. 

ie I want the output in Field "Campaign Title" to be :  "Unique ID" - "Briefing Company" - "Advertiser"

"Briefing Company"  and  "Advertiser" are Relationship Fields from our CRM (Linked) and the Field name that comes across is "Organisation" 

I can get the Formula to be:    @Unique ID + " - " + @All of Briefing Company + " - " + @All of Advertiser     but it does not produce results for Briefing Company  and  Advertiser. Only resulting text is "CM161 - -"

I realise that the field output from a relationship is a different format, but can it be used anyway to play its part in another formula in another field on the same Template?

Thanks for any advice!

Michael. 

 

 

0

• 

  Rainer Grabowski

  • January 19, 2016 17:10

  Hi Michael,

  if the names of the "Briefing Company"  and the "Advertiser" are in fields named "Organisation" you have to reference the field "Organisation" : @All of Organisation

  Rainer

  1

  Comment actions Permalink
• 

  Michael Petersen

  • January 19, 2016 17:34

  OMGosh.... So simple. I'm delirious here and gone "Podio Blind". I think its a real thing!  Thank you Rainer. I have been looking at all of your assistance to other queries on here throughout the day. You're gold.   Appreciated.   MP

  0

  Comment actions Permalink

Please sign in to leave a comment.