.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

Create list and allow only one item per user

Posted By:      Posted Date: October 05, 2010    Points: 0   Category :SharePoint

I'm trying to create a list where each user can only create one item, and change the item he has created.

I also need the list to allow each user to view only his own item

When I create a custom list and configure it so that each user can only view and edit his items and after that I try to configure a column validation to allow only different values it gives me an error saying that a list where a user can only see his items cannot have that type of column validation.

I was trying to use this type of validation on a column because I had the column to be auto-filled by the new/edit form (customized via infopath) with the user's username, that way I could ensure that only one item per user would ever exist. However, since I am not allowed to configure the column validation this way, I can't go this route.

Is there a simple way to achieve the effect I am looking for?

View Complete Post

More Related Resource Links

How to Set a list item's createdby or modifiedby field as a User(deleted from AD)



I have to migrate data from SQL DB to SP list. But its old data and some users who created/modified the record has been deleted from the AD. Now I need to set the CreatedBy / ModifiedBy Field of the item accordingly. How to achieve this?

And when I tried to modify the "Editor" and "Author" field through Object Model, it works. But its not working through Webservice. What is the reason behind this?

Please help me find an optimal solution for this...


Thanks and Regards,

/* John JB */

How to create a list filter like: get all list elements from the current user and all employees from

Hello, is it possible to filter elements by the condition mentioned in the title? Tobias

Create discussion list item from another (non-discussion) list item ?

I am looking at creating a custom list to track bugs. I would like to have a comments/description field that either embeds or links to a discussion. is there a way to automate the creation of a discussion item from the bug list item or is the process 1) create bug list item 2) create discussion item 3) paste URL of discussion list item in 2) to the comments field/column in 1) All opinions/thoughts/advice appreciated regards, Counie

Create a List on the User's my site

Hi guys, I need to create a list on the user's "my site" portal. How can I do?

Workflow - automatically create discussion item using title field of of custom list item as its subj

Anyone any ideas as to how I can configure SharePoint to create a discussion item using the title of a list item. e.g. user creates list item on a custom list - SP automatically creates a Discussion thread for this list item in the discussions list. I'm guessing this can't be down OOTB . would I be looking at SPD or a coded solution ? regards, Counie

How to create pre-populated links list that user can personalize

How can I create a pre-populated links list that the user can personalize?

Create workflow to create list item in calendar list of a DIFFERENT site collection


I work for a school district.  Each school has a SharePoint calendar.  We set up each school as its own site collection.  I would like to create a workflow that would send their calendar events to a district calendar, which is also its own site collection.

Example,  School A enters creates a new item on their personal school calendar.  They click YES in the column called SendToDistrictCalendar.  The workflow would be triggered to create this same item in the district calendar (which is in a different site collection) when SendToDistrictCalendar is checked YES.

We're using Windows Server 2003 with Windows SharePoint Services 3.0

I am a mid-level SharePoint user.  I would appreciate ANY and ALL help to make this work!!


How to Create Sharepoint Workflow (designer) on Calender List when a new list item is created



I need to create a sharepoint designer workflow on Calender List.The functionality is that, Workflow on Calendar list that sends an e-mail notification each time new event is created along with event details.

Any help appriciated..



Srikanth Reddy


How to use Designer to create a WF to collect data and update item in the list



I’m trying to create a workflow in SharePoint Designer 2007 to finish the item in the list. In the list, I setup 10 fields (Name, Address, Phone#....), and in the workflow, I set it to start automatically when a new item added in the list (I can add a new Name in the list to start the workflow).


In the step1:

The Conditions is: “If Address is empty”.

The Actions is: “Collect all data from lw1990 (Output to Variable: collect1)


At this point, I don’t know how to update the current item in the list with the data that just collected from user in Variable:

Create a link to the most recently created item in a list.


Hi all,

I have a list, that a user must re-visit several times a day.

I have a web-part page that contains a series of URL links to the above list (each link is clicked on at a different time of the day).

The idea is that the first link takes the user to NewForm.aspx to create a new list item for that day, but I then want the other links that they click on later in the day to take the user to the SAME list item they created earlier.

i.e. EditForm.aspx?ID="the one they created at the start of the day".

How can this be acheived? Do I need to determine the last item in the list (which would always be the one they need to re-visit)? Do I create some kind of workflow that stores the date and time stamp and then is called in the URL as a parameter when passed to the EditForm.aspx page?

The user would be the only one working on this list during any given day, so there's no danger of a different user "intercepting" a list item first.

Thanks in advance!


Workflow - Create New List Item with lookup field


I have an 'Item list' that has 'ItemName' as a string. The Workflow creates a new 'Task' when a new Item is created. The 'Task' has 'Item Name' as a lookup to that 'Item list'.

I want the Workflow to "Create New List Item" and fill in the 'ItemName' lookup (in Task) with the 'ItemName' string (in Item).

The workflow won't do it because they are different 'types'. Is there a way around this?   

Create List Item - error message



We have recently purchased oneplacemail and I have setup a list that takes the email metadata and stores it, what I wanted to do is a workflow that fires off when a new record is added to the list (i.e. when a new email is dropped in)...and create a new record on another list holding this information and allowing users to add more data to other fields.

I have created a workflow in SPD that uses the CREATE LIST ITEM action, I've set which fields from the email-drop list to populate the fields in the other list and it all seems fine.

I've tested it out and I just get two generic errors -

DESCRIPTION - Error updating a list item
OUTCOME - Unknown Error

DESCRIPTION - An error has occured in <workflow name>

I wondered if it was because the field types for the columns in the email-drop list are not the same as the field types in the other list...even though the data that I want it to create would hapily go in there.  For example, one of the email-drop list columns is EmTo, containing metadata from the TO field of the email...this holds the data as <surname>, <forename>....which is exactly how it is held in the other list except that the field type is PERSON OR GROUP.

This is Sharepoint 2007.

How to create list item on different site calendar after workflow approval

I have a vacation request located on our corprate home page that is available to all departments.  we have more department sites within the same site collection, each having their own calendar.  I am wondering if its possible to have the workflow create a list item on a different site calendar IF the department equals "other department".  So all departments submit the vacation request from the home site, then when it is approved the calendar in their department is updated.

Create list item in library - Output variable



I want to create workflow in SPD, that create new item in document library.

I use Create list item on library (output to Variable:create)

The documenty was created sucessfully, but the output didn't return the ID of item created.

In the documentation says, that function return the ID of item created.

Is maybe some other way, to get the ID of new created item in document library.


Best regards

how to programatically retrieve permission of a user on a list item?



            is it possible to retrieve the permission of a user on a list item programatically.? i mean if a user has the rights Contirbute on the list item can i get that programatically that he has Contribute rights?

 please help. your help is appreciated.


How do I add user entered item to choice list items programmatically?


Hi friends,

I have been a share point developer for five months and I have a question that how to add user specified values to choice items.

Here  I ill give you the short probelm definition.

I have the list named as "Emloyee list" with two fields, are "Name" and "Offices".

The value for the field is "Name" is to enter bye the user (E.g: Kumar)

After that the field "Offices" is the choice list with the default items("Office1,Office2,Office3..) and the user has selected the option as Office2.

Now the the list has one row of information as

Name         Offices

Kumar        Office1

Like wise we can add the list items.

In the ablove context for the field "Offices" I need to add the choice items dynamically so that the user no need to follow up the asusal strategy that.. By selecting Settings->List itemsettings->selecting column name.. add the 4th choice option like "Office4"..

I hope u understand my requirement.

Can anybody please help me in this regard.

Thanks in advance,



Creating Sites/Lists/List Items under Current User Context in SharePoint By Using SPUserToken

Usually we do this by performing the action under RunWithElevatedPrivileges method and updating the listitem using SPListItem.SystemUpdate() method (see here). but this approach has its own flaws like (RunWithElevatedPrivileges will run under system account, we cannot use SystemUpdate for SPSite,SPWeb,SPList, since it runs under system we will "CreatedBy" by as SystemAccount).
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