{"id":165,"date":"2007-03-07T13:54:00","date_gmt":"2007-03-07T19:54:00","guid":{"rendered":"http:\/\/www.teamdesk.net\/blog\/2007\/03\/default-value-a\/"},"modified":"2007-03-07T13:54:00","modified_gmt":"2007-03-07T19:54:00","slug":"default-value-a","status":"publish","type":"post","link":"https:\/\/www.teamdesk.net\/blog\/whats-new\/default-value-a\/","title":{"rendered":"Default Value as Formula"},"content":{"rendered":"<p>We have updated the way default values are handled in TeamDesk.<\/p>\n<p><em>Duration<\/em> and <em>Time<\/em> columns now support default values.<\/p>\n<p>The interface is unified now and supports entering the value or the formula.<\/p>\n<p>Constant values can now be entered the same way they are entered in edit form. They are handled according to user&#8217;s locale settings.<\/p>\n<p>The formula can not refer other columns in the table, but can use functions, and application variables. This allows to achieve certain flexibility for specifying default values, for example, now you can use Today()+Days(1) for the date default value to set it to &quot;tomorrow&quot;.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>We have updated the way default values are handled in TeamDesk. Duration and Time columns now support default values. The interface is unified now and supports entering the value or the formula. Constant values can now be entered the same way they are entered in edit form. They are handled according to user&#8217;s locale settings. [&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-165","post","type-post","status-publish","format-standard","hentry","category-whats-new"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Default Value as Formula - 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\/default-value-a\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Default Value as Formula - TeamDesk Blog\" \/>\n<meta property=\"og:description\" content=\"We have updated the way default values are handled in TeamDesk. Duration and Time columns now support default values. The interface is unified now and supports entering the value or the formula. Constant values can now be entered the same way they are entered in edit form. They are handled according to user&#8217;s locale settings. [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.teamdesk.net\/blog\/whats-new\/default-value-a\/\" \/>\n<meta property=\"og:site_name\" content=\"TeamDesk Blog\" \/>\n<meta property=\"article:published_time\" content=\"2007-03-07T19:54: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\\\/default-value-a\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/default-value-a\\\/\"},\"author\":{\"name\":\"Slava Shynderov\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/#\\\/schema\\\/person\\\/478c18541e8c72f93caf641086d96b07\"},\"headline\":\"Default Value as Formula\",\"datePublished\":\"2007-03-07T19:54:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/default-value-a\\\/\"},\"wordCount\":106,\"commentCount\":0,\"articleSection\":[\"What's New\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/default-value-a\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/default-value-a\\\/\",\"url\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/default-value-a\\\/\",\"name\":\"Default Value as Formula - TeamDesk Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/#website\"},\"datePublished\":\"2007-03-07T19:54:00+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/#\\\/schema\\\/person\\\/478c18541e8c72f93caf641086d96b07\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/default-value-a\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/default-value-a\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/default-value-a\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Default Value as Formula\"}]},{\"@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":"Default Value as Formula - 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\/default-value-a\/","og_locale":"en_US","og_type":"article","og_title":"Default Value as Formula - TeamDesk Blog","og_description":"We have updated the way default values are handled in TeamDesk. Duration and Time columns now support default values. The interface is unified now and supports entering the value or the formula. Constant values can now be entered the same way they are entered in edit form. They are handled according to user&#8217;s locale settings. [&hellip;]","og_url":"https:\/\/www.teamdesk.net\/blog\/whats-new\/default-value-a\/","og_site_name":"TeamDesk Blog","article_published_time":"2007-03-07T19:54: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\/default-value-a\/#article","isPartOf":{"@id":"https:\/\/www.teamdesk.net\/blog\/whats-new\/default-value-a\/"},"author":{"name":"Slava Shynderov","@id":"https:\/\/www.teamdesk.net\/blog\/#\/schema\/person\/478c18541e8c72f93caf641086d96b07"},"headline":"Default Value as Formula","datePublished":"2007-03-07T19:54:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.teamdesk.net\/blog\/whats-new\/default-value-a\/"},"wordCount":106,"commentCount":0,"articleSection":["What's New"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.teamdesk.net\/blog\/whats-new\/default-value-a\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.teamdesk.net\/blog\/whats-new\/default-value-a\/","url":"https:\/\/www.teamdesk.net\/blog\/whats-new\/default-value-a\/","name":"Default Value as Formula - TeamDesk Blog","isPartOf":{"@id":"https:\/\/www.teamdesk.net\/blog\/#website"},"datePublished":"2007-03-07T19:54:00+00:00","author":{"@id":"https:\/\/www.teamdesk.net\/blog\/#\/schema\/person\/478c18541e8c72f93caf641086d96b07"},"breadcrumb":{"@id":"https:\/\/www.teamdesk.net\/blog\/whats-new\/default-value-a\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.teamdesk.net\/blog\/whats-new\/default-value-a\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.teamdesk.net\/blog\/whats-new\/default-value-a\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.teamdesk.net\/blog\/"},{"@type":"ListItem","position":2,"name":"Default Value as Formula"}]},{"@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\/165","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=165"}],"version-history":[{"count":0,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/posts\/165\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/media?parent=165"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/categories?post=165"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/tags?post=165"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}