+ Start a Discussion
crocodilecrocodile 

How to create a Formula field to work with other objects...

Hi,

Am trying to create a Formula field in Student custom Object, where the value of this field should refer to a field in Progress custom Object. The Formula is:

 

{!Progress__c.Result__c}

 

but showing syntax error saying: Error: Field Progress__c does not exist. Check spelling.

 

Can any one please resolve the error!

 

Thnx in adv,

VNath

Steve MolisSteve Molis

If Progress is a custom object and you're referring to it in a Cross-Object Formula you need to use double  underscore+lowercase "__r" (for reference)

Progress__r.Result__c instead of Progress__c.Result__c

Pradeep_NavatarPradeep_Navatar

In formula field you can refer fields of itself and of parent object, you need to have relationship between student & progress object. One more thing, only parent object’s fields can be accessible. That means , in your case Progress should be parent of student then you can refer progress’s fields.