{"id":185,"date":"2006-04-12T03:48:00","date_gmt":"2006-04-12T08:48:00","guid":{"rendered":"http:\/\/www.teamdesk.net\/blog\/2006\/04\/dependent-colum\/"},"modified":"2006-04-12T03:48:00","modified_gmt":"2006-04-12T08:48:00","slug":"dependent-colum","status":"publish","type":"post","link":"https:\/\/www.teamdesk.net\/blog\/whats-new\/dependent-colum\/","title":{"rendered":"Dependent Columns Support"},"content":{"rendered":"<p>Now you can filter records that populate dropdown list or a record picker depending on values entered by the user into other columns.<\/p>\n<p>This can be useful, for example, when you need to choose the Supplier first and then be able to choose among the Products belonging to that supplier only.<\/p>\n<p>To enable such functionality, a &quot;Refresh&quot; action button has been added to record&#8217;s &quot;Edit&quot; and &quot;Add&quot; forms. It reloads dropdown lists and recalculates formulas without saving the form.<\/p>\n<p>Also we have added the ability to re-order relations to control forms details list order.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Now you can filter records that populate dropdown list or a record picker depending on values entered by the user into other columns. This can be useful, for example, when you need to choose the Supplier first and then be able to choose among the Products belonging to that supplier only. To enable such functionality, [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-185","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>Dependent Columns Support - 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\/dependent-colum\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Dependent Columns Support - TeamDesk Blog\" \/>\n<meta property=\"og:description\" content=\"Now you can filter records that populate dropdown list or a record picker depending on values entered by the user into other columns. This can be useful, for example, when you need to choose the Supplier first and then be able to choose among the Products belonging to that supplier only. To enable such functionality, [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.teamdesk.net\/blog\/whats-new\/dependent-colum\/\" \/>\n<meta property=\"og:site_name\" content=\"TeamDesk Blog\" \/>\n<meta property=\"article:published_time\" content=\"2006-04-12T08:48:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2024\/01\/logo_og.png\" \/>\n\t<meta property=\"og:image:width\" content=\"600\" \/>\n\t<meta property=\"og:image:height\" content=\"315\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Slava Shynderov\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Slava Shynderov\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\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\\\/dependent-colum\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/dependent-colum\\\/\"},\"author\":{\"name\":\"Slava Shynderov\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/#\\\/schema\\\/person\\\/478c18541e8c72f93caf641086d96b07\"},\"headline\":\"Dependent Columns Support\",\"datePublished\":\"2006-04-12T08:48:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/dependent-colum\\\/\"},\"wordCount\":103,\"commentCount\":0,\"articleSection\":[\"What's New\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/dependent-colum\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/dependent-colum\\\/\",\"url\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/dependent-colum\\\/\",\"name\":\"Dependent Columns Support - TeamDesk Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/#website\"},\"datePublished\":\"2006-04-12T08:48:00+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/#\\\/schema\\\/person\\\/478c18541e8c72f93caf641086d96b07\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/dependent-colum\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/dependent-colum\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/dependent-colum\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Dependent Columns Support\"}]},{\"@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\\\/478c18541e8c72f93caf641086d96b07\",\"name\":\"Slava Shynderov\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ebd9835685868383868fa4e09d807b517765b7ed0c8f3d6153be12931545ef0f?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ebd9835685868383868fa4e09d807b517765b7ed0c8f3d6153be12931545ef0f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ebd9835685868383868fa4e09d807b517765b7ed0c8f3d6153be12931545ef0f?s=96&d=mm&r=g\",\"caption\":\"Slava Shynderov\"},\"url\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/author\\\/slava-shynderov\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Dependent Columns Support - 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\/dependent-colum\/","og_locale":"en_US","og_type":"article","og_title":"Dependent Columns Support - TeamDesk Blog","og_description":"Now you can filter records that populate dropdown list or a record picker depending on values entered by the user into other columns. This can be useful, for example, when you need to choose the Supplier first and then be able to choose among the Products belonging to that supplier only. To enable such functionality, [&hellip;]","og_url":"https:\/\/www.teamdesk.net\/blog\/whats-new\/dependent-colum\/","og_site_name":"TeamDesk Blog","article_published_time":"2006-04-12T08:48:00+00:00","og_image":[{"width":600,"height":315,"url":"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2024\/01\/logo_og.png","type":"image\/png"}],"author":"Slava Shynderov","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Slava Shynderov","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.teamdesk.net\/blog\/whats-new\/dependent-colum\/#article","isPartOf":{"@id":"https:\/\/www.teamdesk.net\/blog\/whats-new\/dependent-colum\/"},"author":{"name":"Slava Shynderov","@id":"https:\/\/www.teamdesk.net\/blog\/#\/schema\/person\/478c18541e8c72f93caf641086d96b07"},"headline":"Dependent Columns Support","datePublished":"2006-04-12T08:48:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.teamdesk.net\/blog\/whats-new\/dependent-colum\/"},"wordCount":103,"commentCount":0,"articleSection":["What's New"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.teamdesk.net\/blog\/whats-new\/dependent-colum\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.teamdesk.net\/blog\/whats-new\/dependent-colum\/","url":"https:\/\/www.teamdesk.net\/blog\/whats-new\/dependent-colum\/","name":"Dependent Columns Support - TeamDesk Blog","isPartOf":{"@id":"https:\/\/www.teamdesk.net\/blog\/#website"},"datePublished":"2006-04-12T08:48:00+00:00","author":{"@id":"https:\/\/www.teamdesk.net\/blog\/#\/schema\/person\/478c18541e8c72f93caf641086d96b07"},"breadcrumb":{"@id":"https:\/\/www.teamdesk.net\/blog\/whats-new\/dependent-colum\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.teamdesk.net\/blog\/whats-new\/dependent-colum\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.teamdesk.net\/blog\/whats-new\/dependent-colum\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.teamdesk.net\/blog\/"},{"@type":"ListItem","position":2,"name":"Dependent Columns Support"}]},{"@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\/478c18541e8c72f93caf641086d96b07","name":"Slava Shynderov","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/ebd9835685868383868fa4e09d807b517765b7ed0c8f3d6153be12931545ef0f?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/ebd9835685868383868fa4e09d807b517765b7ed0c8f3d6153be12931545ef0f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ebd9835685868383868fa4e09d807b517765b7ed0c8f3d6153be12931545ef0f?s=96&d=mm&r=g","caption":"Slava Shynderov"},"url":"https:\/\/www.teamdesk.net\/blog\/author\/slava-shynderov\/"}]}},"_links":{"self":[{"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/posts\/185","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\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/comments?post=185"}],"version-history":[{"count":0,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/posts\/185\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/media?parent=185"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/categories?post=185"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/tags?post=185"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}