+ Reply to Thread
Results 1 to 2 of 2
This is a discussion on Create a Case via PHP with a lookup field within the Salesforce Coding Discussions forums, part of the Salesforce category; Hi, First: Thank you for that forum, it helped me a lot
  1. #1
    Leviathan is offline Junior Member
    Join Date
    Dec 2009
    Posts
    1

    Create a Case via PHP with a lookup field

    Hi,


    First: Thank you for that forum, it helped me a lot since now...


    Here is my problem:

    We have a Client Area which creates a Case in SalesForce. But in this area I can only attach the Account number (=name) of our clients.

    What I want to do (I hope it's possible) is to create a Case which should be connected with a Contact, so that everybody can see the email address.

    Means:

    Case -> Account number -> Contact (connected with the Case)


    I hope I've described the whole situation clearly?



    Cheers

    Leviathan

  2. #2
    sfisher is offline Junior Member
    Join Date
    Feb 2010
    Posts
    7
    Not sure I completely understand, but the Case object has a standard field that is a reference (a lookup) to a record in the Contact object. You can get to the contact email field in your SOQL via "SELECT ContactId__r.Email from Case where Id=xxxxxxx" where the xxxxxxx is the Id of the Case record. You then have the e-mail address of the Contact associated with the Case. Note that to do relationship queries I think you need to be using PHP version 5.3.

    Stan

+ Reply to Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

SEO by vBSEO 3.5.2