Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I have one list to store information about people, and another list storing a list of tasks each person should achieve. I'm trying to create a SharePoint view which allows users to enter/modify people, and also tick off the tasks that person has achieved - each row will list the columns from the "people", list, followed columns containing a checkbox for each task row in the "tasks" list.

We are using a hosted instance of SharePoint 2010 Foundation edition. Am from an ASP.net/C# background and have just got started on SharePoint 2010 within the past week, so don't mind getting stuck into SharePoint Designer or Visual Studio to create a custom Web Part if I have to :)

Thanks in advance for any advice given.

Chris

share|improve this question

4 Answers 4

The OOTB lookup column supports multiple values in the following UI: enter image description here

But I think you can create your own column based on lookup and implement custom field control (http://msdn.microsoft.com/en-us/library/ff679964.aspx#bk_custfieldtype) where you will be able to get field value and render it as multiple check box. It's not so much work to do.

share|improve this answer
    
Thanks for the prompt response and link for implementing custom field controls. The in-built way of selecting multiple values is a bit too cumbersome for us; a "grid view" is required so the user can quickly specify multiple people completing the same task. Any other suggestions for doing this OOTB appreciated.... –  Mr Chris Feb 21 '12 at 10:12
    
I don't think there's any OOTB functionality to do it. :( –  Alex Boev Feb 21 '12 at 10:46

What you're looking for is the built-in Datasheet View:

When looking at your list, select the 'List' tab (under 'List Tools' at the top), and click 'Datasheet View' (second from left). This will allow you to enter users in an Excel-like fashion.

Multi-value lookups are displayed as a multi-select checkbox list in the DataSheet View (once the cell is selected), which I believe will suits your needs.

share|improve this answer
    
This is very close - thanks for pointing it out. Ideally the checkboxes should be placed horizontally, but this is a good starting point. –  Mr Chris Feb 24 '12 at 2:03

Take a look at the Extended Lookup Field available at Codeplex.

This project installs a custom lookup field, which allows the user to choose the item through a SharePoint 2010 popup.

share|improve this answer
    
Thanks. One to look at further down the road. –  Mr Chris Feb 24 '12 at 2:04

Check this link: http://www.sparqube.com/sharepoint-lookup-column/. It is for edit lookup values using checkboxes.

NOTE: This is a commercial product.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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