{"id":89,"date":"2010-06-14T08:19:11","date_gmt":"2010-06-14T13:19:11","guid":{"rendered":"http:\/\/www.teamdesk.net\/blog\/2010\/06\/move-column-to-another-table\/"},"modified":"2015-10-26T14:20:13","modified_gmt":"2015-10-26T19:20:13","slug":"move-column-to-another-table","status":"publish","type":"post","link":"https:\/\/www.teamdesk.net\/blog\/whats-new\/move-column-to-another-table\/","title":{"rendered":"Move column to another table"},"content":{"rendered":"<p>Another piece of functionality we have released today is an ability to move columns between tables. What is it for?<\/p>\n<p>You often start with simple application design. Then you recognize that needs grow and requirements are changing. Take our favorite example, Leads Management application \u2013 the city is a type-in field. Good for a start, but it is often a source of typing errors and it would be nice to have it as a dropdown list. Simplest way is to switch City column&#8217;s Data Entry property from a Type-In to dropdown, but, in this case, only application administrators will be able to maintain the list. And if you want users to be able to edit entries you need to have it in a separate table.<\/p>\n<p>Before today&#8217;s release you could do it by exporting the data to Excel, building the list of unique entries, importing the data back to a separate table, changing table&#8217;s key to a city name, creating the relation, then changing the key back \u2013 a lot of non-trivial steps. From now you can do it with a few clicks.<\/p>\n<p><!--more--><\/p>\n<p>When viewing column&#8217;s properties you may notice new Move button. Clicking the button will prompt you what to do.<\/p>\n<p>You can either move the column to a new table, or to one of the master tables (the list of options is built based on relationship between tables you already have). Let&#8217;s start with a new table:<\/p>\n<p style=\"text-align: center;\"><a href=\"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2010\/06\/541.gif\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-475\" src=\"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2010\/06\/541.gif\" alt=\"54,1\" width=\"500\" height=\"123\" \/><\/a><\/p>\n<p><a href=\"http:\/\/www.teamdesk.net\">TeamDesk<\/a> will build distinct list of cities for you, create the new table based on the list and will bind existing leads to a cities table through the relationship. The city name become a lookup field.<\/p>\n<p>You may want to go one step further \u2013 the state can be used together with the city name in the dropdown thus you can move state column to a city table as well. Since TeamDesk created the relationship between Leads and Cities you have one more choice now:<\/p>\n<p style=\"text-align: center;\"><a href=\"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2010\/06\/542.gif\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-476\" src=\"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2010\/06\/542.gif\" alt=\"54,2\" width=\"500\" height=\"124\" \/><\/a><\/p>\n<p>After confirming the changes and setting up Cities&#8217; record picker view to display both the city name and state you&#8217;ll end up with the following user interface:<\/p>\n<p style=\"text-align: center;\"><a href=\"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2010\/06\/543.gif\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-477\" src=\"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2010\/06\/543.gif\" alt=\"54,3\" width=\"500\" height=\"134\" \/><\/a><\/p>\n<p>As you can see, the process that required a lot of operations and external programs is now replaced with a one-click tool.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Another piece of functionality we have released today is an ability to move columns between tables. What is it for? You often start with simple application design. Then you recognize that needs grow and requirements are changing. Take our favorite example, Leads Management application \u2013 the city is a type-in field. Good for a start, [&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-89","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>Move column to another table - 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\/move-column-to-another-table\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Move column to another table - TeamDesk Blog\" \/>\n<meta property=\"og:description\" content=\"Another piece of functionality we have released today is an ability to move columns between tables. What is it for? You often start with simple application design. Then you recognize that needs grow and requirements are changing. Take our favorite example, Leads Management application \u2013 the city is a type-in field. Good for a start, [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.teamdesk.net\/blog\/whats-new\/move-column-to-another-table\/\" \/>\n<meta property=\"og:site_name\" content=\"TeamDesk Blog\" \/>\n<meta property=\"article:published_time\" content=\"2010-06-14T13:19:11+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2015-10-26T19:20:13+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2010\/06\/541.gif\" \/>\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\\\/move-column-to-another-table\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/move-column-to-another-table\\\/\"},\"author\":{\"name\":\"Kirill Bondar\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/#\\\/schema\\\/person\\\/22c4c05bd657513c8b00122fa364c8d2\"},\"headline\":\"Move column to another table\",\"datePublished\":\"2010-06-14T13:19:11+00:00\",\"dateModified\":\"2015-10-26T19:20:13+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/move-column-to-another-table\\\/\"},\"wordCount\":375,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/move-column-to-another-table\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/wp-content\\\/uploads\\\/2010\\\/06\\\/541.gif\",\"articleSection\":[\"What's New\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/move-column-to-another-table\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/move-column-to-another-table\\\/\",\"url\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/move-column-to-another-table\\\/\",\"name\":\"Move column to another table - TeamDesk Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/move-column-to-another-table\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/move-column-to-another-table\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/wp-content\\\/uploads\\\/2010\\\/06\\\/541.gif\",\"datePublished\":\"2010-06-14T13:19:11+00:00\",\"dateModified\":\"2015-10-26T19:20:13+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/#\\\/schema\\\/person\\\/22c4c05bd657513c8b00122fa364c8d2\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/move-column-to-another-table\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/move-column-to-another-table\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/move-column-to-another-table\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/wp-content\\\/uploads\\\/2010\\\/06\\\/541.gif\",\"contentUrl\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/wp-content\\\/uploads\\\/2010\\\/06\\\/541.gif\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/move-column-to-another-table\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Move column to another table\"}]},{\"@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":"Move column to another table - 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\/move-column-to-another-table\/","og_locale":"en_US","og_type":"article","og_title":"Move column to another table - TeamDesk Blog","og_description":"Another piece of functionality we have released today is an ability to move columns between tables. What is it for? You often start with simple application design. Then you recognize that needs grow and requirements are changing. Take our favorite example, Leads Management application \u2013 the city is a type-in field. Good for a start, [&hellip;]","og_url":"https:\/\/www.teamdesk.net\/blog\/whats-new\/move-column-to-another-table\/","og_site_name":"TeamDesk Blog","article_published_time":"2010-06-14T13:19:11+00:00","article_modified_time":"2015-10-26T19:20:13+00:00","og_image":[{"url":"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2010\/06\/541.gif","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\/move-column-to-another-table\/#article","isPartOf":{"@id":"https:\/\/www.teamdesk.net\/blog\/whats-new\/move-column-to-another-table\/"},"author":{"name":"Kirill Bondar","@id":"https:\/\/www.teamdesk.net\/blog\/#\/schema\/person\/22c4c05bd657513c8b00122fa364c8d2"},"headline":"Move column to another table","datePublished":"2010-06-14T13:19:11+00:00","dateModified":"2015-10-26T19:20:13+00:00","mainEntityOfPage":{"@id":"https:\/\/www.teamdesk.net\/blog\/whats-new\/move-column-to-another-table\/"},"wordCount":375,"commentCount":0,"image":{"@id":"https:\/\/www.teamdesk.net\/blog\/whats-new\/move-column-to-another-table\/#primaryimage"},"thumbnailUrl":"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2010\/06\/541.gif","articleSection":["What's New"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.teamdesk.net\/blog\/whats-new\/move-column-to-another-table\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.teamdesk.net\/blog\/whats-new\/move-column-to-another-table\/","url":"https:\/\/www.teamdesk.net\/blog\/whats-new\/move-column-to-another-table\/","name":"Move column to another table - TeamDesk Blog","isPartOf":{"@id":"https:\/\/www.teamdesk.net\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.teamdesk.net\/blog\/whats-new\/move-column-to-another-table\/#primaryimage"},"image":{"@id":"https:\/\/www.teamdesk.net\/blog\/whats-new\/move-column-to-another-table\/#primaryimage"},"thumbnailUrl":"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2010\/06\/541.gif","datePublished":"2010-06-14T13:19:11+00:00","dateModified":"2015-10-26T19:20:13+00:00","author":{"@id":"https:\/\/www.teamdesk.net\/blog\/#\/schema\/person\/22c4c05bd657513c8b00122fa364c8d2"},"breadcrumb":{"@id":"https:\/\/www.teamdesk.net\/blog\/whats-new\/move-column-to-another-table\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.teamdesk.net\/blog\/whats-new\/move-column-to-another-table\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.teamdesk.net\/blog\/whats-new\/move-column-to-another-table\/#primaryimage","url":"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2010\/06\/541.gif","contentUrl":"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2010\/06\/541.gif"},{"@type":"BreadcrumbList","@id":"https:\/\/www.teamdesk.net\/blog\/whats-new\/move-column-to-another-table\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.teamdesk.net\/blog\/"},{"@type":"ListItem","position":2,"name":"Move column to another table"}]},{"@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\/89","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=89"}],"version-history":[{"count":1,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/posts\/89\/revisions"}],"predecessor-version":[{"id":478,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/posts\/89\/revisions\/478"}],"wp:attachment":[{"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/media?parent=89"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/categories?post=89"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/tags?post=89"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}