- General Development
- Schema Development
- Apex Code Development
- Visualforce Development
- Formulas & Validation Rules
- Force.com Sites & Site.com
- Chatter Development
- Java Development
- .NET Development
- Perl, PHP, Python & Ruby
- Desktop Integration
- APIs and Integrations
- Visual Workflow
- Apple, Mac and OS X
- VB and Office Development
- AppExchange Directory & Packaging
- Salesforce Labs & Open Source Projects
- Other Salesforce Applications
- Jobs Board
01-04-2013 07:38 AM
Hi all, I am very new to this so please bare with me.
I have created an object which holds data about specific post codes. What I want to do is dependant on the postcode in the account object, is return a result based on whether this postcode from the account is referenced in this other object. Much like the lookup function in Excel.
So the thought process is, if this new account postcode has a match in my object then return a result. If not leave blank.
Many thanks in advance for your help.
01-04-2013 09:44 AM
Can I know where you are using this functionality in class or trigger ?
You are working on bulk data or simply one record?
You can do it by applying queries and looping.
Salesforce.com Certified Developer
01-07-2013 01:37 AM
Many thanks for your reply.
This will be done on one record at a time. I was trying to do it at field level, but it seems using a VLOOKUP in this way isnt possible.
I then tried using it as a trigger, but I get an error saying that a fieldname is requested. This is what my query looks like, in triggers
VLOOKUP (LSOA_AreaLink__r.Scheme__c, LSOA_AreaLink__r.LSOA_Name__c, LSOA_Area__c)
I would welcome any suggestions.