{"id":6458,"date":"2024-08-30T13:57:29","date_gmt":"2024-08-30T11:57:29","guid":{"rendered":"https:\/\/usemaps.com\/kb\/uncategorized\/advanced-formulas\/"},"modified":"2024-08-30T13:57:29","modified_gmt":"2024-08-30T11:57:29","slug":"advanced-formulas","status":"publish","type":"knowledgebase","link":"https:\/\/usemaps.com\/en\/usemaps-documentation\/definitions\/advanced-formulas\/","title":{"rendered":"Advanced Formulas"},"content":{"rendered":"<p>Advanced Formulas are the ability to add SQL code that controls the behavior of Data Sources, for example during editing.<\/p>\n<p>It is possible to:<\/p>\n<ol>\n<li>configure multi-level dictionaries based on another Data Source.<\/li>\n<li>define and trigger specific database triggers.<\/li>\n<\/ol>\n<p>The purpose of Advanced Formulas is to maximize the System\u2019s adaptation to Users\u2019 needs through automation, following the \u201cNo\/Low code\u201d principle, meaning without the need for additional programming.<\/p>\n<p>The article will be expanded with examples of how Advanced Formulas can be applied. If you are wondering whether it is possible to configure the System to meet your needs, please contact us. <\/p>\n","protected":false},"excerpt":{"rendered":"<p>Advanced Formulas are the ability to add SQL code that controls the behavior of Data Sources, for example during editing. It is possible to: configure multi-level dictionaries based on another Data Source. define and trigger specific database triggers. The purpose of Advanced Formulas is to maximize the System\u2019s adaptation to Users\u2019 needs through automation, following [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","template":"","knowledgebase_cat":[83],"knowledgebase_tag":[],"class_list":["post-6458","knowledgebase","type-knowledgebase","status-publish","hentry","knowledgebase_cat-definitions"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Advanced Formulas - Usemaps<\/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:\/\/usemaps.com\/kb\/definicje\/formuly-zaawansowane\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Advanced Formulas - Usemaps\" \/>\n<meta property=\"og:description\" content=\"Advanced Formulas are the ability to add SQL code that controls the behavior of Data Sources, for example during editing. It is possible to: configure multi-level dictionaries based on another Data Source. define and trigger specific database triggers. The purpose of Advanced Formulas is to maximize the System\u2019s adaptation to Users\u2019 needs through automation, following [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/usemaps.com\/kb\/definicje\/formuly-zaawansowane\/\" \/>\n<meta property=\"og:site_name\" content=\"Usemaps\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/usemaps.com\\\/kb\\\/definicje\\\/formuly-zaawansowane\\\/\",\"url\":\"https:\\\/\\\/usemaps.com\\\/kb\\\/definicje\\\/formuly-zaawansowane\\\/\",\"name\":\"Advanced Formulas - Usemaps\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/usemaps.com\\\/#website\"},\"datePublished\":\"2024-08-30T11:57:29+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/usemaps.com\\\/kb\\\/definicje\\\/formuly-zaawansowane\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/usemaps.com\\\/kb\\\/definicje\\\/formuly-zaawansowane\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/usemaps.com\\\/kb\\\/definicje\\\/formuly-zaawansowane\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/usemaps.com\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Advanced Formulas\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/usemaps.com\\\/#website\",\"url\":\"https:\\\/\\\/usemaps.com\\\/\",\"name\":\"Usemaps\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/usemaps.com\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/usemaps.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/usemaps.com\\\/#organization\",\"name\":\"Usemaps\",\"url\":\"https:\\\/\\\/usemaps.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/usemaps.com\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/usemaps.com\\\/wp-content\\\/uploads\\\/2025\\\/10\\\/brand.svg\",\"contentUrl\":\"https:\\\/\\\/usemaps.com\\\/wp-content\\\/uploads\\\/2025\\\/10\\\/brand.svg\",\"width\":182,\"height\":38,\"caption\":\"Usemaps\"},\"image\":{\"@id\":\"https:\\\/\\\/usemaps.com\\\/#\\\/schema\\\/logo\\\/image\\\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Advanced Formulas - Usemaps","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:\/\/usemaps.com\/kb\/definicje\/formuly-zaawansowane\/","og_locale":"en_US","og_type":"article","og_title":"Advanced Formulas - Usemaps","og_description":"Advanced Formulas are the ability to add SQL code that controls the behavior of Data Sources, for example during editing. It is possible to: configure multi-level dictionaries based on another Data Source. define and trigger specific database triggers. The purpose of Advanced Formulas is to maximize the System\u2019s adaptation to Users\u2019 needs through automation, following [&hellip;]","og_url":"https:\/\/usemaps.com\/kb\/definicje\/formuly-zaawansowane\/","og_site_name":"Usemaps","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/usemaps.com\/kb\/definicje\/formuly-zaawansowane\/","url":"https:\/\/usemaps.com\/kb\/definicje\/formuly-zaawansowane\/","name":"Advanced Formulas - Usemaps","isPartOf":{"@id":"https:\/\/usemaps.com\/#website"},"datePublished":"2024-08-30T11:57:29+00:00","breadcrumb":{"@id":"https:\/\/usemaps.com\/kb\/definicje\/formuly-zaawansowane\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/usemaps.com\/kb\/definicje\/formuly-zaawansowane\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/usemaps.com\/kb\/definicje\/formuly-zaawansowane\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/usemaps.com\/en\/"},{"@type":"ListItem","position":2,"name":"Advanced Formulas"}]},{"@type":"WebSite","@id":"https:\/\/usemaps.com\/#website","url":"https:\/\/usemaps.com\/","name":"Usemaps","description":"","publisher":{"@id":"https:\/\/usemaps.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/usemaps.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/usemaps.com\/#organization","name":"Usemaps","url":"https:\/\/usemaps.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/usemaps.com\/#\/schema\/logo\/image\/","url":"https:\/\/usemaps.com\/wp-content\/uploads\/2025\/10\/brand.svg","contentUrl":"https:\/\/usemaps.com\/wp-content\/uploads\/2025\/10\/brand.svg","width":182,"height":38,"caption":"Usemaps"},"image":{"@id":"https:\/\/usemaps.com\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/usemaps.com\/en\/wp-json\/wp\/v2\/knowledgebase\/6458","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/usemaps.com\/en\/wp-json\/wp\/v2\/knowledgebase"}],"about":[{"href":"https:\/\/usemaps.com\/en\/wp-json\/wp\/v2\/types\/knowledgebase"}],"author":[{"embeddable":true,"href":"https:\/\/usemaps.com\/en\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/usemaps.com\/en\/wp-json\/wp\/v2\/comments?post=6458"}],"version-history":[{"count":0,"href":"https:\/\/usemaps.com\/en\/wp-json\/wp\/v2\/knowledgebase\/6458\/revisions"}],"wp:attachment":[{"href":"https:\/\/usemaps.com\/en\/wp-json\/wp\/v2\/media?parent=6458"}],"wp:term":[{"taxonomy":"knowledgebase_cat","embeddable":true,"href":"https:\/\/usemaps.com\/en\/wp-json\/wp\/v2\/knowledgebase_cat?post=6458"},{"taxonomy":"knowledgebase_tag","embeddable":true,"href":"https:\/\/usemaps.com\/en\/wp-json\/wp\/v2\/knowledgebase_tag?post=6458"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}