I hae a custom object based on zip codes. I need to populate sevral custom fields on the account object based on the Billing zip code. Since workflows do not allow the use of vlookup, how do I do this?

Question

Anshul Jain · Answer

Hi Richard,

We had a similar requirement where in we used Formula fields on accounts which got auto filled form the custom object field.

At one instance, we created a look up field on Account with the custom object. Then made it to update to Zip Code (via workflow) and that pulled all other fields.

If i populate the look up field with a record from the custom object (Area - in the image given below)

Hi Richard, We had a similar requirement where in we used Formula fields on accounts which got auto filled form the custom object field.

Post saving the account record this is how it looks like,

The formula for the Fields on account for the above scenrio was

Area_6__r.Area1__c

Let me know if this helps,

Warm Regards,

Anshul Jain

I hae a custom object based on zip codes. I need to populate sevral custom fields on the account object based on the Billing zip code. Since workflows do not allow the use of vlookup, how do I do this?

Sales And Marketing

Formation associée

Aide supplémentaire