{"id":4678,"date":"2019-02-18T12:54:38","date_gmt":"2019-02-18T17:54:38","guid":{"rendered":"http:\/\/lisa.rushworth.us\/?p=4678"},"modified":"2019-02-13T12:56:15","modified_gmt":"2019-02-13T17:56:15","slug":"did-you-know-you-can-quick-edit-sharepoint-lists-by-default","status":"publish","type":"post","link":"https:\/\/www.rushworth.us\/lisa\/?p=4678","title":{"rendered":"Did you know \u2026 you can Quick Edit SharePoint lists by default?"},"content":{"rendered":"

Web forms are fine for one-off data entry, but the default SharePoint list view is inefficient for bulk item updates. Since you can create your own list views, and you can set your<\/em> view as the list default \u2026 you can have lists open in the Quick Edit view.<\/p>\n

Click the not-quite-a-hamburger menu between the list name and \u201cList\u201d, then select \u201cSettings<\/p>\n

<\/p>\n

Scroll down to the \u201cViews\u201d section and click \u201cCreate view\u201d<\/p>\n

<\/p>\n

Select \u201cDatasheet View\u201d as the basis for your new view<\/p>\n

<\/p>\n

Give the view a descriptive name. You might not<\/em> want to set the view as the default just yet \u2013 create it, verify it looks good, then<\/em> set it as the default. Or, like me, you might be a combination of impatient and confident \ud83d\ude0a Either way, select to create a public view.<\/p>\n

<\/p>\n

Check off the columns you want to include, uncheck any that you don\u2019t need.<\/p>\n

<\/p>\n

Select how you want your list sorted \u2013 I am sorting by the record creation time, but you can sort and sub-sort by whatever columns make sense for your data.<\/p>\n

<\/p>\n

You can also filter items displayed in your view \u2013 my example is order entry, so maybe a ship date column is superfluous for data entry and programmatically populated by some order fulfillment process. Or you can leave the data unfiltered. Scroll down and click \u201cOK\u201d to save your view.<\/p>\n

<\/p>\n

If you didn\u2019t<\/em> make your view the default, click the drop-down by the view name and select your view to test it. Return to the list settings and click on your view name to edit it and set it as the default view.<\/p>\n

<\/p>\n

Now that my datasheet style view is the default, my list opens in the \u201cQuick edit\u201d, and I can update lots<\/em> of records.<\/p>\n

<\/p>\n

<\/p>\n

Asdf<\/p>\n

<\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

Web forms are fine for one-off data entry, but the default SharePoint list view is inefficient for bulk item updates. Since you can create your own list views, and you can set your view as the list default \u2026 you can have lists open in the Quick Edit view. Click the not-quite-a-hamburger menu between the …<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[677],"tags":[415,747],"class_list":["post-4678","post","type-post","status-publish","format-standard","hentry","category-office-365","tag-sharepoint","tag-sharepoint-online"],"_links":{"self":[{"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/posts\/4678","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4678"}],"version-history":[{"count":1,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/posts\/4678\/revisions"}],"predecessor-version":[{"id":4690,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/posts\/4678\/revisions\/4690"}],"wp:attachment":[{"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4678"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4678"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4678"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}