{"id":153,"date":"2007-09-18T09:35:14","date_gmt":"2007-09-18T14:35:14","guid":{"rendered":"http:\/\/www.teamdesk.net\/blog\/2007\/09\/using-formula-c\/"},"modified":"2007-09-18T09:35:14","modified_gmt":"2007-09-18T14:35:14","slug":"using-formula-c","status":"publish","type":"post","link":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/using-formula-c\/","title":{"rendered":"Using Formula Columns for Data Altering"},"content":{"rendered":"

After initial data upload has been completed, sometimes you need to convert it into another format or represent it in some other form. TeamDesk<\/a> allows you to perform such modifications on the fly.<\/p>\n

<\/p>\n

As an example let’s take the following situation: you have the Name<\/em> <\/strong>column where you store the first and last names of your clients in a simple text format. However for some future manipulations you need to parse these data and store them in two columns: First Name<\/em> <\/strong>and Last Name<\/em>. There’s no need to spend hours to find the right solution to accomplish this task. TeamDesk functionality helps you do it with just a couple of steps. Basically you should do just the following:<\/p>\n

    \n
  1. Create a formula – text column called First Name<\/em>. The formula should be Left([Name], " ")<\/strong><\/li>\n
  2. Create a formula – text column called Last Name<\/em>. The formula should be NotLeft([Name], " ")<\/strong><\/li>\n
  3. Thus, data from the Name<\/em> column is duplicated and divided into 2 additional fields – First Name<\/em> and Last Name. <\/em>When two new columns are ready, check if views and reports represent data correctly and in the way you need.<\/li>\n
  4. Change type<\/a> of the First Name<\/em> and Last Name<\/em> columns into regular text column. At this step all data taken from the original Name<\/em> column are recorded into the newly created columns.<\/li>\n
  5. Now if necessary, you can change type of the Name<\/em> <\/strong>column: make it a formula – text column. The formula should be: List(" ",[First Name],[Last Name])<\/strong><\/li>\n<\/ol>\n

    What is the most amazing about these manipulations, is that all objects, tables and elements that ever had any references to the original Name<\/em> column, keep operating without any errors or data losses.<\/p>\n","protected":false},"excerpt":{"rendered":"

    When the initial data upload has been completed, you sometimes need to convert it into another format or represent in some other form. TeamDesk tables enable you to perform such modifications on the fly.<\/p>\n","protected":false},"author":8,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-153","post","type-post","status-publish","format-standard","hentry","category-tips-tricks"],"yoast_head":"\nUsing Formula Columns for Data Altering - 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\/tips-tricks\/using-formula-c\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Using Formula Columns for Data Altering - TeamDesk Blog\" \/>\n<meta property=\"og:description\" content=\"When the initial data upload has been completed, you sometimes need to convert it into another format or represent in some other form. TeamDesk tables enable you to perform such modifications on the fly.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/using-formula-c\/\" \/>\n<meta property=\"og:site_name\" content=\"TeamDesk Blog\" \/>\n<meta property=\"article:published_time\" content=\"2007-09-18T14:35:14+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=\"Christine Jefferson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Christine Jefferson\" \/>\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\\\/tips-tricks\\\/using-formula-c\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/tips-tricks\\\/using-formula-c\\\/\"},\"author\":{\"name\":\"Christine Jefferson\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/#\\\/schema\\\/person\\\/049dd02fd19258ded8cfdc419b4462ed\"},\"headline\":\"Using Formula Columns for Data Altering\",\"datePublished\":\"2007-09-18T14:35:14+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/tips-tricks\\\/using-formula-c\\\/\"},\"wordCount\":294,\"commentCount\":0,\"articleSection\":[\"Tips & Tricks\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/tips-tricks\\\/using-formula-c\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/tips-tricks\\\/using-formula-c\\\/\",\"url\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/tips-tricks\\\/using-formula-c\\\/\",\"name\":\"Using Formula Columns for Data Altering - TeamDesk Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/#website\"},\"datePublished\":\"2007-09-18T14:35:14+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/#\\\/schema\\\/person\\\/049dd02fd19258ded8cfdc419b4462ed\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/tips-tricks\\\/using-formula-c\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/tips-tricks\\\/using-formula-c\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/tips-tricks\\\/using-formula-c\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Using Formula Columns for Data Altering\"}]},{\"@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\\\/049dd02fd19258ded8cfdc419b4462ed\",\"name\":\"Christine Jefferson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/?s=96&d=mm&r=g\",\"caption\":\"Christine Jefferson\"},\"url\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/author\\\/christine-jefferson\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Using Formula Columns for Data Altering - 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\/tips-tricks\/using-formula-c\/","og_locale":"en_US","og_type":"article","og_title":"Using Formula Columns for Data Altering - TeamDesk Blog","og_description":"When the initial data upload has been completed, you sometimes need to convert it into another format or represent in some other form. TeamDesk tables enable you to perform such modifications on the fly.","og_url":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/using-formula-c\/","og_site_name":"TeamDesk Blog","article_published_time":"2007-09-18T14:35:14+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":"Christine Jefferson","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Christine Jefferson","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/using-formula-c\/#article","isPartOf":{"@id":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/using-formula-c\/"},"author":{"name":"Christine Jefferson","@id":"https:\/\/www.teamdesk.net\/blog\/#\/schema\/person\/049dd02fd19258ded8cfdc419b4462ed"},"headline":"Using Formula Columns for Data Altering","datePublished":"2007-09-18T14:35:14+00:00","mainEntityOfPage":{"@id":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/using-formula-c\/"},"wordCount":294,"commentCount":0,"articleSection":["Tips & Tricks"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.teamdesk.net\/blog\/tips-tricks\/using-formula-c\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/using-formula-c\/","url":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/using-formula-c\/","name":"Using Formula Columns for Data Altering - TeamDesk Blog","isPartOf":{"@id":"https:\/\/www.teamdesk.net\/blog\/#website"},"datePublished":"2007-09-18T14:35:14+00:00","author":{"@id":"https:\/\/www.teamdesk.net\/blog\/#\/schema\/person\/049dd02fd19258ded8cfdc419b4462ed"},"breadcrumb":{"@id":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/using-formula-c\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.teamdesk.net\/blog\/tips-tricks\/using-formula-c\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/using-formula-c\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.teamdesk.net\/blog\/"},{"@type":"ListItem","position":2,"name":"Using Formula Columns for Data Altering"}]},{"@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\/049dd02fd19258ded8cfdc419b4462ed","name":"Christine Jefferson","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g","caption":"Christine Jefferson"},"url":"https:\/\/www.teamdesk.net\/blog\/author\/christine-jefferson\/"}]}},"_links":{"self":[{"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/posts\/153","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\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/comments?post=153"}],"version-history":[{"count":0,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/posts\/153\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/media?parent=153"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/categories?post=153"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/tags?post=153"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}