Can a SharePoint 2010 lookup column point to a multi-line rich text field in same list?

i dont find multiline column while creating a lookup column. Is there any way to achieve this. Because my requirement need such a way to add the values that exists in the other column.

Can i use workflow to make this, then give me some suggestions

  • The short answer is no, however can you describe what you are trying to do, and maybe we can provide a path forward to you. – Jesus Shelby Jul 17 '13 at 12:39
  • I have a column named "question" and while creating a Add new form i need to add some previously added questions related to the current question. So i tried to create a lookup column and tried to add question column as lookup field. since question is a multiline rich text field it is not possible to add. Convey me some suggestions on this – Arul Jul 17 '13 at 13:01
  • is no one got it what i am asking for? – Arul Jul 18 '13 at 8:07
  • You can use a calculated column to achieve your desired functionality! – Taran Goel Sep 29 '15 at 6:20

Yes you can, with a custom product.

First, you can do what Monica suggested - only I wouldn't go with a workflow. It is an overkill to my taste. I would create a new text column (possibly hidden / read only) and use a list item event handler on item updating / creating. you can use the multi line text field SPField.GetFieldValueAsText to get the value without HTML decorations!

But, for your solution, allow me to recommend a product that does what you need: If what you need is more information in the lookup than just 1 text field in order to make the selection (Say, title only doesn't identify the item and you need to see title + notes + status + created by + created date when selecting) - then a dropdown is just not enough for you.

In this case, I can recommend a product that does the lookup using a grid with checkboxes for selection: http://www.kwizcom.com/images/CascadingLookup/CascadingFilteredLookupField/ImageGallery/big/CLF4.jpg

This way, you can set up the lookup to show multiple columns including multiple lines of text columns when viewing or editing the item, but the lookup will still be tied to a simple single line of text column.

Search for "kwizcom cascading lookup plus" in google for examples, or visit: http://www.kwizcom.com/sharepoint-add-ons/sharepoint-cascading-lookup-plus/overview/

| improve this answer | |

If u can save the sub string of the question in single line of text and then lookup on single line of text column ....

| improve this answer | |
  • can u explain me little bit clear.. – Arul Jul 18 '13 at 11:40
  • Let save on item created / edited , start a designer workflow which will take sub string of multi line of text column say 250 characters and populate to single line of text. Next configure your lookup column on single line of text. – Monica Jagani Jul 18 '13 at 12:48

Short easy answer is to use a single line text box. There's a 255 character limitation but it should suffice if you're just using it as a question field.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.