"use strict";(self.webpackChunknoco_docs=self.webpackChunknoco_docs||[]).push([[4333],{3905:(e,a,t)=>{t.d(a,{Zo:()=>p,kt:()=>y});var i=t(67294);function l(e,a,t){return a in e?Object.defineProperty(e,a,{value:t,enumerable:!0,configurable:!0,writable:!0}):e[a]=t,e}function n(e,a){var t=Object.keys(e);if(Object.getOwnPropertySymbols){var i=Object.getOwnPropertySymbols(e);a&&(i=i.filter((function(a){return Object.getOwnPropertyDescriptor(e,a).enumerable}))),t.push.apply(t,i)}return t}function s(e){for(var a=1;a<arguments.length;a++){var t=null!=arguments[a]?arguments[a]:{};a%2?n(Object(t),!0).forEach((function(a){l(e,a,t[a])})):Object.getOwnPropertyDescriptors?Object.defineProperties(e,Object.getOwnPropertyDescriptors(t)):n(Object(t)).forEach((function(a){Object.defineProperty(e,a,Object.getOwnPropertyDescriptor(t,a))}))}return e}function r(e,a){if(null==e)return{};var t,i,l=function(e,a){if(null==e)return{};var t,i,l={},n=Object.keys(e);for(i=0;i<n.length;i++)t=n[i],a.indexOf(t)>=0||(l[t]=e[t]);return l}(e,a);if(Object.getOwnPropertySymbols){var n=Object.getOwnPropertySymbols(e);for(i=0;i<n.length;i++)t=n[i],a.indexOf(t)>=0||Object.prototype.propertyIsEnumerable.call(e,t)&&(l[t]=e[t])}return l}var o=i.createContext({}),u=function(e){var a=i.useContext(o),t=a;return e&&(t="function"==typeof e?e(a):s(s({},a),e)),t},p=function(e){var a=u(e.components);return i.createElement(o.Provider,{value:a},e.children)},d="mdxType",c={inlineCode:"code",wrapper:function(e){var a=e.children;return i.createElement(i.Fragment,{},a)}},h=i.forwardRef((function(e,a){var t=e.components,l=e.mdxType,n=e.originalType,o=e.parentName,p=r(e,["components","mdxType","originalType","parentName"]),d=u(t),h=l,y=d["".concat(o,".").concat(h)]||d[h]||c[h]||n;return t?i.createElement(y,s(s({ref:a},p),{},{components:t})):i.createElement(y,s({ref:a},p))}));function y(e,a){var t=arguments,l=a&&a.mdxType;if("string"==typeof e||l){var n=t.length,s=new Array(n);s[0]=h;var r={};for(var o in a)hasOwnProperty.call(a,o)&&(r[o]=a[o]);r.originalType=e,r[d]="string"==typeof e?e:l,s[1]=r;for(var u=2;u<n;u++)s[u]=t[u];return i.createElement.apply(null,s)}return i.createElement.apply(null,t)}h.displayName="MDXCreateElement"},84673:(e,a,t)=>{t.r(a),t.d(a,{assets:()=>o,contentTitle:()=>s,default:()=>c,frontMatter:()=>n,metadata:()=>r,toc:()=>u});var i=t(87462),l=(t(67294),t(3905));const n={title:"Display Value",description:"Understanding Display Value in NocoDB!"},s=void 0,r={unversionedId:"setup-and-usages/display-value",id:"version-0.109.7/setup-and-usages/display-value",title:"Display Value",description:"Understanding Display Value in NocoDB!",source:"@site/versioned_docs/version-0.109.7/030.setup-and-usages/110.display-value.md",sourceDirName:"030.setup-and-usages",slug:"/setup-and-usages/display-value",permalink:"/0.109.7/setup-and-usages/display-value",draft:!1,editUrl:"https://github.com/nocodb/nocodb/tree/develop/packages/noco-docs/docs/versioned_docs/version-0.109.7/030.setup-and-usages/110.display-value.md",tags:[],version:"0.109.7",sidebarPosition:110,frontMatter:{title:"Display Value",description:"Understanding Display Value in NocoDB!"},sidebar:"tutorialSidebar",previous:{title:"Primary Key",permalink:"/0.109.7/setup-and-usages/primary-key"},next:{title:"Sync Schema",permalink:"/0.109.7/setup-and-usages/sync-schema"}},o={},u=[{value:"What is a Display Value ?",id:"what-is-a-display-value-",level:2},{value:"What is the use of Display Value ?",id:"what-is-the-use-of-display-value-",level:2},{value:"Example : Display Value highlighted in Actor table",id:"example--display-value-highlighted-in-actor-table",level:4},{value:"Example : Display Value highlighted in Film table",id:"example--display-value-highlighted-in-film-table",level:4},{value:"Example : Display Value associated when LinkToAnotherRecord is created",id:"example--display-value-associated-when-linktoanotherrecord-is-created",level:4},{value:"How to set Display Value ?",id:"how-to-set-display-value-",level:2},{value:"How is Display Value identfied for existing database tables ?",id:"how-is-display-value-identfied-for-existing-database-tables-",level:2},{value:"Can I change the Display Value to another column within tables ?",id:"can-i-change-the-display-value-to-another-column-within-tables-",level:2}],p={toc:u},d="wrapper";function c(e){let{components:a,...t}=e;return(0,l.kt)(d,(0,i.Z)({},p,t,{components:a,mdxType:"MDXLayout"}),(0,l.kt)("h2",{id:"what-is-a-display-value-"},"What is a Display Value ?"),(0,l.kt)("ul",null,(0,l.kt)("li",{parentName:"ul"},"Display Value as the name stands is the primary or main value within a row of a table that you generally associate that row with."),(0,l.kt)("li",{parentName:"ul"},"It should be usually associated with a column which is uniquely identifiable. However, this uniqueness is not enforced at the database level."),(0,l.kt)("li",{parentName:"ul"},"Before v0.105.0, Display Value was known as Primary Value.")),(0,l.kt)("h2",{id:"what-is-the-use-of-display-value-"},"What is the use of Display Value ?"),(0,l.kt)("ul",null,(0,l.kt)("li",{parentName:"ul"},"Within a spreadsheet, Display Value are always highlighted so that it is easier to recognise what row we are in."),(0,l.kt)("li",{parentName:"ul"},"And when LinkToAnotherRecord is created between two tables - it is the Display Value that appears in LinkToAnotheRecord column. ")),(0,l.kt)("h4",{id:"example--display-value-highlighted-in-actor-table"},"Example : Display Value highlighted in Actor table"),(0,l.kt)("img",{width:"646",alt:"image",src:"https://user-images.githubusercontent.com/35857179/189114321-58ebaa16-20e2-4615-abda-39417a5df5bf.png"}),(0,l.kt)("h4",{id:"example--display-value-highlighted-in-film-table"},"Example : Display Value highlighted in Film table"),(0,l.kt)("img",{width:"643",alt:"image",src:"https://user-images.githubusercontent.com/35857179/189114462-a7fef0e2-f9ac-4943-98d5-fee9f60a4ab5.png"}),(0,l.kt)("h4",{id:"example--display-value-associated-when-linktoanotherrecord-is-created"},"Example : Display Value associated when LinkToAnotherRecord is created"),(0,l.kt)("img",{width:"311",alt:"image",src:"https://user-images.githubusercontent.com/35857179/189114548-193acc4d-f714-4204-a560-97668db7884c.png"}),(0,l.kt)("h2",{id:"how-to-set-display-value-"},"How to set Display Value ?"),(0,l.kt)("p",null,"Click down arrow in the target column. Click ",(0,l.kt)("inlineCode",{parentName:"p"},"Set as Display Value"),". "),(0,l.kt)("p",null,(0,l.kt)("img",{parentName:"p",src:"https://user-images.githubusercontent.com/35857179/219339727-dee5fdea-6db7-4a06-9e48-df7113cc63b1.png",alt:"image"})),(0,l.kt)("h2",{id:"how-is-display-value-identfied-for-existing-database-tables-"},"How is Display Value identfied for existing database tables ?"),(0,l.kt)("ul",null,(0,l.kt)("li",{parentName:"ul"},"It is usually the first column after the primary key which is not a number. "),(0,l.kt)("li",{parentName:"ul"},"If there is no column which is not a number then the column adjacent to primary key is chosen. ")),(0,l.kt)("h2",{id:"can-i-change-the-display-value-to-another-column-within-tables-"},"Can I change the Display Value to another column within tables ?"),(0,l.kt)("ul",null,(0,l.kt)("li",{parentName:"ul"},"Yes, you can use the same way mentioned above to set Display Value.")))}c.isMDXComponent=!0}}]);