• @DBohrisch
  • 5 Points
  • Member since 2014
  • SalesForce Administrator / Developer
  • Conversant

  • Chatter
  • 0
    Best Answers
  • 0
    Likes Received
  • 1
    Likes Given
  • 0
  • 4

Hey community,

I'm struggling with the logic of the task...

To complete this challenge, add a validation rule which will block the insertion of a contact if the contact is related to an account and has a mailing postal code (which has the API Name MailingPostalCode) different from the account's shipping postal code (which has the API Name ShippingPostalCode).Name the validation rule 'Contact must be in Account ZIP Code'.

A contact with a MailingPostalCode that has an account and does not match the associated Account ShippingPostalCode should return with a validation error and not be inserted.

The validation rule should ONLY apply to contact records with an associated account. Contact records with no associated parent account can be added with any MailingPostalCode value. (Hint: you can use the ISBLANK function for this check)

Here is what I got so far:

 MailingPostalCode  <>  Account.ShippingPostalCode )

I THINK I know how to see if the contact mailing zip is not the same as the account shipping zip, and only if the is not blank.

The part I am stuck on is if the "Contact records with no associated parent account can be added with any MaiilingPostalCode value"...

I don't know what to do with that.

Also, I am now getting the error message when I recheck challenge:

Challenge not yet complete... here's what's wrong: 
There was an unexpected error in your org which is preventing this assessment check from completing: System.DmlException: Insert failed. First exception on row 0; first error: FIELD_CUSTOM_VALIDATION_EXCEPTION, Contact_must_be_in_Account_ZIP_Code: [] 

Double help, please.

I need to create several validation rules off the back of the same process - we have a picklist and we need to enforce that if A, B or C are selected from A, B, C, D or E, that another field on the page becomes mandatory. I cannot find any code anywhere to create this and am struggling with the CASE and ISPICKVAL functions. Can anybody help? Thanks so much,

Hi All,


Are there any approaches to invoke APEX class via workflow?


Thanks in Advance

I want to pull in a value from a picklist froma custom Account field into a related custom Opportunity field.

Account = DOD,  Business Unit =  Federal.  Opportunity = "Army Procurement Project",  Account = DOD,
Business Unit = Federal.
I need the Opportunity Business Unit value to be automatically pulled from the Account Business Unit field where Account = DOD.  The Account Business Unit API name is Business_Unit_c.  The value "Federal" was selected on Account object from a picklist.

Help with the syntax and an example would be appreciated!  Thanks!
  • January 22, 2010
  • Like
  • 0

Job Id Number 11-0025
Position Type Regular Hire
Position Title SalesForce Development Lead

Mitchell International, Inc. is the leading provider of enterprise data, software and eBusiness solutions for the automotive insurance, collision repair, medical claims and glass replacement industries. With over 1,000 employees, Mitchell provides enterprise software solutions and services to the automotive repair and property and casualty industries. Mitchell has been providing automotive information and high technology to these industries since 1946 and is the preferred solutions provider to over 100,000 customers in the United States and Canada with over 137 product titles. Mitchell offers a competitive compensation and benefits package including outstanding career growth opportunities.


The Software Engineer plans, designs, develops and tests software systems or applications for software enhancements and new products.  This includes develop solutions based on business requirements and.  The Software Engineer uses skills as a seasoned, experienced professional with a full understanding of CRM industry practices and company policies and procedures; resolves a wide range of issues in imaginative as well as practical ways.  Works on problems of diverse scope where analysis of data requires evaluation of identifiable factors.  Demonstrates good judgment in selecting methods and techniques for obtaining solutions. Networks with senior internal and external personnel in own area of expertise
Job Requirements 

3-5 years experience working with Salesforce.com force.com (Visual Force) and Apex SFDC Certified Developer Preferred. Experience with Integrations to other systemsExcellent knowledge of page layouts, workflow rules, validation rules, triggers, etc.Demonstrated use of SDLC processesPrevious experience with .net or java development a plusGood knowledge of EclipseHave worked on Saleforce.com instances with 500+ usersSQL query language and related database experience is a plus. College diploma or university degree in the field of business administration, computer science, or management information systems or equivalent work experience.Experience understanding and developing design documents from business requirements Excellent analytical, mathematical, and creative problem-solving skills. Excellent understanding of the organization’s goals and objectives. Excellent written and oral communication skills. Excellent listening and interpersonal skills. Logical and efficient. •Keen attention to detail. Ability to conduct research into systems issues and products as required. Ability to communicate ideas in both technical and user-friendly language. Highly self motivated and directed. Ability to effectively prioritize and execute tasks in a high-pressure environment. Strong customer service orientation.Experience working in a team-oriented, collaborative environment


Visit us and apply at: www.mitchell.com/careers