Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Restrict List Edits to Original Entry Author?

  Asked By: Grayson    Date: Jul 10    Category: Sharepoint    Views: 2093

The goal is to collect safety concern information in a Team Site List.

We need for all members of the Team Site to be able to see all the
previous List entries and to add new ones - and to be able to correct
or modify the ones they entered - but we don't want a team member to be
able to edit someone else's submissions.

I've got the submitter's username as a calculated field so that will be
automatically stored in the List, but I haven't a clue on how get the
List to not let anyone else edit an entry.

Any slick way of doing this?



4 Answers Found

Answer #1    Answered By: Megan Martin     Answered On: Jul 10

This may sound a little strange, but you could adapt a survey list  to meet your needs. It has the required security features built in, and you can pretty much customize it how you wish.

Answer #2    Answered By: Donta Kirkland     Answered On: Jul 10

Why can't you use the item level security for this? Any custom list  provides that feature where you can set only the person who enter an item can edit  them. In the list settings go to change permission for this list and in the left you will find Modify Item-level security. There you can set the read access and the edit access.

Answer #3    Answered By: Cade Velazquez     Answered On: Jul 10

it turns out that a custom list  has the same
check boxes for viewing / editing that the survey does, so that will
take care of my problem.

I did get excited about using a survey - it seems to be more adapted
to what I was trying to do - until I learned that there is apparently
no way to link an Access table to a survey list. The only option is
to export (NOT link) a survey to Excel format - and even there, when
I do it the error associated with http://support.microsoft.com/?
kbid=828809&FR=1 pops up when Excel finishes the import and shows the
following text:

"This list has hidden columns or read-only columns that require data
but for which no default value has been specified. Existing rows in
this list may therefore be edited, but new rows cannot be inserted."

Apparently there are some extreme issues if your survey contains a
rating scale - per notes found on the web, those don't seem to make
it to Excel at all. Multiple choice (check box style, not option
buttons) come in as text(?) format like

Choice #1;#Choice #3

and that may mess up Access if it was expecting anything except text
for that field  - I've not tested that.

Back to the error message that poped up when I imported the survey,
the Excel list has all the data in the survey and two additional
columns preceeding it - an ID column and a Created By column, but I
don't see any missing columns.

It looks like there may be the possibility of an end-run of now
trying to link an Access table to the Excel list - if Excel is set up
to auto update the list when it opens. I guess this would require an
Access macro to open Excel to get the new list imported before the
Access table of survey results could be used - but I'm not certain
how to deal programmatically with Excel's popup of a form that asks
you if you want to update the list.

But at any rate, thanks for the insights and thanks for putting up
with my rant :). I may post this workaround concept in a separate
note and see if anyone has any experience, insights or improvements
on it.

Answer #4    Answered By: Ariana Christensen     Answered On: Jul 10

It sounds as though it will be easier using the custom list.

Didn't find what you were looking for? Find more on Restrict List Edits to Original Entry Author? Or get search suggestion and latest updates.