.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Custom user selection in Person or Group type column as per other list.

Posted By:      Posted Date: September 14, 2010    Points: 0   Category :SharePoint
I have two list in the Sahrepoint Foundation 2010 site. 1) Projects with Title and members(Person or Group - multiple selection) 2) Tasks (Team site default)  - added lookup column Projects form the first list (required) Now I want to assign task given users in the projects list. ex. I have users A,B,C,D,E and Two Project P1 and P2 I have defined that P1 project has users A,B,C so task is distributed/assigned between this members, not to D and E I need some validation or lookup which restrict selection or D and E.   Thank you.  

View Complete Post

More Related Resource Links

Default Value for 'Person or Group' column in a Sharepoint 2010 Custom List



In Sharepoint 2010 I have a Custom List with a column of the type 'Person or Group'.
I would like to have a default name for this 'Person or group' column.
So when a user creates a new list entry and leves the 'Person or Group' column value blank the list entry should be created with the default value für the 'Person or Group' column.

Is there a way to schieve this?

Many thanks in advance.

Roberto Rocco.



SharePoint 2007 to Access 2007 - Issues grouping by "Person or Group" field type/column

We are on SharePoint 2007 and using Access 2007.  The SharePoint list contains a column called Assigned Person, column type: Person or Group, single selection, displaying only the name 1) When we Open with Access and Export a copy of the data, then create a report from that table, we do not have the option to group on Assigned Person.  2) When we Open with Access and Link to data on the SharePoint site, then create a report from that list, when we group by Assigned Person... The same person has 2 groups - there are is no other grouping or sorts on the list, and i can't locate a correlation to another field to show why they would have to collections for the same person The Person or Group column sorts "from smallest to largest" as though it is a number field. The list is a task/activity tracking system we created custom for our needs.  We want to pull a weekly report, grouped by Assigned Person, but cannot get access to work.  We do not want to resort to anything more complex, as it takes a much longer process to have reports pulled by Chrystal or one of those types of applications.  And we cannot change out the field for something like a Choice column as the list already has a very large amount of content.  Can anyone assist? Is there a setting hiding somewhere that is causing the problem? 

Custom list -- control issue with column type "Choice" and Infopath 2010

I finally got our project lead to abandon external SQL lists, so now I've created custom lists in SP 2010. I have some columns that are of "Choice" type/"Display as radio buttons" (customer requirement). When I start Infopath 2010 locally and create the data connections to the list(s), those choice fields display in I/P as dropdowns. If I change the control with a right-click to "Option Button", I only get one -- I need 2 (yes, no) or, in a few upcoming cases 3 or 4. BTW, same with changing the control to a check box -- only get 1. FWIW, I get the same results if I start Infopath directly from the list in SP Designer 2010. Any ideas?
Joel W. Johnson

Sharepoint List Column Custom Colors With Group By column Option


I have tried to implement the custom coloring or manipulating data on columns in multiple ways like





However, all the above does nto work if you enable the "Group By" column option in the "Modify View" settings. It does work if the "Expanded" option is checked, however, it does not when "Collapsed" option is selected in "Group By" options.

Any help will be appreciated.

Picker returns nothing for BDC column in custom list


Playing with the BDC for the first time, running into some issues adding a Business Data column to a custom list.

I believe my ADF file is solid. I've been able to import that just fine and can use the application to drive various BDC-specific webparts (a Business Data List or Business Data Item, for example). It also seems to work when I manually enter information in my NewForm.aspx field and click the Check Names button (it verifies my entry and underlines it, creates link to profile when I view the list data).


If I try to use the picker, I get nothing. Enter a name I know is valid or a % and click the magnifying glass icon and I very briefly get the "Please Wait" message, then just an empty set with "Type into the search box above then press "Enter" to start your search" where my results should be.

Any pointers? Thanks.

Sharepoint list group by column data ,display in webcontrol like panel or label


I  have a sharepoint list[Managers] with groupby sector column. like below




Each Sector group by column data i want to display in label or panel control.

How to do that ? how to write the logic?



Regards, Mansoor

To create a custom control and type while creating a column


HI All,

i am creating a column in the list while creating a column i will have an option for choice field on selecting choice i can see dropdown, radiobutton, Checkbox to select and  can enter list of values. and on clicking ok i will get a column with radiobutton. in newform.aspx and also in editform.aspx

so i need to create the similar functionality with my custom radio button, so on create column i need to show my custom choce on selecting this i need to show my custom radiobutton  and  can enter list of values then on selecting it then click ok to create a column, in edit form and new form i need to show a radio buttons with values.

Thanks in advance




Cannot delete custom column in calendar list - 'unknown error'

I've created a column in a calendar list and now cannot delete it.  I've cleared all data and I still get the "Unknown Error" message when I try to delete. jan

Best way to display data of a single column from a Sharepoint Custom List

I'm trying to create pages that will automatically populate with data pulled from a sharepoint list (like title, department, contact info, etc.).   I'm using publishing pages. What would be the easiest way to do this, and how would I specify which data to pull from the list? For example, the page would be set up like this: [Title:biology] [Department:biology] [Contact Info:biology]   and when the page loads, it would look like this: Biology Lab Biology Department 123-456-7890   I want it to just pull the data -- I don't want a list view or anything like that.  I need this page to look pretty, and I need the each column's data to show up in a very specific place. How could I make pages that would do that?

Fill person/group column with workflow

Hi all, I would like to retrieve the 'Department' value of the creator of a list-item. Therefore I created a column named 'Department' of type person/group, show field 'department' From a worflow created with SharePoint Designer, when a item is added to the list, I fill the column 'Department' with the field 'created by'. The result is that the column 'Department' nicely displays the Department of the creator of the added item. When I do the same for a library, the column Department don't get filled, and the workflow keeps the state 'Started'. Any idea what I'm doing wrong? Kind regards. #Update When I add a new document te the library, the column 'Department' stay's empty and the workflow keeps the status 'Starting' But when I save a new document, open it again, edit it and save it again, the column 'Department' shows the department of the creator !!

Redirecting to custom page while clicking on the user/group browse button

Hi, i have created a custom visual web part in visual studio 2010 and i deployed it into sharepoint site by creating a new page in my site. The custom page gets the data of users/groups from database and pass the users to the people picker in sharepoint.Here my question i have a document library where we upload document and get the users page popup that consists of people picker and a user/group browse button.when i click on the (book image button)browse button it will redirect to the user and group search page but here i need to replace my custom  user/group search page with the default one so please help me how to redirect to the custom page by clicking on the user/group browse button,and i need to pass the selected users to the people picker text box........please give me some solution whether this can be done or not if possibe please send me the link or some sample code how to do this   thank you.

user role on sharepoint custom list

hi, can i set up a user role for a custom list form in sharepoint services 3 i want to use the "submit new absence" form. but i need to modify the form in a way that when a user open the form it fills the user his name or login name in the fields. and that the approver or "assigned to field" also is filled with the approvers name. i think i need to use a query for that, but how can i apply it to the fields of the absence list form

Mulitple time and user stamped comments for each custom list row?

Does anything int he UI allow for this type of column to be added to a custom list? or would it have to be a seperate list? And on the subject of connecting two list to each other. Ideally, we would connect two lists by the list ID, having one list look up to another. But then the issue is having to know the ID.Anything in the UI allow a user to select one column, but save the ID for that as part of the lookup? Thanks.

Create a list definition without a Custom Content Type

is it possible to create a list definition without creating a custom content type?  I want to create a list definition and select "Custom List" and then I just want to add fields to the custom list and not create a content type that will show up in the SharePoint GUI.  Seems like to get the new fields to show up in the new and edit forms I have to add the fields to a custom content type.

Using EnforceUniqueValues for Built-in column in Custom List.

Hi All, I am back with a new question J.   I am using a built in field (Title GUID - FA564E0F-0C70-4AB9-B863-0177E6DDD247) in a custom list. The requirement is to have this field unique, so I thought of using EnforceUniuqeValues property of SharePoint 2010. Unfortunately this is not working when I set this property to true in list schema.xml. there is no exception or error, the list gets deployed properly however the field is not set to unique. Code looks like:              Sealed="FALSE"              Indexed="TRUE"              EnforceUniqueValues="TRUE"              AllowDuplicateValues="FALSE" />   If I try using the object model (as mentioned in documentation http://msdn.microsoft.com/en-us/library/microsoft.sharepoint.spfield.enforceuniquevalues.aspx), I get SPException while updating the field. I however can set the field unique from UI after the deployment. The SharePoint documentation on this property says it cannot be set for built in columns. Then I wonder why it is allowed from UI.   Please suggest if anyone has any clue on this. If at all it is possible to programm

Inserting a custom list form for a custom content type

Hello, When I try to insert a custom list form for a custom content type I created, nothing happens. Same thing is for the content type "message" & "discussion". I already cleaned up my profile (http://blogs.msdn.com/b/spdsupport/archive/2008/07/03/how-to-fix-custom-list-forms-will-not-insert-or-show-up-on-the-design-surface-of-sharepoint-designer.aspx) I use MOSS 2007 version and SP designer 2007 SP2 on Win7. Below you can see an example of the custom content type.     Columns Name Type Status Source Title Single line of text Required Item Segment Lookup Optional   Form Lookup Optional   Main Product Lookup Optional   Weight Number Optional   Price/Kg Currency Optional   Unit Price Currency Optional   Manufacturer Lookup Optional   Packaging Lookup Optional   PL Yes/No Optional   Label Lookup Optional   USP Lookup Optional   POSC Lookup Required   Place Lookup Hidden StoreCheckHeader Country Lookup Hidden StoreCheckHeader SC_Link Single line of text Hidden StoreCheckHeader

Report Parameter type for a list of Employees to prompt like AJAX Textbox intellisence when the user


Hi All,

I have around 300 employees report to run for a specific employee, I cannot have a Dropdown as it would be too long for the report user to choose from. Is it possible in SSRS 2008 to have a text box that would provide intellisence like AJAX textbox and provides user with Employee name to choose from database or is there any other better way to select the right mployee name to run this kind of report. being a newbie to SSRS I am unable to go furthur on this. All help is great help. Thanks in advance for responding.

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend