{"id":5662,"date":"2013-07-18T10:47:40","date_gmt":"2013-07-18T15:47:40","guid":{"rendered":"http:\/\/www.mrc-productivity.com\/docs\/?page_id=5662"},"modified":"2023-08-03T14:49:54","modified_gmt":"2023-08-03T19:49:54","slug":"field-settings","status":"publish","type":"ht_kb","link":"https:\/\/www.mrc-productivity.com\/docs\/knowledge-base\/field-settings","title":{"rendered":"Field Settings"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">Overview<\/h2>\n\n\n\n<p>Once data has been selected within the Tables\/Fields specification within the application&#8217;s Data Model, a developer may use the Field Settings screen, to (among other things) you can delete, reorder, and edit the appearance of fields you have selected for your application.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"https:\/\/www.mrc-productivity.com\/docs\/vue-images\/field_settings1.png\"><img decoding=\"async\" src=\"https:\/\/www.mrc-productivity.com\/docs\/vue-images\/field_settings1.png\" alt=\"field_settings\"\/><\/a><figcaption class=\"wp-element-caption\">Figure 1: The Edit Field Settings screen<\/figcaption><\/figure>\n\n\n\n<p>Using Figure 1 for reference, the Field Settings screen will present different field options depending on what the dropdown above the grid is set to, here:<\/p>\n\n\n\n<p><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Deleting a Field<\/h3>\n\n\n\n<p>To delete a field from your application, click the &#8220;X&#8221; referring the field you want to delete. Notice that in the screenshot the Customer Number field cannot be deleted. This is because the field is a dimension key. Any field that is linked to a dimension, external object, calculation, SmartLink, or filter cannot be deleted. You must remove these dependencies before the field can be deleted.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Re-Ordering a Field<\/h3>\n\n\n\n<p>Initially, fields will be listed in the order they were added. To reorder fields, click on the reorder icon and drag the field to the desired location. Field order is listed from top-to-bottom. The field at the top will appear first in the finished application, and the field at the bottom will appear last.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Basic Field Attributes<\/h2>\n\n\n\n<p>While you cannot use Field Settings to change values or fields in the database, you can change their appearances in the application. Therefore, note that editing in field settings is not global, rather only application specific.<\/p>\n\n\n\n<h5 class=\"wp-block-heading\">Field Description<\/h5>\n\n\n\n<p>This appears in the final application, and inherits its value from its global definition at the dictionary level. Set an appropriate description so that the end-users can understand the field.<\/p>\n\n\n\n<h5 class=\"wp-block-heading\">Display<\/h5>\n\n\n\n<p>Set &#8220;Display&#8221; if you want the field to appear in the application. Setting &#8220;Hide&#8221; will allow your application to use the field as necessary (such as in calculations), but not display the field to the end-user.<\/p>\n\n\n\n<h5 class=\"wp-block-heading\">Length<\/h5>\n\n\n\n<p>Set the length of the field. The length includes the decimal places, such that 25.325 has a length of 5.<\/p>\n\n\n\n<h5 class=\"wp-block-heading\">Decimals<\/h5>\n\n\n\n<p>For numeric fields, set the desired amount of decimal places. A blank in this column indicated your field is non-numeric (character\/date\/time, etc.).<\/p>\n\n\n\n<h5 class=\"wp-block-heading\">Format<\/h5>\n\n\n\n<p>Select the format used to display your date or numeric data. For information on creating your own date or time format, click <a href=\"https:\/\/www.mrc-productivity.com\/docs\/general\/datetime-formatting\">here<\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Filter and Sorting Attributes<\/h2>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"https:\/\/www.mrc-productivity.com\/docs\/vue-images\/field_settings2.png\"><img decoding=\"async\" src=\"https:\/\/www.mrc-productivity.com\/docs\/vue-images\/field_settings2.png\" alt=\"field_settings2\"\/><\/a><\/figure>\n\n\n\n<h5 class=\"wp-block-heading\">Hide Filter<\/h5>\n\n\n\n<p>Check this box to remove the ability to filter over this field during runtime selections.<\/p>\n\n\n\n<h5 class=\"wp-block-heading\">Hide Sort<\/h5>\n\n\n\n<p>Check this box to remove the ability to sort over this field at runtime.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Form Input Attributes<\/h2>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"https:\/\/www.mrc-productivity.com\/docs\/vue-images\/field_settings3.png\"><img decoding=\"async\" src=\"https:\/\/www.mrc-productivity.com\/docs\/vue-images\/field_settings3.png\" alt=\"field_settings3\"\/><\/a><\/figure>\n\n\n\n<h5 class=\"wp-block-heading\">Option List<\/h5>\n\n\n\n<p>Choose an external <a href=\"https:\/\/www.mrc-productivity.com\/docs\/retrievals\/option-list-template\">Option List Retrieval<\/a> to have the dataset automatically added to your selections input for this field.<\/p>\n\n\n\n<h5 class=\"wp-block-heading\">List Type<\/h5>\n\n\n\n<p>Choose Dropdown List or Radio Button to be added to your selections input for this field.<\/p>\n\n\n\n<h5 class=\"wp-block-heading\">User Def<\/h5>\n\n\n\n<p>\u00a0If you would like a user to be able to <a href=\"https:\/\/www.mrc-productivity.com\/docs\/knowledge-base\/upload-files-to-server-via-web-2-0-maintenance-applications\" target=\"_blank\" rel=\"noreferrer noopener\">upload a file to the server<\/a>, select the letter &#8216;U&#8217; from the dropdown. The remaining options have been deprecated.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Form Validation and Auditing<\/h2>\n\n\n\n<h5 class=\"wp-block-heading\">Allow Blank?<\/h5>\n\n\n\n<p>Unchecking this option will make the field required before allowing the user to submit the form. This is checked by default.<\/p>\n\n\n\n<h5 class=\"wp-block-heading\">Validity Relation<\/h5>\n\n\n\n<p>This setting, combined with the <strong>Validity Value<\/strong> setting will allow you to restrict what information may be entered into your maintenance application. Valid relationships are:<\/p>\n\n\n\n<p><strong>EQ <\/strong>Equal to<br><strong>GE <\/strong>Greater than or equal to<br><strong>GT <\/strong>Greater than<br><strong>LE <\/strong>Less than or equal to<br><strong>LS <\/strong>Is in the list<br><strong>NS <\/strong>Not in the list<br><strong>LT <\/strong>Less than<br><strong>NE <\/strong>Not equal to<br><strong>NG <\/strong>Not greater than<br><strong>NL <\/strong>Not less than<br><strong>RG <\/strong>Is in the range<br><strong>RB <\/strong>Radio Button<br><strong>CB<\/strong> Checkbox<\/p>\n\n\n\n<p>If using <strong>Is in the list<\/strong>, a dropdown will be automatically generated during the compile process with the values specified in the <strong>Validity Value<\/strong> setting.<\/p>\n\n\n\n<p>If using <strong>Radio Buttons<\/strong>, radio buttons will be automatically generated during the compile process with the values specified in the <strong>Validity Value<\/strong> setting.<\/p>\n\n\n\n<p>If using the <strong>Checkbox<\/strong> option, a checkbox will be automatically generated during the compile process with the value specified  in the <strong>Validity Value<\/strong> setting. <\/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> Only the value specified in the Validity Value setting will be written if the box is checked by the end user. If the box is left unchecked, nothing will be written to the database.<\/p>\n\n\n\n<h5 class=\"wp-block-heading\">Validity Value<\/h5>\n\n\n\n<p>This is the value that you want to compare the field value entered to in order to restrict the user from proceeding. <\/p>\n\n\n\n<h5 class=\"wp-block-heading\">Default for Add<\/h5>\n\n\n\n<p>Text entered here will be entered into the field initially when a new record is being added. Users may change it to whatever they wish, however this is what they see first. <\/p>\n\n\n\n<h5 class=\"wp-block-heading\">Audit<\/h5>\n\n\n\n<p>This setting allows you to automatically map user metadata (user, date, time, etc.) to a field in the maintainer for auditting purposes.<\/p>\n\n\n\n<p>You can find out more in detail about these options\u00a0<a href=\"https:\/\/www.mrc-productivity.com\/docs\/knowledge-base\/adding-the-current-date-time-and-user-for-auditing-purposes\" target=\"_blank\" rel=\"noreferrer noopener\">here<\/a>.<\/p>\n\n\n\n<h5 class=\"wp-block-heading\">Allow Lowercase?<\/h5>\n\n\n\n<p>This option determines whether or not an alpha field can be submitted to the database with lowercase letters. If this is unchecked the field will be converted to uppercase when it is submitted.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Overview Once data has been selected within the Tables\/Fields specification within the application&#8217;s Data Model, a developer may use the Field Settings screen, to (among other things) you can delete, reorder, and edit the appearance of fields you have selected for your application. Using Figure 1 for reference, the Field&#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-5662","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\/5662","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=5662"}],"version-history":[{"count":19,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb\/5662\/revisions"}],"predecessor-version":[{"id":13115,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb\/5662\/revisions\/13115"}],"wp:attachment":[{"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/media?parent=5662"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb-category?post=5662"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb-tag?post=5662"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}