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
rob3000rob3000 

Workaround for object reference limit

Hi All,

 

I need a workaround for the limit of 10 object reference limit in EE. 

We have a custom object Visit Report and we have 12 contact lookups [Receiver_1__c, Receiver_2__c, ... , Receiver_12__c] on it. Those 12 contacts shall receive the same email so I have a custom formula field that retrieves all 12 contact email addresses [Receiver_1__r.Email, ...]

Unfortunately there is a limit of 10 references. 

I contacted Salesforce Support to increase the limit to 15. 

Any other ideas? Maybe junction objects?

 

Thanks!

 

Shivanath DevnarayananShivanath Devnarayanan

On top of my head, I can think of using a inline VF page

this will have a multi picklist for all the users that you want to select,
when you generate values for this piclist in your extension Remember to use the label as User's First + last name and Value as their Email address

 

SelectOption option = new SelectOption(value, label);

 Read More : http://www.salesforce.com/us/developer/docs/pages/Content/apex_pages_selectoption.htm

 

When you click save button on the Inline VF page all the selected values are stored into your text field. this approach even lets you select more that 12 users

 

 

Let me know if this works for you.

 

 
rob3000rob3000

Shivanath,

 

Thanks for posting that interesting idea; but using a multipicklist is not an option. There are too many contacts who could potentially be selected and those contacts also change.