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!
Please sign in to leave a comment.