You need to sign in to do that
Don't have an account?
brettnnyc
Tying all contacts with the same field value as all Opportunities
I have a field (called Job Title) in my Opportunities Object and Contacts object that has the exact same picklist values (Accounting Manager, Controller, etc.) How do I create a list (related list or via a report) of all Contact field values (Job Titles) that match the same Opportunity field value (Job Titles)?
Hi,
You can create a checkbox field in Opportunity. Make this checkbox field "True" if the Opporutnity picklist feild matches with the Contact picklist feild. Then run a report based on this checkbox feild.
Thanks
Thanks ... I created the checkbox field but I'm having trouble making the Codition Formula work because Title of Position (in the Opportunity) & Job Title Listing (in Contacts) are both multi-select picklist fields. I tried ISPICKVAL ... but I keep getting an error: see below.
ISPICKVAL( Title_of_Position__c = Contact_Association__r.Job_Title_Listing__c ,
TRUE, FALSE)
Error: Field Title_of_Position__c is a multi-select picklist field. Multi-select picklist fields are only supported in certain functions.
Can you help me out with another pointer?
Thank you,
Brett
Hi,
Since you need to compare multi-select picklist, the comparison cannot be done with the formula field. You need to do it with the help of trigger.
Below is the sample Trigger:
In the above code, "Targeted" is the checkbox to be updated.
Hope it helps.
Thanks
Thank you!
I have tried several different ways implementing the code you provided, but my lack of knowledge is killing me. Is there a way we can chat directly to see if I can get this implemented? It's a major milestone to moving forward with connecting all these job applicants/candidates with the potential jobs we have open. I have already been down the route of Force.com Developer support and it's not available in SF they said.
Thank you,
Brett brettsloan at sloanps.com
In the trigger can you please identify the fields that I need to replace with my customized fields?
I assume Contact_Association__C = the same field name as the Job Title within my Candidate object?
What is 1st_OpportunityID.add? Do I replace that with one of my pertinent fields or leave it alone?
My current fields are the following:
within Object: Positions I have the field "Position Title" (multi-select picklist)
within Object: Candidates I have the field "Position Title" (multi-select picklist)
I'm not sure what other fields are necessary.
Thanks again!