+ Start a Discussion
MegachuckmcMegachuckmc 

Formula Field

It seems like it should be possible to create a Formula field in one Object that derives its value from a field in another Object...

Example:

A field called "TestFoo" in Opportunities is a formula field that takes it's value from the "FooTest" field in Accounts...

Is this possible?  - If so what is the syntax for defining the foreign object field since it does not appear in the Select Field Type dropdown in the formula Editor

--------------------------------------------------------------------

In this case I have two custom objects: "Sales Order" and "Sales Order Item" 

In the formula editor my only choices are the Object that I am working in (Sales Order) and other objects like:

$System

$User

etc.

If this makes sense...I want to create fields in the "Sales Order Object" that derive their value from the "Sales Order Item" object.

Harry JamesHarry James

No, that is not available for formula fields.

Winter '08 introduced the ability to use "Related Object Fields" for workflow rules, validation rules, etc.  But not custom formula fields.

 

JohanLiljegrenJohanLiljegren
Rumour has it, something like this is scheduled for Spring '08.