{"id":535,"date":"2021-05-22T12:36:14","date_gmt":"2021-05-22T12:36:14","guid":{"rendered":"https:\/\/support.zippydoc.de\/?p=535"},"modified":"2021-06-15T14:09:17","modified_gmt":"2021-06-15T14:09:17","slug":"formula","status":"publish","type":"post","link":"https:\/\/support.zippydoc.de\/en\/formula\/","title":{"rendered":"Formula"},"content":{"rendered":"<p><strong>What is the \u2018Formula\u2019 task?<\/strong><\/p>\n<p><img class=\"aligncenter wp-image-663 size-full\" src=\"https:\/\/support.zippydoc.de\/wp-content\/uploads\/2021\/05\/v1-TD-Formula-Pictogram-e1621710693867.png\" alt=\"\" width=\"681\" height=\"150\" \/><\/p>\n<p>The \u2018Formula\u2019 task can be used to carry out a variety of custom calculations on numerical or text data.<\/p>\n<p>The \u2018Formula\u2019 task is a flexible tool to carry out complex numerical or text calculations. The filtering feature and ability to add multiple formulae to a flow make it a powerful tool to carry out complex, multi-level calculations. Furthermore, the ability to add annotations and descriptions at each step helps in reviewing and updating calculations at any time.<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><strong>How to use the \u2018Formula\u2019 task?<\/strong><\/p>\n<p><img class=\"aligncenter wp-image-536 size-full\" src=\"https:\/\/support.zippydoc.de\/wp-content\/uploads\/2021\/05\/v1-TD-Formula-e1621686961901.png\" alt=\"\" width=\"500\" height=\"427\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>The important fields in the \u2018Formula\u2019 task are<\/p>\n<ol>\n<li><strong>Select Table<\/strong><\/li>\n<\/ol>\n<p style=\"padding-left: 40px;\">Use this dropdown menu to select the table in which you would like to apply a formula.<\/p>\n<p>&nbsp;<\/p>\n<ol start=\"2\">\n<li><strong>Column to apply<\/strong><\/li>\n<\/ol>\n<p style=\"padding-left: 40px;\">Use this dropdown menu to select the column on which you would like to carry out the calculation.<\/p>\n<p>&nbsp;<\/p>\n<ol start=\"3\">\n<li><strong>Type<\/strong><\/li>\n<\/ol>\n<p style=\"padding-left: 40px;\">Use this dropdown menu to select the type of calculation you would like to carry out. You can either select a static or constant value, or a numerical or text calculation.<\/p>\n<p>&nbsp;<\/p>\n<ol start=\"4\">\n<li><strong>Input Value OR Input Formula<\/strong><\/li>\n<\/ol>\n<p style=\"padding-left: 40px;\">Use this field to type in the static value or formula for your calculation.<\/p>\n<p>&nbsp;<\/p>\n<ol start=\"5\">\n<li><strong>Format<\/strong><\/li>\n<\/ol>\n<p style=\"padding-left: 40px;\">Use this dropdown menu to indicate the format of the calculated value. You may select a numerical, or date, or currency, or text format.<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><strong>How to use the \u2018Filter Options\u2019 section in the \u2018Formula\u2019 task?<\/strong><\/p>\n<p>The \u2018Filter Options\u2019 section in the \u2018Formula\u2019 task can be used to modify features of the output table.<\/p>\n<p>More information about this section is available <em><strong><a href=\"https:\/\/support.zippydoc.de\/output-table-options\/filter-options\/filter-options\/\">here<\/a><\/strong><\/em>.<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><strong>How to use the \u2018Define Output Table\u2019 and the \u2018Output Options\u2019 sections in the \u2018Formula\u2019 task?<\/strong><\/p>\n<p>The \u2018Output Options\u2019 section in the \u2018Formula\u2019 task can be used to modify features of the output table. The fields related to this section become visible on selecting the \u2018Output Options\u2019 checkbox.<\/p>\n<p>More information about this section is available <em><strong><a href=\"https:\/\/support.zippydoc.de\/output-table-options\/output-options\/output-options\/\">here<\/a><\/strong><\/em>.<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><iframe title=\"YouTube video player\" src=\"https:\/\/www.youtube.com\/embed\/Jxf4dNlyxFc\" width=\"560\" height=\"315\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n","protected":false},"excerpt":{"rendered":"<p>The \u2018Formula\u2019 task can be used to carry out a variety of custom calculations on numerical or text data. It is a flexible tool to carry out complex numerical or text calculations. The filtering feature and ability to add multiple formulae to a flow make it a powerful tool to carry out complex, multi-level calculations. Furthermore, the ability to add annotations and descriptions at each step helps in reviewing and updating calculations at any time.<\/p>\n","protected":false},"author":6,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[158],"tags":[186,188,187,185,189,190,33],"featured_image_src":{"landsacpe":false,"list":false,"medium":false,"full":false},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v19.0 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Formula - Zippydoc Support<\/title>\n<meta name=\"description\" content=\"The \u2018Formula\u2019 task can be used to carry out a variety of custom calculations on numerical or text data. It is a flexible tool to carry out complex numerical or text calculations. The filtering feature and ability to add multiple formulae to a flow make it a powerful tool to carry out complex, multi-level calculations. Furthermore, the ability to add annotations and descriptions at each step helps in reviewing and updating calculations at any time.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/support.zippydoc.de\/en\/formula\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Formula - Zippydoc Support\" \/>\n<meta property=\"og:description\" content=\"The \u2018Formula\u2019 task can be used to carry out a variety of custom calculations on numerical or text data. It is a flexible tool to carry out complex numerical or text calculations. The filtering feature and ability to add multiple formulae to a flow make it a powerful tool to carry out complex, multi-level calculations. Furthermore, the ability to add annotations and descriptions at each step helps in reviewing and updating calculations at any time.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/support.zippydoc.de\/en\/formula\/\" \/>\n<meta property=\"og:site_name\" content=\"Zippydoc Support\" \/>\n<meta property=\"article:published_time\" content=\"2021-05-22T12:36:14+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-06-15T14:09:17+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/support.zippydoc.de\/wp-content\/uploads\/2021\/05\/v1-TD-Formula-Pictogram-e1621710693867.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Tejas Valake\" \/>\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\":\"WebSite\",\"@id\":\"https:\/\/support.zippydoc.de\/en\/#website\",\"url\":\"https:\/\/support.zippydoc.de\/en\/\",\"name\":\"Zippydoc Support\",\"description\":\"Connect as if by magic\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/support.zippydoc.de\/en\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/support.zippydoc.de\/en\/formula\/#primaryimage\",\"url\":\"https:\/\/support.zippydoc.de\/wp-content\/uploads\/2021\/05\/v1-TD-Formula-Pictogram-e1621710693867.png\",\"contentUrl\":\"https:\/\/support.zippydoc.de\/wp-content\/uploads\/2021\/05\/v1-TD-Formula-Pictogram-e1621710693867.png\",\"width\":681,\"height\":150},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/support.zippydoc.de\/en\/formula\/#webpage\",\"url\":\"https:\/\/support.zippydoc.de\/en\/formula\/\",\"name\":\"Formula - Zippydoc Support\",\"isPartOf\":{\"@id\":\"https:\/\/support.zippydoc.de\/en\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/support.zippydoc.de\/en\/formula\/#primaryimage\"},\"datePublished\":\"2021-05-22T12:36:14+00:00\",\"dateModified\":\"2021-06-15T14:09:17+00:00\",\"author\":{\"@id\":\"https:\/\/support.zippydoc.de\/en\/#\/schema\/person\/4dd5b174233e1b7f097497d8e2a9e946\"},\"description\":\"The \u2018Formula\u2019 task can be used to carry out a variety of custom calculations on numerical or text data. It is a flexible tool to carry out complex numerical or text calculations. The filtering feature and ability to add multiple formulae to a flow make it a powerful tool to carry out complex, multi-level calculations. Furthermore, the ability to add annotations and descriptions at each step helps in reviewing and updating calculations at any time.\",\"breadcrumb\":{\"@id\":\"https:\/\/support.zippydoc.de\/en\/formula\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/support.zippydoc.de\/en\/formula\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/support.zippydoc.de\/en\/formula\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/support.zippydoc.de\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Formula\"}]},{\"@type\":\"Person\",\"@id\":\"https:\/\/support.zippydoc.de\/en\/#\/schema\/person\/4dd5b174233e1b7f097497d8e2a9e946\",\"name\":\"Tejas Valake\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/support.zippydoc.de\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/29659872a5889dde06af986e03bd8c12?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/29659872a5889dde06af986e03bd8c12?s=96&d=mm&r=g\",\"caption\":\"Tejas Valake\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Formula - Zippydoc Support","description":"The \u2018Formula\u2019 task can be used to carry out a variety of custom calculations on numerical or text data. It is a flexible tool to carry out complex numerical or text calculations. The filtering feature and ability to add multiple formulae to a flow make it a powerful tool to carry out complex, multi-level calculations. Furthermore, the ability to add annotations and descriptions at each step helps in reviewing and updating calculations at any time.","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:\/\/support.zippydoc.de\/en\/formula\/","og_locale":"en_US","og_type":"article","og_title":"Formula - Zippydoc Support","og_description":"The \u2018Formula\u2019 task can be used to carry out a variety of custom calculations on numerical or text data. It is a flexible tool to carry out complex numerical or text calculations. The filtering feature and ability to add multiple formulae to a flow make it a powerful tool to carry out complex, multi-level calculations. Furthermore, the ability to add annotations and descriptions at each step helps in reviewing and updating calculations at any time.","og_url":"https:\/\/support.zippydoc.de\/en\/formula\/","og_site_name":"Zippydoc Support","article_published_time":"2021-05-22T12:36:14+00:00","article_modified_time":"2021-06-15T14:09:17+00:00","og_image":[{"url":"https:\/\/support.zippydoc.de\/wp-content\/uploads\/2021\/05\/v1-TD-Formula-Pictogram-e1621710693867.png"}],"twitter_card":"summary_large_image","twitter_misc":{"Written by":"Tejas Valake","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebSite","@id":"https:\/\/support.zippydoc.de\/en\/#website","url":"https:\/\/support.zippydoc.de\/en\/","name":"Zippydoc Support","description":"Connect as if by magic","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/support.zippydoc.de\/en\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/support.zippydoc.de\/en\/formula\/#primaryimage","url":"https:\/\/support.zippydoc.de\/wp-content\/uploads\/2021\/05\/v1-TD-Formula-Pictogram-e1621710693867.png","contentUrl":"https:\/\/support.zippydoc.de\/wp-content\/uploads\/2021\/05\/v1-TD-Formula-Pictogram-e1621710693867.png","width":681,"height":150},{"@type":"WebPage","@id":"https:\/\/support.zippydoc.de\/en\/formula\/#webpage","url":"https:\/\/support.zippydoc.de\/en\/formula\/","name":"Formula - Zippydoc Support","isPartOf":{"@id":"https:\/\/support.zippydoc.de\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/support.zippydoc.de\/en\/formula\/#primaryimage"},"datePublished":"2021-05-22T12:36:14+00:00","dateModified":"2021-06-15T14:09:17+00:00","author":{"@id":"https:\/\/support.zippydoc.de\/en\/#\/schema\/person\/4dd5b174233e1b7f097497d8e2a9e946"},"description":"The \u2018Formula\u2019 task can be used to carry out a variety of custom calculations on numerical or text data. It is a flexible tool to carry out complex numerical or text calculations. The filtering feature and ability to add multiple formulae to a flow make it a powerful tool to carry out complex, multi-level calculations. Furthermore, the ability to add annotations and descriptions at each step helps in reviewing and updating calculations at any time.","breadcrumb":{"@id":"https:\/\/support.zippydoc.de\/en\/formula\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/support.zippydoc.de\/en\/formula\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/support.zippydoc.de\/en\/formula\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/support.zippydoc.de\/en\/"},{"@type":"ListItem","position":2,"name":"Formula"}]},{"@type":"Person","@id":"https:\/\/support.zippydoc.de\/en\/#\/schema\/person\/4dd5b174233e1b7f097497d8e2a9e946","name":"Tejas Valake","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/support.zippydoc.de\/en\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/29659872a5889dde06af986e03bd8c12?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/29659872a5889dde06af986e03bd8c12?s=96&d=mm&r=g","caption":"Tejas Valake"}}]}},"_links":{"self":[{"href":"https:\/\/support.zippydoc.de\/en\/wp-json\/wp\/v2\/posts\/535"}],"collection":[{"href":"https:\/\/support.zippydoc.de\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/support.zippydoc.de\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/support.zippydoc.de\/en\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/support.zippydoc.de\/en\/wp-json\/wp\/v2\/comments?post=535"}],"version-history":[{"count":0,"href":"https:\/\/support.zippydoc.de\/en\/wp-json\/wp\/v2\/posts\/535\/revisions"}],"wp:attachment":[{"href":"https:\/\/support.zippydoc.de\/en\/wp-json\/wp\/v2\/media?parent=535"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/support.zippydoc.de\/en\/wp-json\/wp\/v2\/categories?post=535"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/support.zippydoc.de\/en\/wp-json\/wp\/v2\/tags?post=535"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}