Using JoinFieldValue to get related information

In OnDemand there is a undocumented method JoinFieldValue which can be used to retrieve related information from associated records in Advanced field management and workflows

The construct of this function is something like 

JoinFieldValue(‘<Account>’, [<AccountId>], ‘<AccountType>’)

where “Account” refers the object from where you want to retrieve a field, AccountId refers to the foreign key field and AccountType is the field to be retrieved from Account record

This function is going to be useful in scenarios like retrieving the AccountType field from the related Account record in an opportunity record / opportunity related workflows to perform field defaulting, fied validation, workflow rules etc


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s