{"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"],"_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}]}}