function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ 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 :-/Steve :-/

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.