{"id":59,"date":"2011-11-08T08:59:32","date_gmt":"2011-11-08T14:59:32","guid":{"rendered":"http:\/\/www.teamdesk.net\/blog\/2011\/11\/user-properties-feature\/"},"modified":"2015-10-26T13:28:34","modified_gmt":"2015-10-26T18:28:34","slug":"user-properties-feature","status":"publish","type":"post","link":"https:\/\/www.teamdesk.net\/blog\/whats-new\/user-properties-feature\/","title":{"rendered":"User Properties Feature"},"content":{"rendered":"<p>How often you need to add the additional information such as salary or department to your application users&#8217; records?<\/p>\n<p>Usually you can do it by creating a table (say, User Properties table) with column of User type as a key and adding necessary additional properties as columns of this table. Whenever you need this info for the user recorded in some other table you can relate two tables and extract all necessary information via lookups.<\/p>\n<p>The problem arises when you need to extract this information for the current user, typically when defining access rights such as &#8220;Allow view records related to the people from my department&#8221;. Before you would need a formula column calculating User() formula and a relationship to user property table and a column to extract the value. But situation gets worse since you need to do it for every table you need this information in.<\/p>\n<p>With &#8220;native&#8221; support for User Property table it&#8217;s all much easier now.<\/p>\n<p>First, enable User Property Table feature under Setup &gt; Labs. Once enabled, visit Setup &gt; Sharing \/ Roles &gt; Set User Property table. <a href=\"http:\/\/www.teamdesk.net\">TeamDesk<\/a> will propose you to select existing table having a User column as a key column, or create a new one:<\/p>\n<p><a href=\"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2011\/11\/391.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-418\" src=\"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2011\/11\/391.png\" alt=\"39,1\" width=\"366\" height=\"63\" srcset=\"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2011\/11\/391.png 366w, https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2011\/11\/391-300x52.png 300w\" sizes=\"auto, (max-width: 366px) 100vw, 366px\" \/><\/a><\/p>\n<p>Once user table is selected, it will be extended with E-Mail, First Name, Last Name, Screen Name, Role, Default Set, External Customer and Last Access read only columns containing live snapshot from the information found in setup section.<\/p>\n<p>Also you&#8217;ll have couple of new options.<\/p>\n<p>* For any column of user type you can create lookups to the information stored in user tables right from the column&#8217;s view screen:<\/p>\n<p><a href=\"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2011\/11\/392.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-419\" src=\"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2011\/11\/392.png\" alt=\"39,2\" width=\"464\" height=\"339\" srcset=\"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2011\/11\/392.png 464w, https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2011\/11\/392-300x219.png 300w\" sizes=\"auto, (max-width: 464px) 100vw, 464px\" \/><\/a><\/p>\n<p>* Wherever you need an information from User Properties related to current user, you can simply refer to the column of User Properties table by its name.<\/p>\n<p><a href=\"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2011\/11\/393.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-420\" src=\"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2011\/11\/393.png\" alt=\"39,3\" width=\"481\" height=\"265\" srcset=\"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2011\/11\/393.png 481w, https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2011\/11\/393-300x165.png 300w\" sizes=\"auto, (max-width: 481px) 100vw, 481px\" \/><\/a><\/p>\n<p>* Setup&#8217;s Manage Users page is extended with button to edit corresponding record in User Property table.<\/p>\n<p><a href=\"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2011\/11\/394.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-421 aligncenter\" src=\"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2011\/11\/394.png\" alt=\"39,4\" width=\"503\" height=\"152\" srcset=\"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2011\/11\/394.png 503w, https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2011\/11\/394-300x91.png 300w\" sizes=\"auto, (max-width: 503px) 100vw, 503px\" \/><\/a><\/p>\n<p>Obviously users just invited do not have a record in User Properties. For such users the button is named &#8220;Add User Property&#8221; and creates new record with user&#8217;s dropdown pre-selected.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>How often you need to add the additional information such as salary or department to your application users&#8217; records? Usually you can do it by creating a table (say, User Properties table) with column of User type as a key and adding necessary additional properties as columns of this table. Whenever you need this info [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-59","post","type-post","status-publish","format-standard","hentry","category-whats-new"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>User Properties Feature - TeamDesk Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.teamdesk.net\/blog\/whats-new\/user-properties-feature\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"User Properties Feature - TeamDesk Blog\" \/>\n<meta property=\"og:description\" content=\"How often you need to add the additional information such as salary or department to your application users&#8217; records? Usually you can do it by creating a table (say, User Properties table) with column of User type as a key and adding necessary additional properties as columns of this table. Whenever you need this info [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.teamdesk.net\/blog\/whats-new\/user-properties-feature\/\" \/>\n<meta property=\"og:site_name\" content=\"TeamDesk Blog\" \/>\n<meta property=\"article:published_time\" content=\"2011-11-08T14:59:32+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2015-10-26T18:28:34+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2011\/11\/391.png\" \/>\n<meta name=\"author\" content=\"Kirill Bondar\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kirill Bondar\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/user-properties-feature\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/user-properties-feature\\\/\"},\"author\":{\"name\":\"Kirill Bondar\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/#\\\/schema\\\/person\\\/22c4c05bd657513c8b00122fa364c8d2\"},\"headline\":\"User Properties Feature\",\"datePublished\":\"2011-11-08T14:59:32+00:00\",\"dateModified\":\"2015-10-26T18:28:34+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/user-properties-feature\\\/\"},\"wordCount\":346,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/user-properties-feature\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/wp-content\\\/uploads\\\/2011\\\/11\\\/391.png\",\"articleSection\":[\"What's New\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/user-properties-feature\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/user-properties-feature\\\/\",\"url\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/user-properties-feature\\\/\",\"name\":\"User Properties Feature - TeamDesk Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/user-properties-feature\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/user-properties-feature\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/wp-content\\\/uploads\\\/2011\\\/11\\\/391.png\",\"datePublished\":\"2011-11-08T14:59:32+00:00\",\"dateModified\":\"2015-10-26T18:28:34+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/#\\\/schema\\\/person\\\/22c4c05bd657513c8b00122fa364c8d2\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/user-properties-feature\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/user-properties-feature\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/user-properties-feature\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/wp-content\\\/uploads\\\/2011\\\/11\\\/391.png\",\"contentUrl\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/wp-content\\\/uploads\\\/2011\\\/11\\\/391.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/user-properties-feature\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"User Properties Feature\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/\",\"name\":\"TeamDesk Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/#\\\/schema\\\/person\\\/22c4c05bd657513c8b00122fa364c8d2\",\"name\":\"Kirill Bondar\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/dc5bc844095b5753ccc73c589c028bf16615674f289668146bbd59205a08a52d?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/dc5bc844095b5753ccc73c589c028bf16615674f289668146bbd59205a08a52d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/dc5bc844095b5753ccc73c589c028bf16615674f289668146bbd59205a08a52d?s=96&d=mm&r=g\",\"caption\":\"Kirill Bondar\"},\"url\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/author\\\/kirill-bondar\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"User Properties Feature - TeamDesk Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.teamdesk.net\/blog\/whats-new\/user-properties-feature\/","og_locale":"en_US","og_type":"article","og_title":"User Properties Feature - TeamDesk Blog","og_description":"How often you need to add the additional information such as salary or department to your application users&#8217; records? Usually you can do it by creating a table (say, User Properties table) with column of User type as a key and adding necessary additional properties as columns of this table. Whenever you need this info [&hellip;]","og_url":"https:\/\/www.teamdesk.net\/blog\/whats-new\/user-properties-feature\/","og_site_name":"TeamDesk Blog","article_published_time":"2011-11-08T14:59:32+00:00","article_modified_time":"2015-10-26T18:28:34+00:00","og_image":[{"url":"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2011\/11\/391.png","type":"","width":"","height":""}],"author":"Kirill Bondar","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kirill Bondar","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.teamdesk.net\/blog\/whats-new\/user-properties-feature\/#article","isPartOf":{"@id":"https:\/\/www.teamdesk.net\/blog\/whats-new\/user-properties-feature\/"},"author":{"name":"Kirill Bondar","@id":"https:\/\/www.teamdesk.net\/blog\/#\/schema\/person\/22c4c05bd657513c8b00122fa364c8d2"},"headline":"User Properties Feature","datePublished":"2011-11-08T14:59:32+00:00","dateModified":"2015-10-26T18:28:34+00:00","mainEntityOfPage":{"@id":"https:\/\/www.teamdesk.net\/blog\/whats-new\/user-properties-feature\/"},"wordCount":346,"commentCount":0,"image":{"@id":"https:\/\/www.teamdesk.net\/blog\/whats-new\/user-properties-feature\/#primaryimage"},"thumbnailUrl":"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2011\/11\/391.png","articleSection":["What's New"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.teamdesk.net\/blog\/whats-new\/user-properties-feature\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.teamdesk.net\/blog\/whats-new\/user-properties-feature\/","url":"https:\/\/www.teamdesk.net\/blog\/whats-new\/user-properties-feature\/","name":"User Properties Feature - TeamDesk Blog","isPartOf":{"@id":"https:\/\/www.teamdesk.net\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.teamdesk.net\/blog\/whats-new\/user-properties-feature\/#primaryimage"},"image":{"@id":"https:\/\/www.teamdesk.net\/blog\/whats-new\/user-properties-feature\/#primaryimage"},"thumbnailUrl":"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2011\/11\/391.png","datePublished":"2011-11-08T14:59:32+00:00","dateModified":"2015-10-26T18:28:34+00:00","author":{"@id":"https:\/\/www.teamdesk.net\/blog\/#\/schema\/person\/22c4c05bd657513c8b00122fa364c8d2"},"breadcrumb":{"@id":"https:\/\/www.teamdesk.net\/blog\/whats-new\/user-properties-feature\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.teamdesk.net\/blog\/whats-new\/user-properties-feature\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.teamdesk.net\/blog\/whats-new\/user-properties-feature\/#primaryimage","url":"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2011\/11\/391.png","contentUrl":"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2011\/11\/391.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.teamdesk.net\/blog\/whats-new\/user-properties-feature\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.teamdesk.net\/blog\/"},{"@type":"ListItem","position":2,"name":"User Properties Feature"}]},{"@type":"WebSite","@id":"https:\/\/www.teamdesk.net\/blog\/#website","url":"https:\/\/www.teamdesk.net\/blog\/","name":"TeamDesk Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.teamdesk.net\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.teamdesk.net\/blog\/#\/schema\/person\/22c4c05bd657513c8b00122fa364c8d2","name":"Kirill Bondar","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/dc5bc844095b5753ccc73c589c028bf16615674f289668146bbd59205a08a52d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/dc5bc844095b5753ccc73c589c028bf16615674f289668146bbd59205a08a52d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/dc5bc844095b5753ccc73c589c028bf16615674f289668146bbd59205a08a52d?s=96&d=mm&r=g","caption":"Kirill Bondar"},"url":"https:\/\/www.teamdesk.net\/blog\/author\/kirill-bondar\/"}]}},"_links":{"self":[{"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/posts\/59","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/comments?post=59"}],"version-history":[{"count":2,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/posts\/59\/revisions"}],"predecessor-version":[{"id":422,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/posts\/59\/revisions\/422"}],"wp:attachment":[{"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/media?parent=59"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/categories?post=59"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/tags?post=59"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}