{"id":149,"date":"2010-01-20T03:45:40","date_gmt":"2010-01-20T09:45:40","guid":{"rendered":"http:\/\/www.mrc-productivity.com\/docs\/?page_id=149"},"modified":"2021-09-28T13:03:11","modified_gmt":"2021-09-28T18:03:11","slug":"select-a-template","status":"publish","type":"ht_kb","link":"https:\/\/www.mrc-productivity.com\/docs\/knowledge-base\/select-a-template","title":{"rendered":"Select an Application Type and Template"},"content":{"rendered":"\n<p>m-Power ships with over a dozen templates which gives you numerous options when deciding how an application should look and function. The first decision is what type of application to create. m-Power defines four general types: Retrievals, Reports, Summaries, and Maintenance Applications. Then, each of those application types has specific templates to select from. The templates define the general layout and functionality of the resulting application.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" style=\"font-size:25px\">Picking an Application Type<\/h3>\n\n\n\n<p>To decide which type of application to create, ask this question: <strong>Will this application&#8230;<\/strong><\/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<h4 class=\"wp-block-heading\"> List multiple or single rows of data? <\/h4>\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<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<p> Build a <a href=\"#retrieval-templates\" data-type=\"internal\" data-id=\"#retrieval-templates\">Retrieval<\/a> Application. Select one of these templates: <\/p>\n<\/div><\/div>\n\n\n\n<ul class=\"wp-block-list\"><li>Multiple Row Data List<\/li><li>Single Row Data List<\/li><li>Option List<\/li><li>Row Level Security<\/li><\/ul>\n<\/div><\/div>\n<\/div><\/div>\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<h4 class=\"wp-block-heading\">Show sub- or grand-total data levels?<\/h4>\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<p> Build a <a href=\"#report-templates\" data-type=\"internal\" data-id=\"#report-templates\">Report<\/a> Application. Select one of these templates:  <\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Regular Report<\/li><li>Ranking Report<\/li><li>Interactive Report<\/li><li>OLAP Pivot Table<\/li><li>Cross Tab Report<\/li><\/ul>\n<\/div><\/div>\n<\/div><\/div>\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<h4 class=\"wp-block-heading\">Create a new data table (data warehouse)?<\/h4>\n\n\n\n<p> Build a <a href=\"#summary-templates\" data-type=\"internal\" data-id=\"#summary-templates\">Summary<\/a> Application. Select this template:  <\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Summary<\/li><\/ul>\n<\/div><\/div>\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<h4 class=\"wp-block-heading\">Maintain data?<\/h4>\n\n\n\n<p> Build a <a href=\"#maintenance-templates\" data-type=\"internal\" data-id=\"#maintenance-templates\">Maintenance<\/a> Application. Select one of these templates:  <\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Data List with Web Form<\/li><li>Single Row Web Form<\/li><li>Grid Add<\/li><li>Grid Update<\/li><li>Data Upload<\/li><li>Calendar<\/li><\/ul>\n<\/div><\/div>\n\n\n\n<p>Once you know which type of application to create, then you need to choose which template to use.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"Retrievals\" style=\"font-size:25px\">Retrieval Templates<\/h3>\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<h4 class=\"wp-block-heading\"> Multiple Row Data List <\/h4>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"\/docs\/vue-images\/mri_boot.jpg\"><img decoding=\"async\" src=\"https:\/\/www.mrc-productivity.com\/docs\/vue-images\/mri_boot.jpg\" alt=\"\"\/><\/a><\/figure>\n\n\n\n<ul class=\"wp-block-list\"><li>Provide a paginated list.<\/li><li>Filter and sort rows.<\/li><li>Create SmartLinks to drill-down into other apps for more detail.<\/li><\/ul>\n<\/div><\/div>\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<h4 class=\"wp-block-heading\">Single Row Data List<\/h4>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"\/docs\/vue-images\/sri_boot.jpg\"><img decoding=\"async\" src=\"https:\/\/www.mrc-productivity.com\/docs\/vue-images\/sri_boot.jpg\" alt=\"\"\/><\/a><\/figure>\n\n\n\n<ul class=\"wp-block-list\"><li>Show exactly one record at a time.<\/li><li>Infinite layout options to show even the most complex data clearly.<\/li><li>Import related info into other apps.<\/li><\/ul>\n<\/div><\/div>\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<h4 class=\"wp-block-heading\">Option List Retrieval<\/h4>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"\/docs\/vue-images\/opt_boot.jpg\"><img decoding=\"async\" src=\"https:\/\/www.mrc-productivity.com\/docs\/vue-images\/opt_boot.jpg\" alt=\"\"\/><\/a><\/figure>\n\n\n\n<ul class=\"wp-block-list\"><li>Build drop-down lists\/radio button objects that can be used in any other application.<\/li><li>Control what values are shown to the user and which are submitted to the database.<\/li><\/ul>\n<\/div><\/div>\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<h4 class=\"wp-block-heading\">Row Level Security<\/h4>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"\/docs\/vue-images\/rowlvlsec_boot.jpg\"><img decoding=\"async\" src=\"https:\/\/www.mrc-productivity.com\/docs\/vue-images\/rowlvlsec_boot.jpg\" alt=\"\"\/><\/a><\/figure>\n\n\n\n<ul class=\"wp-block-list\"><li>Build a retrieval over data that can be used for validation in any other application.<\/li><li>Allows different users to see different data in the same application.<\/li><\/ul>\n<\/div><\/div>\n\n\n\n<h3 class=\"wp-block-heading\" style=\"font-size:25px\">Report Templates<\/h3>\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<h4 class=\"wp-block-heading\"> Prompted Report <\/h4>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"\/docs\/vue-images\/report_boot.jpg\"><img decoding=\"async\" src=\"https:\/\/www.mrc-productivity.com\/docs\/vue-images\/report_boot.jpg\" alt=\"\"\/><\/a><\/figure>\n\n\n\n<ul class=\"wp-block-list\"><li>Display sub- and grand-total values.<\/li><li>Numerous output types: HTML, Excel, PDF, email, and more.<\/li><li>Separate prompt screen for user inputs.<\/li><li>Bar, pie, line or speedometer chart.<\/li><li>Enable drill-down through the graphed values.<\/li><\/ul>\n<\/div><\/div>\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<h4 class=\"wp-block-heading\">Ranking Report<\/h4>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"\/docs\/vue-images\/rank_boot.jpg\"><img decoding=\"async\" src=\"https:\/\/www.mrc-productivity.com\/docs\/vue-images\/rank_boot.jpg\" alt=\"\"\/><\/a><\/figure>\n\n\n\n<ul class=\"wp-block-list\"><li>Automatically list top results based on user-selected options like dimension and record selections.<\/li><li>Report the results on the output screen.<\/li><\/ul>\n<\/div><\/div>\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<h4 class=\"wp-block-heading\">Interactive Report<\/h4>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"\/docs\/vue-images\/irt_boot.jpg\"><img decoding=\"async\" src=\"https:\/\/www.mrc-productivity.com\/docs\/vue-images\/irt_boot.jpg\" alt=\"\"\/><\/a><\/figure>\n\n\n\n<ul class=\"wp-block-list\"><li>AJAX-executed report provides a connected feel experience.<\/li><li>Automatically drill-down into lower level of details within the same report.<\/li><li>Smart selections show related\/unrelated data as selections are made.<\/li><\/ul>\n<\/div><\/div>\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<h4 class=\"wp-block-heading\">OLAP Pivot Table<\/h4>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"\/docs\/vue-images\/OLAP_boot.jpg\"><img decoding=\"async\" src=\"https:\/\/www.mrc-productivity.com\/docs\/vue-images\/OLAP_boot.jpg\" alt=\"\"\/><\/a><\/figure>\n\n\n\n<ul class=\"wp-block-list\"><li>Allows users to control both the row and column for a report.<\/li><li>Automatically totals all rows and columns to spot trends within data.<\/li><li>Interactive graph where users can change graph types and values.<\/li><\/ul>\n<\/div><\/div>\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<h4 class=\"wp-block-heading\">Cross Tab Report<\/h4>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"\/docs\/vue-images\/crosstab_boot.jpg\"><img decoding=\"async\" src=\"https:\/\/www.mrc-productivity.com\/docs\/vue-images\/crosstab_boot.jpg\" alt=\"\"\/><\/a><\/figure>\n\n\n\n<ul class=\"wp-block-list\"><li>Allows users to control both the row and column for a report.<\/li><li>Allows custom painting in m-Painter.<\/li><li>Can be generated to Excel\/PDF or run in batch.<\/li><\/ul>\n<\/div><\/div>\n\n\n\n<h3 class=\"wp-block-heading\" style=\"font-size:25px\">Summary Template<\/h3>\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<h4 class=\"wp-block-heading\">Summary<\/h4>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"\/docs\/vue-images\/sum_boot.jpg\"><img decoding=\"async\" src=\"https:\/\/www.mrc-productivity.com\/docs\/vue-images\/sum_boot.jpg\" alt=\"\"\/><\/a><\/figure>\n\n\n\n<ul class=\"wp-block-list\"><li>Produce data marts for Business Intelligence and Dashboard apps.<\/li><li>Run batch-capable apps with built-in scripting and scheduling.<\/li><\/ul>\n<\/div><\/div>\n\n\n\n<h3 class=\"wp-block-heading\" style=\"font-size:25px\">Maintenance Templates<\/h3>\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<h4 class=\"wp-block-heading\"> Data List with Web Form <\/h4>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"\/docs\/vue-images\/dmr_boot.jpg\"><img decoding=\"async\" src=\"https:\/\/www.mrc-productivity.com\/docs\/vue-images\/dmr_boot.jpg\" alt=\"\"\/><\/a><\/figure>\n\n\n\n<ul class=\"wp-block-list\"><li>Users can view, copy, update, delete, and create new records.<\/li><li>Perfect for master-table maintenance.<\/li><li>Developers control which functions are available.<\/li><\/ul>\n<\/div><\/div>\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<h4 class=\"wp-block-heading\"> Single Row Data List <\/h4>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"\/docs\/vue-images\/srm_boot.jpg\"><img decoding=\"async\" src=\"https:\/\/www.mrc-productivity.com\/docs\/vue-images\/srm_boot.jpg\" alt=\"\"\/><\/a><\/figure>\n\n\n\n<ul class=\"wp-block-list\"><li>Enable update of one record at a time.<\/li><li>Create a prompt screen to front other screens or server-side functions.<\/li><\/ul>\n<\/div><\/div>\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<h4 class=\"wp-block-heading\">Grid Add Maintenance<\/h4>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"\/docs\/vue-images\/gridadd_boot.jpg\"><img decoding=\"async\" src=\"https:\/\/www.mrc-productivity.com\/docs\/vue-images\/gridadd_boot.jpg\" alt=\"\"\/><\/a><\/figure>\n\n\n\n<ul class=\"wp-block-list\"><li>Enable users to add multiple records at one time to a database table.<\/li><\/ul>\n<\/div><\/div>\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<h4 class=\"wp-block-heading\">Grid Update Maintenance<\/h4>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"\/docs\/vue-images\/gridupd_boot.jpg\"><img decoding=\"async\" src=\"https:\/\/www.mrc-productivity.com\/docs\/vue-images\/gridupd_boot.jpg\" alt=\"\"\/><\/a><\/figure>\n\n\n\n<ul class=\"wp-block-list\"><li>Enable update and delete of multiple records at one time.<\/li><\/ul>\n<\/div><\/div>\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<h4 class=\"wp-block-heading\"> Data Upload Maintenance <\/h4>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"\/docs\/vue-images\/dataupload_boot.jpg\"><img decoding=\"async\" src=\"https:\/\/www.mrc-productivity.com\/docs\/vue-images\/dataupload_boot.jpg\" alt=\"\"\/><\/a><\/figure>\n\n\n\n<ul class=\"wp-block-list\"><li>Allows users to upload spreadsheets and external data directly into the database.<\/li><\/ul>\n<\/div><\/div>\n\n\n\n<h4 class=\"wp-block-heading\">Calendar<\/h4>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"\/docs\/vue-images\/cal_boot.jpg\"><img decoding=\"async\" src=\"https:\/\/www.mrc-productivity.com\/docs\/vue-images\/cal_boot.jpg\" alt=\"\"\/><\/a><\/figure>\n\n\n\n<ul class=\"wp-block-list\"><li>View, add, edit, or delete any date-related data in a familiar calendar format.<\/li><li>Filter records.<\/li><li>Color code entries based on any criteria.<\/li><\/ul>\n\n\n\n<hr class=\"wp-block-separator is-style-wide\"\/>\n\n\n\n<p>Click <a href=\"https:\/\/www.mrc-productivity.com\/docs\/getting-started\/more-questions\">here<\/a> to read some common m-Power questions.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>m-Power ships with over a dozen templates which gives you numerous options when deciding how an application should look and function. The first decision is what type of application to create. m-Power defines four general types: Retrievals, Reports, Summaries, and Maintenance Applications. Then, each of those application types has specific&#8230;<\/p>\n","protected":false},"author":1,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[248],"ht-kb-tag":[],"class_list":["post-149","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-build-process"],"_links":{"self":[{"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb\/149","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=149"}],"version-history":[{"count":30,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb\/149\/revisions"}],"predecessor-version":[{"id":10835,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb\/149\/revisions\/10835"}],"wp:attachment":[{"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/media?parent=149"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb-category?post=149"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb-tag?post=149"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}