Details about this thread
  • State Verified Answer
  • Replies 3 replies
  • Subscribers 293 subscribers
  • Views 1818 views
  • Users 0 members are here
Related content from around SugarClub

SQS on Relate and edit/display field other than name

Francesca Shiekh
I am currently on SugarCRM 6.5.15 Professional.

A Relate field stores the id of the related record and by default displays the name field.
I have two cases where I wish to have something other than the name display:

A Users custom relate field on Opportunities where I wish to display user_name instead of name.

A Cases custom relate field on Cases (stores the Parent Case) where I wish to display case_number instead of name.

I would want all occurrences of the field, including SQS, to show the user_name/case_number respectively instead of the name.

Is this possible?
Parents Reply
  • 0 in reply to Alan Linnane

    Here you go

    var filedName="assigned_user_name";

      delete(sqs_objects[filedName]);

      sqs_objects[filedName] = {

      "form": "EditView",

      "method": "query",

      "modules": ["Users"],

      "group": "AND",

      "field_list": ["username","id"], // fields to get

      "populate_list": ["assigned_user_name","id"], //fields to populate in form

      "conditions": [{

      "name": "username", // filed to search

      "op": "like_custom",

      "end": "%",

      "value": ""

      }

      ],

      "required_list": [""],

      "order": "name",

      "limit": "30",

      "no_match_text": "No Match"

      };

Children
No Data