Find your content:

Search form

You are here

Multiselect page from a lookup


Is it possible to relate multiple records to a single lookup field (or) Is there a way to create a multiselect picklist/longtext field and dynamically fill in a related object info in the picklist, where the user can have a clickable link to the record?

Please let me know if there is a hack to do this.

Attribution to: Rao

Possible Suggestion/Solution #1

If you went with a multi-select picklist you could use a formula field to generate the links.

Example formula field definition using a multi-select picklist:

IF(Includes( LinkSelect__c , "Google"),  HYPERLINK('','google') ,"") & " " &
IF(Includes( LinkSelect__c , "Bing"),  HYPERLINK('','bing') ,"")

Things to consider:

  • The Hyperlink function will work with fields so you can have dynamic data
  • This approach requires hard-coding values for the comparison
  • You can see more about Includes and Hyperlink in the documentation

Attribution to: Mike Chale
This content is remixed from stackoverflow or stackexchange. Please visit

My Block Status

My Block Content