{"id":6540,"date":"2013-09-24T09:45:50","date_gmt":"2013-09-24T14:45:50","guid":{"rendered":"http:\/\/www.mrc-productivity.com\/docs\/?page_id=6540"},"modified":"2023-09-12T15:34:40","modified_gmt":"2023-09-12T20:34:40","slug":"grid-add-maint-template","status":"publish","type":"ht_kb","link":"https:\/\/www.mrc-productivity.com\/docs\/knowledge-base\/grid-add-maint-template","title":{"rendered":"Grid Add Maintenance Template"},"content":{"rendered":"\n<p>As it sounds, this template allows adding multiple records on a grid at the same time. This template makes it a simple to create powerful, user-friendly interfaces for adding data.<\/p>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<h2 class=\"wp-block-heading\"><a id=\"runtime\" class=\"anchor\"><\/a>Runtime Walkthrough<\/h2>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-4-3 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe title=\"Grid Add Maintainer\" width=\"643\" height=\"482\" src=\"https:\/\/www.youtube.com\/embed\/4BIm7KSqAnM?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n<\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"template-features\">Template Features<\/h2>\n\n\n\n<p>Below lists out all the template features offered by Grid Add Maintainer.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"tables-fields\">Tables\/Fields<\/h3>\n\n\n\n<p>Here you will see\/modify the table you have selected for your application. Here you can create or modify joins to other tables as well. When tables are selected, only the primary table can be modified, by default. This is done to protect developers from accidental cascading changes. This behavior can be modified within the application properties.<\/p>\n\n\n\n<p>To learn more about the Tables\/Fields section, please see&nbsp;<a href=\"https:\/\/www.mrc-productivity.com\/docs\/knowledge-base\/tablefield-selection\"><strong>here<\/strong><\/a>.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"field-settings\">Field Settings<\/h3>\n\n\n\n<p>Here you will find the settings for all the fields in the application. Maintainer templates have unique features that gives the developer methods of pre-formatted alternative inputs (simple dropdown lists, radio buttons, and checkboxes), form validation and auditing.<\/p>\n\n\n\n<p>You can find out more in detail about these options&nbsp;<a rel=\"noreferrer noopener\" href=\"https:\/\/www.mrc-productivity.com\/docs\/knowledge-base\/field-settings\" target=\"_blank\"><strong>here<\/strong><\/a>.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"dimensions\">Dimensions<\/h3>\n\n\n\n<p>When building maintenance applications, a developer\u2019s sequencing selection is analogous with selecting a Primary Key. This selection will tell m-Power how this table is unique. If the sequencing key(s) are not unique, then multiple records will be affected when a record is modified or deleted.<\/p>\n\n\n\n<p>To learn more about Dimensions, please see&nbsp;<a rel=\"noreferrer noopener\" href=\"https:\/\/www.mrc-productivity.com\/docs\/knowledge-base\/dimensions\" target=\"_blank\"><strong>here<\/strong><\/a>.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"filters\">Filters<\/h3>\n\n\n\n<p>Filters can be created over any database fields or calculations. They allow you to restrict the records that will be returned from the database at runtime.<\/p>\n\n\n\n<p class=\"wp-block-ht-blocks-messages wp-block-hb-message wp-block-hb-message--withicon is-style-danger\">Grid Add Maintainers do not display data, so filters are not supported.<\/p>\n\n\n\n<p>To learn more about Filters, please see&nbsp;<a rel=\"noreferrer noopener\" href=\"https:\/\/www.mrc-productivity.com\/docs\/knowledge-base\/filters\" target=\"_blank\"><strong>here<\/strong><\/a>.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"calculations\">Calculations<\/h3>\n\n\n\n<p>Fields that will apply to the current application only. This can be used to include SQL code in a field, such as cast a numeric field as character, create date conversions, inserting the current date and time, and much more.<\/p>\n\n\n\n<p><strong>Note:<\/strong>&nbsp;like all other application types, the result of a calculation is always read only. In other words, calculations are not written to the database in maintenance applications.<\/p>\n\n\n\n<p>To learn more about Calculations, please see&nbsp;<a rel=\"noreferrer noopener\" href=\"https:\/\/www.mrc-productivity.com\/docs\/calcs\/m-power-calculation-screen\" target=\"_blank\"><strong>here<\/strong>.<\/a><\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"external-objects\">External Objects<\/h3>\n\n\n\n<p>This feature allows developers to connect m-Power application with their current business logic, or to extend m-Power capabilities by allowing developers to write their own Java, RPG, or SQL programs, and integrating these programs into the applications. m-Power utilizes \u201clocations\u201d to connect the external objects, these locations vary depending on what the external object does and when it should be executed. The following locations are supported in this template:<\/p>\n\n\n\n<p><strong>*AFTERADD<\/strong>\u00a0This location calls the object only after a user adds a row.<br><strong>*AFTERPRC<\/strong>\u00a0This location calls the object after the last row is processed.<br><strong>*BEFOREADD<\/strong>\u00a0This location calls the object only before a user adds a row.<br><strong>*BEFOREPRC<\/strong>\u00a0This location calls the object after the first row is processed.<br><strong>*INITADD<\/strong>\u00a0This location calls the object when the page loads.<br><strong>*REDIRECT<\/strong>\u00a0This location is deprecated in this template.<br><strong>*FLDVALID<\/strong>\u00a0This location calls the object to validate fields before add.<\/p>\n\n\n\n<p>To learn more about External Objects, please see&nbsp;<a rel=\"noreferrer noopener\" href=\"https:\/\/www.mrc-productivity.com\/docs\/m-power-build-process\/external-objects\" target=\"_blank\"><strong>here<\/strong>.<\/a><\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"smartlinks\">Smartlinks<\/h3>\n\n\n\n<p>Smartlinks allow developers to easily link one application (Retrieval, Report, or Maintenance) to any other application, passing key data automatically. The benefit of Smartlinks is that it allows users the ability to quickly \u201cdrilldown\u201d into other applications based on the selected row. By passing parameters automatically when creating a link in m-Painter, Smartlinks save the developer time by simplifying the process.<\/p>\n\n\n\n<p class=\"wp-block-ht-blocks-messages wp-block-hb-message wp-block-hb-message--withicon is-style-danger\">Grid Add Maintainers do not display data, so Smartlinks are not supported.<\/p>\n\n\n\n<p>To learn more about Smartlinks, please see\u00a0<a rel=\"noreferrer noopener\" href=\"https:\/\/www.mrc-productivity.com\/docs\/m-power-build-process\/working-with-smartlinks\" target=\"_blank\"><strong>here<\/strong>.<\/a><\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"template-properties\">Template Properties<\/h3>\n\n\n\n<p>The Template Properties screen gives developers template specific settings. <\/p>\n\n\n\n<p>To learn more about Template Properties, please see&nbsp;<a rel=\"noreferrer noopener\" href=\"https:\/\/www.mrc-productivity.com\/docs\/knowledge-base\/template-properties\" target=\"_blank\"><strong>here<\/strong>.<\/a><\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"workflow-designer\">Workflow Designer<\/h3>\n\n\n\n<p>The Workflow Designer is unique to maintainer templates and lets you configure actions that you would like to trigger when a records are added from this application.<\/p>\n\n\n\n<p>To learn more about the Workflow Designer, please see\u00a0<strong><a rel=\"noreferrer noopener\" href=\"https:\/\/www.mrc-productivity.com\/docs\/knowledge-base\/workflow-designer\" target=\"_blank\">here<\/a><\/strong>.<a id=\"single_chart\" class=\"anchor\"><\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Edit Properties<\/h2>\n\n\n\n<p>The Edit Properties section allows you to control the behavior of the application. Every m-Power application has properties, however the list of available properties will be different depending on the template selected.<strong><a id=\"dataSelection\" class=\"anchor\"><\/a><a id=\"smartLinks\" class=\"anchor\"><\/a><\/strong><\/p>\n\n\n\n<p class=\"wp-block-ht-blocks-messages wp-block-hb-message wp-block-hb-message--withicon is-style-info\">This section below will only focus on properties that are specific to the Grid Add Maintainer template. A complete list of globally shared properties between all templates can be found\u00a0<a rel=\"noreferrer noopener\" href=\"https:\/\/www.mrc-productivity.com\/docs\/knowledge-base\/application-properties-overview\" target=\"_blank\"><strong>here<\/strong><\/a>.<\/p>\n\n\n\n<div class=\"wp-block-ht-blocks-tabs wp-block-hb-tabs\"><ul class=\"wp-block-hb-tabs__nav\" role=\"tablist\"><li class=\"wp-block-hb-tabs__head\" data-tab=\"tabs-0\" data-hb-tabs-tab--state=\"active\"><span class=\"wp-block-hb-tabs__head_item\" for=\"tab0\">Program Options<\/span><\/li><\/ul><div id=\"tabs-0\" class=\"wp-block-hb-tabs__content\" role=\"tabpanel\" data-hb-tabs-tab--state=\"active\"><p><br><strong>File Upload Directory &#8212; <\/strong>If utilizing the <strong><a rel=\"noreferrer noopener\" href=\"\/docs\/knowledge-base\/upload-files-to-server-via-web-2-0-maintenance-applications\" target=\"_blank\">file upload to server feature<\/a><\/strong>, this is where you specify the upload directory on the m-Power server.<br><br><strong>File Upload Auto Rename &#8212;<\/strong> If the uploaded file already exists in the specified directory on the server, the file will be overwritten or the filename will be renamed to &#8216;file(1).ext&#8217;, &#8216;file(2).ext&#8217;, etc.<br><br><strong>File Upload Max Size &#8212;<\/strong> Maximum size of file to be uploaded (in Mb).<br><br><strong>Maintain Joined Tables? &#8212;<\/strong> Determines if joined secondary tables can be maintained or not. Determines if joined secondary tables can be maintained or not. Maintain primary table only is the default property.<br><br><strong>Duplicate Records<\/strong> &#8212; Specify if duplicate records are allowed to be added.<\/p><\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">URL Parameters<\/h2>\n\n\n\n<p>A complete list of runtime parameters that can be passed to a Grid Add Maintainer template can be seen by using Parameter Listing (help=1) tool.<\/p>\n\n\n\n<p>To launch this feature, simply add<strong>&nbsp;?help=1<\/strong>&nbsp;to the end of the URL of any m-Power application and hit Enter.<\/p>\n\n\n\n<p>ex.\u00a0<code>http:\/\/mpowerserveraddress:8011\/mrcjava\/servlet\/DICTIONARY.M00050s?help=1<\/code><\/p>\n\n\n\n<p class=\"wp-block-ht-blocks-messages wp-block-hb-message wp-block-hb-message--withicon is-style-info\">This is an example URL. Please substitute your appropriate values, such as the m-Power server address, the dictionary name, and the application number into your own URL.<\/p>\n\n\n\n<p>For more information on the Parameter Listing tool, please see\u00a0<a rel=\"noreferrer noopener\" href=\"https:\/\/www.mrc-productivity.com\/docs\/knowledge-base\/troubleshooting-m-power-applications#runtime-parameter-listings-help1\" target=\"_blank\">here<\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Template In-Action<\/h2>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"\/docs\/vue-images\/gridAddMaintainer.jpg\"><img decoding=\"async\" src=\"\/docs\/vue-images\/gridAddMaintainer.jpg\" alt=\"\"\/><\/a><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong><a id=\"properties\" class=\"anchor\"><\/a><\/strong><\/h2>\n","protected":false},"excerpt":{"rendered":"<p>As it sounds, this template allows adding multiple records on a grid at the same time. This template makes it a simple to create powerful, user-friendly interfaces for adding data. Runtime Walkthrough Template Features Below lists out all the template features offered by Grid Add Maintainer. Tables\/Fields Here you will&#8230;<\/p>\n","protected":false},"author":1,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[252],"ht-kb-tag":[],"class_list":["post-6540","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-maintainer"],"_links":{"self":[{"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb\/6540","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/comments?post=6540"}],"version-history":[{"count":33,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb\/6540\/revisions"}],"predecessor-version":[{"id":13186,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb\/6540\/revisions\/13186"}],"wp:attachment":[{"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/media?parent=6540"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb-category?post=6540"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb-tag?post=6540"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}