• Matt van Wijk
  • NEWBIE
  • 10 Points
  • Member since 2015

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 3
    Questions
  • 0
    Replies
I am trying to give a custom name to a campaign name, pulling from different values. One of those is a Team Leader, which is a lookup(contact) field.

When I use
"& Team_Leader__c"
it returns the contact ID.

When I use
"& Team_Leader__c.Name"
it produces an error saying "Error: Field Team_Leader__c does not exist. Check spelling."

Any thoughts on how I can get it to pull through the name of the Team Leader as displaying in the lookup field rather than the ID?
I'm trying to use a formula to name an object based on 4 variables. One of these will hopefully be the fiscal year of our field "startdate"

Our fiscal year begins in July, so ideally 1/06/2016 should return "FY16" and 1/07/16 should return "FY17" and so on.
How would I go about doing this? The code I am trying to use says:

&CASE(
  MONTH( StartDate ),
  1, (Year( StartDate )),
  2, (Year( StartDate )),
  3, (Year( StartDate )),
  4, (Year( StartDate )),
  5, (Year( StartDate )),
  6, (Year( StartDate )),
  7, (Year( StartDate )),
  (Year( StartDate ))+1)

This is returning an error "Error: Incorrect parameter type for operator '&'. Expected Text, received Number"

Here is the full code below; when I remove the above section, it works fine:

Parent.Name
&" - FY"
&CASE(
  MONTH( StartDate ),
  1, (Year( StartDate )),
  2, (Year( StartDate )),
  3, (Year( StartDate )),
  4, (Year( StartDate )),
  5, (Year( StartDate )),
  6, (Year( StartDate )),
  7, (Year( StartDate )),
  (Year( StartDate ))+1)
&" - "
&CASE(
  MONTH( StartDate ),
  1, "January",
  2, "February",
  3, "March",
  4, "April",
  5, "May",
  6, "June",
  7, "July",
  8, "August",
  9, "September",
  10, "October",
  11, "November",
  "December")
&" - "
&Team_Leader__c

Thank you for any help!
*Amateur alert*
I have been trying to create a custom object for us to log complaints we receive. I have been able to make this, and connect it to the contact master record. I want to be able to easily see more information from this view, and I was wondering how I would add it? For example, I would like to add "date received", like in the way multiple fields in the relationships object are visible. Can anyone help?
User-added image