locked
Disable adding/deleting rows in a list's datasheet view but keep editing intact RRS feed

  • Question

  • We often get requests to remove the users' ability to add/remove items from our sharepoint lists, while still allowing them to edit existing items. We've traditionally accomplished this by adding some custom javascript to hide the New/Delete buttons in the various list forms. Not pretty, but it works.

    However, our latest request also asks that we do this even if the user clicks "Edit in Datasheet". They want to keep the datasheet view itself, and allow individual rows to be editable, but to disable adding/deleting new rows.

    Is this possible?

    Monday, August 6, 2012 1:29 PM

Answers

  • I would create a custom permission level that allows editing, but prevents Add & Delete.  Assign this permsision level to the users and/or groups.

    Steve Clark, MCTS | Twin-Soft.com & Easy Bins Dumpster Rentals of Northern VA. (Specializing in driveway-sized roll-off dumpsters.) Be sure to click one of the forum buttons that inflates my narcissitic points ego.

    • Marked as answer by Yoten Tuesday, August 7, 2012 1:22 PM
    Monday, August 6, 2012 4:06 PM

All replies

  • I would create a custom permission level that allows editing, but prevents Add & Delete.  Assign this permsision level to the users and/or groups.

    Steve Clark, MCTS | Twin-Soft.com & Easy Bins Dumpster Rentals of Northern VA. (Specializing in driveway-sized roll-off dumpsters.) Be sure to click one of the forum buttons that inflates my narcissitic points ego.

    • Marked as answer by Yoten Tuesday, August 7, 2012 1:22 PM
    Monday, August 6, 2012 4:06 PM
  • Thanks for the response! I don't have much experience on the permissions side of things... is this something that can be done on a per-list basis? Not all lists need to be locked down this way.
    Monday, August 6, 2012 9:02 PM
  • Permissions are everything in SharePoint.  Anytime you design anything, it is in your best interest to think about the permissions first, and functionality second.

    With that, permissions can be applied at both the Library and Individual item level.


    Steve Clark, MCTS | Twin-Soft.com & Easy Bins Dumpster Rentals of Northern VA. (Specializing in driveway-sized roll-off dumpsters.) Be sure to click one of those forum buttons that artificially inflates my narcissitic ego... I mean gives me points.

    Tuesday, August 7, 2012 12:47 PM
  • Great, thanks!
    Tuesday, August 7, 2012 1:23 PM
  • I have a list that displays a default view in datasheet.  The list is filtered on [Me] so the current user only sees their existing list items.  When I try to implement any type of security on a user group other than Contribute or Full Control, any users assigned to that group no longer see their records in the list.  The list displays empty and is NOT EDITABLE either.

    Any ideas?

    Monday, September 17, 2012 6:01 PM
  • My guess is that you've made it too restrictive.  So, start by just trying to get data to show in a view for the group defined, then work your way up to the [Me] filter.  Baby steps... which will help you troubleshoot along the way.

    Steve Clark, MCTS | Twin-Soft.com
    Easy Bins Dumpster Rentals of Northern VA. (Specializing in driveway-sized roll-off dumpsters.)
    Be sure to click one of them there forum buttons that artificially inflates my narcissitic ego... I mean gives me points.

    Tuesday, September 18, 2012 2:08 PM