6

In SharePoint there is a Quick Edit Button in the Library ribbon under "View Format".

How can I enable the library to be shown in Quick Edit mode as the default?

Could I make a "Quick Edit" view?

  • Do you want to show a QuickEdit View by default? OR you want to open the Ribbon by default? Or is there any issue with QuickEdit button in your site? – sekhar Aug 5 '15 at 17:30
  • I want to have a View with set Quick Edit button by default. – Grzegorz Z Aug 6 '15 at 7:07
  • Added answer below – sekhar Aug 6 '15 at 12:01
10

If you are wanting the document library to show the Quick Edit View by default just follow these steps.

  1. Create a new view. Beneath "+ new document" you should see "All Documents" click on the dots to the right and click "Create View".

  2. On the View Type page that appears click the view type of "Datasheet View" (in the right column usually)

Choosing the View Type

  1. Name the view what you wish in the Name section and be sure to check the "Make this the default view" box, be sure to check the columns you want to display as needed. Then click "Ok" at the top or the bottom of the page.

Setting this created view as the default/settings too

  1. You will be back at the library page and the default view will now show your documents listed in the Quick Edit mode!

Quick Edit is now the shown on opening the default view.

  • 1
    @Grzegorz Z did this work for you? – calebben3 Aug 5 '15 at 19:21
  • Bo I tried, but I have got Excel View, not Quick Edit View. Sometimes I have got Excel View in some Libraries, and sometimes I have got Quick Edit on the View. I don't know why. – Grzegorz Z Aug 6 '15 at 7:06
  • 1
    I just added some images to the steps. Perhaps they will help. – calebben3 Aug 6 '15 at 12:45
  • Yes i tried this, but after this i have got Excel View with access. Not Quick Edit. – Grzegorz Z Aug 7 '15 at 7:09
  • Can you edit your question above to include a screenshot of what you DO get after following my steps? I just want to see what you're seeing so I can possibly help you get what you want at the end. – calebben3 Aug 7 '15 at 12:41
5

Create a New View the way @calebben3 describes. Select Datasheet View

Datasheet view

and make it default view Make it default view

Next time You open the library it will show up in Quick Edit mode ( same as Datasheet view).

  • 1
    Not sure why you posted almost the exact answer as @calebben3? It would be preferable to instead suggest an edit to that answer (since the only difference at the time was the screenshots). – Robert Lindgren Aug 6 '15 at 15:58
  • Sorry for that @RobertLindgren . Just wanted to "visualize" the answer a little bit more. It should have been an edit.... – Magnus G Aug 7 '15 at 9:25
  • No problem, we are all new in the beginning – Robert Lindgren Aug 7 '15 at 11:06
5

Add a custom button above your List View Web Part.

To do this execute a JS function on click of it.

Use this to open Quick Edit:

InitGridFromView(window['WPQ2SchemaData'].View);

Use this to exit Grid View:

ExitGrid(window['WPQ2SchemaData'].View);

You can also use the following code to check the status of web part:

var gridinfo = GetCtxFromView(window['WPQ2SchemaData'].View);
        if (gridinfo.inGridMode) {
        //in grid mode
        }else{
        //in normal mode
        }

If you want to open the Quick Edit view by default, create a data sheet view instead of standard view.

  • But how implement it to the view ? By Script webpart ? – Grzegorz Z Aug 7 '15 at 7:07
  • add a content editor webpart, point it to a html file in your SiteAssets or somewhere. write html markup for the button and add this script. – sekhar Aug 7 '15 at 16:38
  • While the accepted answer is the right one for this specific question, this is an awesome StackExchange answer, showing exactly what many of us here really want to know and not just the basics! Thank you! – Martin Laukkanen Jan 3 '17 at 8:07
  • To get the exact wpq Number, we have to place the script in postrender method of jslink for webpart. We can get the wpq Number using ctx.wpq – sekhar Aug 24 '18 at 13:54
1

Are you talking about this button?

enter image description here

To have access to that button, you need to have at least Edit permission on the site.

0

To add a custom Quick Edit button to your page or view, add a Script Editor web part and embed the following code. Make sure you change the number in [WPQ2SchemaData] to the web part number of the list/library you want to Quick Edit. You can find that by inspecting the list/library web part using Developer Tools (F12).

<!DOCTYPE html>
<html>
<body>

<button onclick="QuickEditFunction();return false;">Quick Edit</button>

<script>
function QuickEditFunction()
{
InitGridFromView(window['WPQ2SchemaData'].View);
}
</script>

</body>
</html>

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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