I am writing one Visual force Email template.

There is one field (Let's call it Field A) on the contact page, which is look-up field that link to account. 

I want to get the account name by field A, but I could only get the account's ID, right now. 

If this field link to another customed object, we can use

obj1__c.obj2__r

But in this scenario it's account, how could I get the Account Name? 

Also I think about to use SOQL, but is that right choice for Email Template?

I don't know if I explain it clearly, if not, I can write more, thank you for checking my question. 

Update 2013-05-14

Sorry I didn't explain it very well, in my template.

• Recieve is User
• Related object is Contact.

The field A is an look up field to account, I want to get the Account Name by field A. 

Hi everyone,

I have data coming to a salesforce object from a third party tool like this:

ID  |  field1  | field2 | criteria1importance  |  criteria1score  |  criteria1competitorscore | criteria2importance  |  criteria2score  |  criteria2competitorscore

i want to split this in a parent child relationship like this :

parent object :

ID  |  field1  | field2 |  criteria(foreign key)

and child object :

criteriaName  | importance  | score  | competitorScore

hope that makes sence, i have been searching for this since 2 weeks :/
Thanks in advance.

I am writing one Visual force Email template.

There is one field (Let's call it Field A) on the contact page, which is look-up field that link to account. 

I want to get the account name by field A, but I could only get the account's ID, right now. 

If this field link to another customed object, we can use

obj1__c.obj2__r

But in this scenario it's account, how could I get the Account Name? 

Also I think about to use SOQL, but is that right choice for Email Template?

I don't know if I explain it clearly, if not, I can write more, thank you for checking my question. 

Update 2013-05-14

Sorry I didn't explain it very well, in my template.

• Recieve is User
• Related object is Contact.

The field A is an look up field to account, I want to get the Account Name by field A. 

Hi everyone,

I have data coming to a salesforce object from a third party tool like this:

ID  |  field1  | field2 | criteria1importance  |  criteria1score  |  criteria1competitorscore | criteria2importance  |  criteria2score  |  criteria2competitorscore

i want to split this in a parent child relationship like this :

parent object :

ID  |  field1  | field2 |  criteria(foreign key)

and child object :

criteriaName  | importance  | score  | competitorScore

hope that makes sence, i have been searching for this since 2 weeks :/
Thanks in advance.

Folks,

If you try using the isempty() function similar to the list and set methods  for strings then it will throw an error.

Instead use the below syntax

String st = 'Hello'; 
Boolean val= String.isEmpty(st);

Thanks,
Rakesh B