{"id":1676,"date":"2020-07-08T14:45:29","date_gmt":"2020-07-08T14:45:29","guid":{"rendered":"https:\/\/help.hbsoftware365.com\/?p=1676"},"modified":"2021-12-23T13:28:33","modified_gmt":"2021-12-23T13:28:33","slug":"exsion-functie-definitie","status":"publish","type":"post","link":"https:\/\/help.hbsoftware365.com\/smarttrade\/st-about-smarttrade-help\/st-intro\/help-exsion\/exsion-menu-opties\/exsion-functie-definitie\/","title":{"rendered":"Functie definitie"},"content":{"rendered":"\n<h1 class=\"wp-block-heading\">\n\t\tExsion-Functie definitie\n\t<\/h1>\n\n\n\n<p>Naast het aanmaken van een functie in de (gedeelde) functiebibliotheek is het ook mogelijk om een functie in een Exsion bestand op te nemen. Het voordeel van deze manier is dat iedereen het rapport met de functie kan gebruiken zonder dat de functie in de bibliotheek aanwezig dient te zijn.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Werking<\/h2>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/help.hbsoftware365.com\/wp-content\/uploads\/functiedefinitie1.png\" alt=\"\" title=\"HB Vastgoed logo_ico\"\/><\/figure>\n\n\n\n<p><a href=\"http:\/\/help.hbsoftware365.com\/exsgeavanceerdefuncties\/\">Database functies<\/a> gebruiken als argument (definitie) een bereik waarin de tabel, indexvelden en de veldnaam waarvan de waarde moet worden opgehaald.<\/p>\n\n\n\n<p>Om een definitie aan te maken om het bereik waarin de tabel en indexvelden zijn opgenomen moet u kiezen voor de optie \u201c<b>Functie definitie<\/b>\u201d. In dit scherm moeten achtereenvolgens de tabel, het veld en de index worden opgegeven.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/help.hbsoftware365.com\/wp-content\/uploads\/functiedefinitie2.png\" alt=\"\" title=\"HB Vastgoed logo_ico\"\/><\/figure>\n\n\n\n<p>Na het drukken op de \u201c<b>OK<\/b>\u201d knop vraagt Exsion om een naam aan de functie definitie te geven.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/help.hbsoftware365.com\/wp-content\/uploads\/functiedefinitie3.png\" alt=\"\" title=\"HB Vastgoed logo_ico\"\/><\/figure>\n\n\n\n<p>Indien het gekozen veld een FlowField is zal Exsion voorstellen om de functie op de brontabel van het FlowField aan te maken.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/help.hbsoftware365.com\/wp-content\/uploads\/functiedefinitie4.png\" alt=\"\" title=\"HB Vastgoed logo_ico\"\/><\/figure>\n\n\n\n<p>En wordt de tabel met de geselecteerde index gekopieerd naar de actieve cel in Excel.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/help.hbsoftware365.com\/wp-content\/uploads\/functiedefinitie5.png\" alt=\"\" title=\"HB Vastgoed logo_ico\"\/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Zie ook<\/h3>\n\n\n\n<p>Zie het hoofdstuk <a href=\"http:\/\/help.hbsoftware365.com\/exsgeavanceerdefuncties\/\">Database functies<\/a>, voor een lijst met functies die gebruik maken van deze functie definitie.<\/p>\n\n\n\n<p>\u00a9HB Software B.V.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Exsion-Functie definitie Naast het aanmaken van een functie in de (gedeelde) functiebibliotheek is het ook mogelijk om een functie in een Exsion bestand [&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":"disabled","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":[45],"tags":[],"class_list":["post-1676","post","type-post","status-publish","format-standard","hentry","category-exsion-menu-opties"],"_links":{"self":[{"href":"https:\/\/help.hbsoftware365.com\/smarttrade\/st-about-smarttrade-help\/st-intro\/wp-json\/wp\/v2\/posts\/1676","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=1676"}],"version-history":[{"count":4,"href":"https:\/\/help.hbsoftware365.com\/smarttrade\/st-about-smarttrade-help\/st-intro\/wp-json\/wp\/v2\/posts\/1676\/revisions"}],"predecessor-version":[{"id":3319,"href":"https:\/\/help.hbsoftware365.com\/smarttrade\/st-about-smarttrade-help\/st-intro\/wp-json\/wp\/v2\/posts\/1676\/revisions\/3319"}],"wp:attachment":[{"href":"https:\/\/help.hbsoftware365.com\/smarttrade\/st-about-smarttrade-help\/st-intro\/wp-json\/wp\/v2\/media?parent=1676"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/help.hbsoftware365.com\/smarttrade\/st-about-smarttrade-help\/st-intro\/wp-json\/wp\/v2\/categories?post=1676"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/help.hbsoftware365.com\/smarttrade\/st-about-smarttrade-help\/st-intro\/wp-json\/wp\/v2\/tags?post=1676"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}