[SalesForce] Can’t Pass Through Value of Lookup Field on Insert

I'm having trouble passing through the value of a Lookup field on Insert. I've got an object called ts2__Project_Job__c, which has a custom Lookup field called Candidate__c which looks at the Contact standard object. In my Application I simply want to use this Lookup field, to find a contact, then Insert a new record.

Here's what I've got:

VisualForce

<apex:inputField id="candidate" value="{!contactLookup.Candidate__c}" />

Apex

This is used to get the value:

public ts2__Project_Job__c contactLookup {
  get;
  set;
}

This is used to instantiate:

contactLookup = new ts2__Project_Job__c();

So far, so good. It creates the Lookup field on the VF Page and it works great! However, when trying to Insert using the following code:

pro.Candidate__c = candidate;

After initialising pro as:

ts2__Project_Job__c pro = new ts2__Project_Job__c();

I get the error:

Illegal assignment from ts2__Project_Job__c to Id

I've tried using

pro.Candidate__c = candidate.Id;

Which will save and create the record, but won't populate the field. Debug logs show that this is blank, whereas the variable candidate does have an Id in there. It's just the wrong type. I've tried using:

Id candidate = String.valueOf(contactLookup);

And passing this through, but nothing happens again.

Kind of stuck on this one!

Thanks!

Edit: When using:

pro.Candidate__c = contactLookup.Id;

I'm getting the following in the debug logs:

System.NullPointerException: Attempt to de-reference a null object

Best Answer

This assignment will always fail:

pro.Candidate__c = contactLookup.Id;

Any field of type Id has to have the correct Id sObject type assigned to it.

Here's what I see:

pro instance of ts2__Project_Job__c (although you don't show the instantiation, we'll just go with that assumption).
pro.Candidate__c relationship field to candidate data type is Id of Candidate__c sObject type.
contactLookup instance of ts2_Project_Job__c
contactLookup.Id Id of ts2_Project_Job__c sObject type.

Whatever you do, you need to be assigning like for like. Going back to your code:

pro.Candidate__c = contactLookup.Id;

Here you are trying to assign the ts2_Project_Job__c Id value (primary key) to a relationship field that is expecting a Candidate__c value.

You need to assign a Candidate__c id value.

So that could be:

pro.Candidate__c = contactLookup.Candidate__c;

Or it could be a candidate variable from somewhere else:

Candidate__c candidateVariable = getCandidateInstanceFromSomewhere();

pro.Candidate__c = candidateVariable.Id;

It's hard to know without seeing more of your code. But I still get myself twisted around from time to time.

If you have an hour to just learn about how this all works, check out our webinar from September 2014 that did a deep dive on this topic.

Related Solutions

[SalesForce] Can’t get ID from lookup field using ActionSupport

public class tempLookup {

public Case caseMR { get; set; }
public Contact con { get; set; } 

public tempLookup(ApexPages.StandardController std) {
    caseMR=new Case();//Create a new instance 
    con=new Contact();
}

public pagereference obtainAddress() {
    if(caseMR.ContactId != null) {
        con = [select MailingStreet from Contact where Id = :caseMR.ContactId];
    }

    return null;
  }
}

 <apex:page standardController="Case" extensions="tempLookup" showHeader="true" id="casePage" >
   <apex:pageMessages id="pageMessages" />
      <apex:form id="casePageForm">
        <apex:pageBlock title="Case" id="casePageBlock" >       
           <apex:pageBlockSection title="Case Detail" columns="1" collapsible="false" id="caseDetail">
        <apex:pageBlockSectionItem id="caseContactItem">
            <apex:outputLabel value="Contact" />
            <apex:inputField value="{!caseMR.ContactId}" required="true" id="caseContact">
                <apex:actionSupport event="onchange"  action="{!obtainAddress}" rerender="ResContactAddress" /> 
            </apex:inputField>
        </apex:pageBlockSectionItem>
    </apex:pageBlockSection>

    <apex:pageBlockSection title="Contact Address Info" id="ResContactAddress" >
        <apex:pageBlockSectionItem >
            <apex:outputLabel value="Contact Mailing Street" />
            <apex:outputText value="{!con.MailingStreet}" />
        </apex:pageBlockSectionItem>
    </apex:pageBlockSection>
</apex:pageBlock>

You will have to instantiate a new instance to get All the values of contacts else only contact linked with the particular case will come as you guessed .I have completely modified your code .

enter image description here

[SalesForce] Inserting a record with Lookup value

Currently the error message is System.QueryException: List has no rows for assignment to SObject.

This will most likely be coming from the line: (please indicate in your responses which line is throwing the exception)

carts.Code__c = [SELECT Name, code__c FROM Code__c WHERE code__c =:code].Id;

There are a couple of problems with this line:

You are using a short hand syntax that assumes exactly one Code__c record will always be returned by this query. If no records match then you will get the QueryException for no rows.
You are querying the Name and Code__c fields and then using the Id field, which isn't part of the SOQL query.

Instead, try something like:

List<Code__c> codes = [Select Id from Code__c where code__c = :code limit 1];
if(codes.size() > 0) {
    carts.Code__c = codes[0].Id;
} else {
    carts.Code__c = null;
}

Best Answer

Related Solutions

[SalesForce] Can’t get ID from lookup field using ActionSupport

[SalesForce] Inserting a record with Lookup value

Related Topic