多维表格
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
 
 
 
 
 
 

1 lines
6.9 KiB

"use strict";(self.webpackChunknoco_docs=self.webpackChunknoco_docs||[]).push([[9518],{3905:(e,t,r)=>{r.d(t,{Zo:()=>c,kt:()=>b});var o=r(67294);function n(e,t,r){return t in e?Object.defineProperty(e,t,{value:r,enumerable:!0,configurable:!0,writable:!0}):e[t]=r,e}function i(e,t){var r=Object.keys(e);if(Object.getOwnPropertySymbols){var o=Object.getOwnPropertySymbols(e);t&&(o=o.filter((function(t){return Object.getOwnPropertyDescriptor(e,t).enumerable}))),r.push.apply(r,o)}return r}function a(e){for(var t=1;t<arguments.length;t++){var r=null!=arguments[t]?arguments[t]:{};t%2?i(Object(r),!0).forEach((function(t){n(e,t,r[t])})):Object.getOwnPropertyDescriptors?Object.defineProperties(e,Object.getOwnPropertyDescriptors(r)):i(Object(r)).forEach((function(t){Object.defineProperty(e,t,Object.getOwnPropertyDescriptor(r,t))}))}return e}function l(e,t){if(null==e)return{};var r,o,n=function(e,t){if(null==e)return{};var r,o,n={},i=Object.keys(e);for(o=0;o<i.length;o++)r=i[o],t.indexOf(r)>=0||(n[r]=e[r]);return n}(e,t);if(Object.getOwnPropertySymbols){var i=Object.getOwnPropertySymbols(e);for(o=0;o<i.length;o++)r=i[o],t.indexOf(r)>=0||Object.prototype.propertyIsEnumerable.call(e,r)&&(n[r]=e[r])}return n}var p=o.createContext({}),s=function(e){var t=o.useContext(p),r=t;return e&&(r="function"==typeof e?e(t):a(a({},t),e)),r},c=function(e){var t=s(e.components);return o.createElement(p.Provider,{value:t},e.children)},u="mdxType",d={inlineCode:"code",wrapper:function(e){var t=e.children;return o.createElement(o.Fragment,{},t)}},g=o.forwardRef((function(e,t){var r=e.components,n=e.mdxType,i=e.originalType,p=e.parentName,c=l(e,["components","mdxType","originalType","parentName"]),u=s(r),g=n,b=u["".concat(p,".").concat(g)]||u[g]||d[g]||i;return r?o.createElement(b,a(a({ref:t},c),{},{components:r})):o.createElement(b,a({ref:t},c))}));function b(e,t){var r=arguments,n=t&&t.mdxType;if("string"==typeof e||n){var i=r.length,a=new Array(i);a[0]=g;var l={};for(var p in t)hasOwnProperty.call(t,p)&&(l[p]=t[p]);l.originalType=e,l[u]="string"==typeof e?e:n,a[1]=l;for(var s=2;s<i;s++)a[s]=r[s];return o.createElement.apply(null,a)}return o.createElement.apply(null,r)}g.displayName="MDXCreateElement"},52119:(e,t,r)=>{r.r(t),r.d(t,{assets:()=>p,contentTitle:()=>a,default:()=>d,frontMatter:()=>i,metadata:()=>l,toc:()=>s});var o=r(87462),n=(r(67294),r(3905));const i={title:"Grouping records",description:"Learn how to group records in NocoDB.",tags:["Table operations","Group by","Grid view"],keywords:["NocoDB table group by","group by field","group By'grouping records","grouping","group by in table"]},a=void 0,l={unversionedId:"table-operations/group-by",id:"table-operations/group-by",title:"Grouping records",description:"Learn how to group records in NocoDB.",source:"@site/docs/060.table-operations/050.group-by.md",sourceDirName:"060.table-operations",slug:"/table-operations/group-by",permalink:"/table-operations/group-by",draft:!1,editUrl:"https://github.com/nocodb/nocodb/tree/develop/packages/noco-docs/docs/docs/060.table-operations/050.group-by.md",tags:[{label:"Table operations",permalink:"/tags/table-operations"},{label:"Group by",permalink:"/tags/group-by"},{label:"Grid view",permalink:"/tags/grid-view"}],version:"current",sidebarPosition:50,frontMatter:{title:"Grouping records",description:"Learn how to group records in NocoDB.",tags:["Table operations","Group by","Grid view"],keywords:["NocoDB table group by","group by field","group By'grouping records","grouping","group by in table"]},sidebar:"tutorialSidebar",previous:{title:"Sorting records",permalink:"/table-operations/sort"},next:{title:"Record height",permalink:"/table-operations/row-height"}},p={},s=[{value:"Adding or Editing Groups",id:"adding-or-editing-groups",level:3},{value:"Deleting Groups",id:"deleting-groups",level:3},{value:"Related topics",id:"related-topics",level:3}],c={toc:s},u="wrapper";function d(e){let{components:t,...i}=e;return(0,n.kt)(u,(0,o.Z)({},c,i,{components:t,mdxType:"MDXLayout"}),(0,n.kt)("p",null,"Grouping records in NocoDB allows for efficient categorization of data into specific ",(0,n.kt)("inlineCode",{parentName:"p"},"Groups")," and ",(0,n.kt)("inlineCode",{parentName:"p"},"Subgroups.")," NocoDB supports three levels of record segregation, providing a powerful organizational tool."),(0,n.kt)("p",null,(0,n.kt)("img",{alt:"Group By",src:r(47138).Z,width:"2306",height:"956"})),(0,n.kt)("h3",{id:"adding-or-editing-groups"},"Adding or Editing Groups"),(0,n.kt)("p",null,"To create or modify a grouping in NocoDB, follow these steps:"),(0,n.kt)("ol",null,(0,n.kt)("li",{parentName:"ol"},"Click on ",(0,n.kt)("inlineCode",{parentName:"li"},"Group By")," in the toolbar."),(0,n.kt)("li",{parentName:"ol"},"Choose the field by which you want to group the records."),(0,n.kt)("li",{parentName:"ol"},"Optionally, you can sort the groups in ascending or descending order.")),(0,n.kt)("p",null,(0,n.kt)("img",{alt:"Group By",src:r(76919).Z,width:"2306",height:"956"})),(0,n.kt)("admonition",{type:"info"},(0,n.kt)("p",{parentName:"admonition"},"You can add subgroups with up to three levels to further refine your categorization.")),(0,n.kt)("p",null,(0,n.kt)("img",{alt:"Group By",src:r(48197).Z,width:"2304",height:"1282"})),(0,n.kt)("h3",{id:"deleting-groups"},"Deleting Groups"),(0,n.kt)("p",null,"To remove a grouping in NocoDB, take these actions:"),(0,n.kt)("ol",null,(0,n.kt)("li",{parentName:"ol"},"Click on ",(0,n.kt)("inlineCode",{parentName:"li"},"Group By")," in the toolbar."),(0,n.kt)("li",{parentName:"ol"},"Locate the bin icon to the right of the group you wish to delete and click on it.")),(0,n.kt)("admonition",{type:"info"},(0,n.kt)("p",{parentName:"admonition"},"To disable ",(0,n.kt)("inlineCode",{parentName:"p"},"Group By")," and return to the standard spreadsheet grid view, you must remove all configured groups.")),(0,n.kt)("p",null,(0,n.kt)("img",{alt:"Group By",src:r(98955).Z,width:"2304",height:"1282"})),(0,n.kt)("h3",{id:"related-topics"},"Related topics"),(0,n.kt)("ul",null,(0,n.kt)("li",{parentName:"ul"},(0,n.kt)("a",{parentName:"li",href:"field-operations"},"Field operations")),(0,n.kt)("li",{parentName:"ul"},(0,n.kt)("a",{parentName:"li",href:"filter"},"Filter")),(0,n.kt)("li",{parentName:"ul"},(0,n.kt)("a",{parentName:"li",href:"sort"},"Sort")),(0,n.kt)("li",{parentName:"ul"},(0,n.kt)("a",{parentName:"li",href:"row-height"},"Row height")),(0,n.kt)("li",{parentName:"ul"},(0,n.kt)("a",{parentName:"li",href:"search"},"Quick Search")),(0,n.kt)("li",{parentName:"ul"},(0,n.kt)("a",{parentName:"li",href:"download"},"Download"))))}d.isMDXComponent=!0},47138:(e,t,r)=>{r.d(t,{Z:()=>o});const o=r.p+"assets/images/group-by-1-9fca54ae46eb7c74e888a44d49416e9c.png"},76919:(e,t,r)=>{r.d(t,{Z:()=>o});const o=r.p+"assets/images/group-by-create-903d7ed5fc17d47bcf49b5c84f201f80.png"},98955:(e,t,r)=>{r.d(t,{Z:()=>o});const o=r.p+"assets/images/group-by-delete-2bb963126a68838d8c7dc51e7cf139bb.png"},48197:(e,t,r)=>{r.d(t,{Z:()=>o});const o=r.p+"assets/images/group-by-nested-68c0f8159f38c76343ee6905c701fd5e.png"}}]);