{"id":2684,"date":"2021-06-08T13:10:14","date_gmt":"2021-06-08T13:10:14","guid":{"rendered":"https:\/\/help.hbsoftware365.com\/?p=2684"},"modified":"2021-07-19T09:51:15","modified_gmt":"2021-07-19T09:51:15","slug":"function-definition","status":"publish","type":"post","link":"https:\/\/help.hbsoftware365.com\/smarttrade\/st-about-smarttrade-help\/st-intro\/exsion-help-eng\/exsion-eng-06-menu-options\/function-definition\/","title":{"rendered":"Function definition"},"content":{"rendered":"\n\n\t\t\t\t<img decoding=\"async\" src=\"http:\/\/help.hbsoftware365.com\/wp-content\/uploads\/ExsionMenu_FunctionDefinition.png\" alt=\"ExsionMenu_FunctionDefinition\" itemprop=\"image\" title=\"ExsionMenu_FunctionDefinition\" onerror=\"this.style.display='none'\"  \/>\n\t<p>Functions can also be created without storing them in the Function Libray. The advantage is that it also can be used by Exsion users where the Function Library is not available.<\/p>\n<p>These so called static functions use a range definition as an argument that includes the Table, Field and Index from which information is to be retrieved.<\/p>\n<p>To create a static function click &#8220;<b>Function definition<\/b>&#8221; in the menu. Here you can enter the information as described above.<\/p>\n\t\t\t\t<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/help.hbsoftware365.com\/wp-content\/uploads\/Exsion_FunctionDefinition_Parameters.png\" alt=\"Exsion_FunctionDefinition_Parameters\" itemprop=\"image\" height=\"345\" width=\"376\" title=\"Exsion_FunctionDefinition_Parameters\" onerror=\"this.style.display='none'\"  \/>\n\t<p>After you click &#8220;<b>OK<\/b>&#8221; a name can be entered for this function.<\/p>\n\t\t\t\t<img decoding=\"async\" src=\"http:\/\/help.hbsoftware365.com\/wp-content\/uploads\/Exsion_FunctionDefinition_Name.png\" alt=\"Exsion_FunctionDefinition_Name\" itemprop=\"image\" title=\"Exsion_FunctionDefinition_Name\" onerror=\"this.style.display='none'\"  \/>\n\t<p>If the selected field is a flowfield, Exsion will ask if the source table for this field must be used.<\/p>\n\t\t\t\t<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/help.hbsoftware365.com\/wp-content\/uploads\/Exsion_FunctionDefinition_Inherit.png\" alt=\"Exsion_FunctionDefinition_Inherit\" itemprop=\"image\" height=\"165\" width=\"270\" title=\"Exsion_FunctionDefinition_Inherit\" onerror=\"this.style.display='none'\"  \/>\n\t<p>The function will now be stored in the worksheet in a readable format with the active cell as the top-left one.<\/p>\n\t\t\t\t<img decoding=\"async\" src=\"http:\/\/help.hbsoftware365.com\/wp-content\/uploads\/Exsion_FunctionDefinition_Sheet.png\" alt=\"Exsion_FunctionDefinition_Sheet\" itemprop=\"image\" title=\"Exsion_FunctionDefinition_Sheet\" onerror=\"this.style.display='none'\"  \/>\n\t<p>The chapter &#8220;Database functions&#8221; shows a list of Exsion functions that can use static functions.<\/p>\n\n","protected":false},"excerpt":{"rendered":"<p>Functions can also be created without storing them in the Function Libray. The advantage is that it also can be used by Exsion [&hellip;]<\/p>\n","protected":false},"author":6,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[67],"tags":[],"class_list":["post-2684","post","type-post","status-publish","format-standard","hentry","category-exsion-eng-06-menu-options"],"_links":{"self":[{"href":"https:\/\/help.hbsoftware365.com\/smarttrade\/st-about-smarttrade-help\/st-intro\/wp-json\/wp\/v2\/posts\/2684","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/help.hbsoftware365.com\/smarttrade\/st-about-smarttrade-help\/st-intro\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/help.hbsoftware365.com\/smarttrade\/st-about-smarttrade-help\/st-intro\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/help.hbsoftware365.com\/smarttrade\/st-about-smarttrade-help\/st-intro\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/help.hbsoftware365.com\/smarttrade\/st-about-smarttrade-help\/st-intro\/wp-json\/wp\/v2\/comments?post=2684"}],"version-history":[{"count":4,"href":"https:\/\/help.hbsoftware365.com\/smarttrade\/st-about-smarttrade-help\/st-intro\/wp-json\/wp\/v2\/posts\/2684\/revisions"}],"predecessor-version":[{"id":3066,"href":"https:\/\/help.hbsoftware365.com\/smarttrade\/st-about-smarttrade-help\/st-intro\/wp-json\/wp\/v2\/posts\/2684\/revisions\/3066"}],"wp:attachment":[{"href":"https:\/\/help.hbsoftware365.com\/smarttrade\/st-about-smarttrade-help\/st-intro\/wp-json\/wp\/v2\/media?parent=2684"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/help.hbsoftware365.com\/smarttrade\/st-about-smarttrade-help\/st-intro\/wp-json\/wp\/v2\/categories?post=2684"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/help.hbsoftware365.com\/smarttrade\/st-about-smarttrade-help\/st-intro\/wp-json\/wp\/v2\/tags?post=2684"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}