{"id":7656,"date":"2014-04-16T13:47:39","date_gmt":"2014-04-16T18:47:39","guid":{"rendered":"http:\/\/www.mrc-productivity.com\/docs\/?page_id=7656"},"modified":"2023-08-07T10:58:22","modified_gmt":"2023-08-07T15:58:22","slug":"display-and-maintain-rows-calendar-template","status":"publish","type":"ht_kb","link":"https:\/\/www.mrc-productivity.com\/docs\/knowledge-base\/display-and-maintain-rows-calendar-template","title":{"rendered":"Calendar Template"},"content":{"rendered":"\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<p>The Calendar maintenance template is a full-featured web application that allows users to both view their data, as well as modify it one record at a time. This template allows users to view their data in a calendar format, and easily work with this data in a drag and drop format to change dates. In addition, the calendar template supports the standard maintenance action modes, including:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Add<\/li>\n\n\n\n<li>Update<\/li>\n\n\n\n<li>Delete<\/li>\n<\/ul>\n<\/div><\/div>\n\n\n\n<p>By default, this template consists of three screens: one screen for listing records in calendar format, another to allow for maintaining records, and lastly a selections dialog for searching. An optional parameter allows developers the option of combining these functions into one screen for increased usability. This template allows users, or developers, to specify whether the calendar display should appear in month, week, or day format.<\/p>\n\n\n\n<p>Additionally, developers can control whether or not the update feature is enabled for this application. When the update feature is turned off, this application behaves similar to the standard calendar retrieval, but with many more features. <\/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\"><strong><a id=\"runtime\" class=\"anchor\"><\/a>Runtime Walkthrough<\/strong><\/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=\"Calendar Template\" width=\"643\" height=\"482\" src=\"https:\/\/www.youtube.com\/embed\/QyN56RfOrvQ?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\">Template Features<\/h2>\n\n\n\n<p>Below lists out all the template features offered by the Calendar maintainer.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">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\">here<\/a>.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">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\u00a0<a rel=\"noreferrer noopener\" href=\"https:\/\/www.mrc-productivity.com\/docs\/knowledge-base\/field-settings\" target=\"_blank\">here<\/a>.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Dimensions<\/h3>\n\n\n\n<p>When building maintenance applications, a developer\u2019s dimension selection is analogous with selecting a Primary Key. This selection will tell m-Power how this table is unique. If the dimension key(s) are not unique, then multiple records will be affected when a record is modified or deleted. When working with a Calendar application, be sure to select the dimension key(s) by the fields that make your table distinct.<\/p>\n\n\n\n<p>To learn more about Dimensions, please see&nbsp;<a href=\"https:\/\/www.mrc-productivity.com\/docs\/knowledge-base\/dimensions\" target=\"_blank\" rel=\"noreferrer noopener\">here<\/a>.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">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>To learn more about Filters, please see&nbsp;<a rel=\"noreferrer noopener\" href=\"https:\/\/www.mrc-productivity.com\/docs\/knowledge-base\/filters\" target=\"_blank\">here<\/a>.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Calculations<\/h3>\n\n\n\n<p>Calculations are a very powerful feature of m-Power; with calculations, developers can create logical 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 class=\"wp-block-ht-blocks-messages wp-block-hb-message wp-block-hb-message--withicon is-style-info\"><strong>Note:<\/strong> 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 <a rel=\"noreferrer noopener\" href=\"https:\/\/www.mrc-productivity.com\/docs\/calcs\/m-power-calculation-screen\" target=\"_blank\">here.<\/a><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">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>*AFTERACT<\/strong>&nbsp;This location calls the object after a user either Adds, Updates, or Deletes a row.<br><strong>*AFTERADD<\/strong>&nbsp;This location calls the object only after a user Adds a row.<br><strong>*AFTERDLT<\/strong>&nbsp;This location calls the object only after a user Deletes a row.<br><strong>*AFTERUPD<\/strong>&nbsp;This location calls the object only after a user Updates a row.<br><strong>*BEFOREACT<\/strong>&nbsp;This location calls the object before a user either Adds, Updates, or Deletes a row.<br><strong>*BEFOREADD<\/strong>&nbsp;This location calls the object only before a user Adds a row.<br><strong>*BEFOREDLT<\/strong>&nbsp;This location calls the object only before a user Deletes a row.<br><strong>*BEFOREUPD<\/strong>&nbsp;This location calls the object only before a user Updates a row.<br><strong>*CALCOBJ<\/strong>&nbsp;This location calls the object for every row, after performing calculations.<br><strong>*READRECRD<\/strong>&nbsp;This location calls the object for every row, before performing calculations.<br><strong>*INITACT<\/strong>&nbsp;This location calls the object when the page loads, no matter the action mode.<br><strong>*INITADD<\/strong>&nbsp;This location calls the object on page load, only when the user is Add mode.<br><strong>*INITDLT<\/strong>&nbsp;This location calls the object on page load, only when the user is in Delete mode.<br><strong>*INITUPD<\/strong>&nbsp;This location calls the object on page load, only when the user is in Update mode.<br><strong>*REDIRECT<\/strong>&nbsp;This location is deprecated in this template.<br><strong>*AFTADDRE<\/strong>&nbsp;This location is deprecated in this template.<br><strong>*AFTDLTRE<\/strong>&nbsp;This location is deprecated in this template.<br><strong>*AFTUPDRE<\/strong>&nbsp;This location is deprecated in this template.<br><strong>*FLDVALID<\/strong>&nbsp;This location calls the object to validate fields before every action.<\/p>\n\n\n\n<p>To learn more about External Objects, please see <a href=\"https:\/\/www.mrc-productivity.com\/docs\/m-power-build-process\/external-objects\" target=\"_blank\" rel=\"noreferrer noopener\">here.<\/a><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">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 &#8220;drilldown&#8221; 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>To learn more about Calculations, please see <a rel=\"noreferrer noopener\" href=\"https:\/\/www.mrc-productivity.com\/docs\/m-power-build-process\/working-with-smartlinks\" target=\"_blank\">here.<\/a><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Template Properties<\/h3>\n\n\n\n<p>The Calendar template is unique in that it is calendar based. The developer needs to indicate which date field should be mapped on the calendar.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Field containing start date:&nbsp;<\/strong>Select the field from your application which will make up your start date. If your table only uses one date field, select it here.<\/li>\n\n\n\n<li><strong>Field containing start time (Optional):&nbsp;<\/strong>If you would like your application to use a start time, select the desired field from the dropdown list.<\/li>\n\n\n\n<li><strong>Field containing end date (Optional):&nbsp;<\/strong>If you would like your application to use an end date, select the desired field from the dropdown list.<\/li>\n\n\n\n<li><strong>Field containing end time (Optional):&nbsp;<\/strong>If you would like your application to use an end time, select the desired field from the dropdown list.<\/li>\n\n\n\n<li><strong>Format for start date\/time, and end date\/time:&nbsp;<\/strong>If your field is a true date or time, you may leave this option set to &#8216;Field is date\/time&#8217;. Otherwise, select the appropriate format for your field.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"\/docs\/vue-images\/calendartemplate.png\" alt=\"\"\/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>To learn more about Template Properties, please see\u00a0<a rel=\"noreferrer noopener\" href=\"https:\/\/www.mrc-productivity.com\/docs\/knowledge-base\/template-properties\" target=\"_blank\">here.<\/a><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">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 record is added, updated, or deleted from this application.<\/p>\n\n\n\n<p>To learn more about the Workflow Designer, please see <strong><a rel=\"noreferrer noopener\" href=\"\/docs\/knowledge-base\/workflow-designer\" target=\"_blank\">here<\/a><\/strong>.<\/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.<\/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 Calendar 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\">here<\/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\">Calendar 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>Clickable Event &#8212;<\/strong> This property allows developers to control whether end-users can click on an event. Doing so will open a modal window displaying details about the event. Additionally, users can modify the record, if applicable, from this option.<br><br><strong>Activate Drag and Drop &#8212; <\/strong>Enabling this feature gives the end-users the ability to drag and drop their calendar events to a different day. Doing so will automatically commit the change to the database.<br><br><strong>Confirm Drag and Drop &#8212;<\/strong> This property is only applicable when the Drag and Drop feature is enabled. The purpose of this property is to control if a confirmation window should appear after a user drags a calendar event to a new date\/time. If this property is set to No, the change is committed immediately. If the property is set to Yes, the user will need to first confirm their change.<br><br><strong>Default Calendar Layout<\/strong> <strong>&#8212;<\/strong> This property controls the default behavior of this calendar. While the user can override the default behavior, you have the ability to decide if the calendar should load in month, week, or day view.<br><br><strong>Detail Window Behavior &#8212; <\/strong>This property is only active when the &#8220;Clickable Event&#8221; property is set to Yes. This property controls the location of the detail window when a user clicks on a calendar event.<br><br><strong>Show Weekends<\/strong> <strong>&#8212;<\/strong> This property controls whether Saturday and Sunday will be included in your calendar display.<\/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 an Calendar 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.&nbsp;<code>http:\/\/mpowerserveraddress:8011\/mrcjava\/servlet\/DICTIONARY.M00010s?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&nbsp;<a href=\"https:\/\/www.mrc-productivity.com\/docs\/knowledge-base\/troubleshooting-m-power-applications#runtime-parameter-listings-help1\" target=\"_blank\" rel=\"noreferrer noopener\">here<\/a>.<\/p>\n\n\n\n<p><a id=\"all_chart\" class=\"anchor\"><\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong><a id=\"in-action\" class=\"anchor\"><\/a>Template In-Action<\/strong><\/h2>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"\/docs\/vue-images\/calendarTemplate.jpg\"><img decoding=\"async\" src=\"\/docs\/vue-images\/calendarTemplate.jpg\" alt=\"\"\/><\/a><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><strong><a id=\"parameters\" class=\"anchor\"><\/a><\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>The Calendar maintenance template is a full-featured web application that allows users to both view their data, as well as modify it one record at a time. This template allows users to view their data in a calendar format, and easily work with this data in a drag and drop&#8230;<\/p>\n","protected":false},"author":1,"comment_status":"closed","ping_status":"open","template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[252],"ht-kb-tag":[],"class_list":["post-7656","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\/7656","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=7656"}],"version-history":[{"count":27,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb\/7656\/revisions"}],"predecessor-version":[{"id":13137,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb\/7656\/revisions\/13137"}],"wp:attachment":[{"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/media?parent=7656"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb-category?post=7656"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb-tag?post=7656"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}