{"id":1888,"date":"2008-02-29T03:45:34","date_gmt":"2008-02-29T09:45:34","guid":{"rendered":"http:\/\/www.mrc-productivity.com\/docs\/?page_id=1888"},"modified":"2026-08-13T11:59:57","modified_gmt":"2026-08-13T16:59:57","slug":"right-justified-fields-within-web-2-0-applications","status":"publish","type":"ht_kb","link":"https:\/\/www.mrc-productivity.com\/docs\/knowledge-base\/right-justified-fields-within-web-2-0-applications","title":{"rendered":"Right Justified Fields within m-Power Applications"},"content":{"rendered":"\n<h2 id=\"overview\" class=\"wp-block-heading\">Overview<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">m-Power applications natively accommodate right-justified character fields. In the past, matching two right-justified fields of different lengths (e.g., an 8-character field and a 12-character field) required building logical fields of equal length to ensure the data compared correctly.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Now, you no longer need to create logical fields to convert your data. You can easily handle right-justified fields by simply adding the <code>*RIGHTJUST<\/code> keyword to the field&#8217;s description.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This feature is fully supported across m-Power and works seamlessly with:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Table Joins<\/strong> (When joining on a right-justified field, m-Power automatically trims the fields behind the scenes to ensure an exact match).<\/li>\n\n\n\n<li><strong>Runtime Prompt Filters<\/strong> (Reports)<\/li>\n\n\n\n<li><strong>Selection Filters<\/strong> (Data Lists)<\/li>\n\n\n\n<li><strong>Writing Values<\/strong> (Maintainers)<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">How to Apply<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Method 1: Data Dictionary Level <\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Whenever possible, we recommend specifying right justification at the Data Dictionary level. By adding <code>*RIGHTJUST<\/code> to the field description in <strong>Admin &gt; Manage Tables<\/strong>, m-Power will automatically apply this logic to any new application built over that table, saving you from having to remember to configure it on a per-application basis.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Method 2: Application Level<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">If you only need to apply this logic to a specific application, you can do so directly in the app&#8217;s Data Model:<\/p>\n\n\n\n<ol start=\"1\" class=\"wp-block-list\">\n<li>Open your application&#8217;s <strong>Data Model<\/strong>.<\/li>\n\n\n\n<li>Click on <strong>Field Settings<\/strong>.<\/li>\n\n\n\n<li>Select the field in question.<\/li>\n\n\n\n<li>Add <code>*RIGHTJUST<\/code> anywhere in the <strong>Field Description<\/strong>.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"\/docs\/vue-images\/rightjustify1.jpg\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Once applied, simply <strong>Rebuild<\/strong> your application (no HTML overwrite is required).<\/p>\n\n\n\n<p class=\"wp-block-ht-blocks-messages wp-block-hb-message wp-block-hb-message--withicon is-style-info\">At runtime, the *RIGHTJUST will not be included within the skeleton of your HTML.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Right-Justified Fields in Joined Tables<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">When joining tables together, you may occasionally run into a scenario where the right-justified field lives in the <strong>secondary<\/strong> table, rather than your primary table.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Because m-Power streamlines how joined fields are handled, the secondary table&#8217;s field is treated as the same field from the primary table, meaning the secondary field aren&#8217;t directly editable in the Field Setting screen.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">To handle this scenario, m-Power includes a dedicated keyword: <code>*JOINRIGHTJUST<\/code>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Simply add <code>*JOINRIGHTJUST<\/code> to the field description of the <strong>primary table<\/strong> (the left side of the join). m-Power will automatically detect this and apply the necessary trimming logic to the join behind the scenes, ensuring your tables link perfectly. <\/p>\n","protected":false},"excerpt":{"rendered":"<p>Overview m-Power applications natively accommodate right-justified character fields. In the past, matching two right-justified fields of different lengths (e.g., an 8-character field and a 12-character field) required building logical fields of equal length to ensure the data compared correctly. Now, you no longer need to create logical fields to convert&#8230;<\/p>\n","protected":false},"author":1,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[266],"ht-kb-tag":[],"class_list":["post-1888","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-general"],"_links":{"self":[{"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb\/1888","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=1888"}],"version-history":[{"count":14,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb\/1888\/revisions"}],"predecessor-version":[{"id":15274,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb\/1888\/revisions\/15274"}],"wp:attachment":[{"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/media?parent=1888"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb-category?post=1888"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb-tag?post=1888"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}