Jump to content
Salesforce and other SMB Solutions are coming soon. ×

How to perform calculation on a related field value


dmontano
 Share

Recommended Posts

I have created a "substitute" formula that I run on various fields in order to return a new text string that strips out unwanted illegal cross platform characters and other items I do not want.

 

The formula works well — however I have just encountered field I can not run the calculation on. The only characteristic of this field versus the other fields I have had success with is that it is a value list from a related file. In layout mode, this one field is precedded with the "::" to indicate that it is related data and I suspect that is my problem.

 

In any event, I can not seem to perform the calculation on data from a related drop down value list. Any help or ides is appreciated.

Link to comment
Share on other sites

I just figured it out. Instead of selecting and using in my calculation the field in my database that is holding the related data, I just needed to pull down the drop down menu option and select the related file first in the calculation dialogue and then select which field the data is originating from.

Link to comment
Share on other sites

 Share



×
×
  • Create New...

Important Information

Terms of Use