{"id":256,"date":"2019-09-03T00:42:45","date_gmt":"2019-09-03T00:42:45","guid":{"rendered":"http:\/\/supportingelement.com\/?p=256"},"modified":"2019-09-03T00:50:23","modified_gmt":"2019-09-03T00:50:23","slug":"identifying-a-record-field-name-from-a-page-control","status":"publish","type":"post","link":"http:\/\/supportingelement.com\/index.php\/2019\/09\/03\/identifying-a-record-field-name-from-a-page-control\/","title":{"rendered":"Identifying a Record\/Field name from a Page control"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Sometimes it is necessary to know the Table and Field name\nassociated with a text box or control on displayed on a PeopleSoft Page.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Here\u2019s a few ways to identify the table\/field:<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u201cInspect Element\u201d<\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li> Right click the control for which you want to know the table\/field name.<\/li><li>Select \u201cInspect\u201d  <\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image image-border\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"661\" src=\"http:\/\/supportingelement.com\/wp-content\/uploads\/2019\/09\/InspectElement1-1024x661.jpg\" alt=\"\" class=\"wp-image-257\" srcset=\"http:\/\/supportingelement.com\/wp-content\/uploads\/2019\/09\/InspectElement1-1024x661.jpg 1024w, http:\/\/supportingelement.com\/wp-content\/uploads\/2019\/09\/InspectElement1-300x194.jpg 300w, http:\/\/supportingelement.com\/wp-content\/uploads\/2019\/09\/InspectElement1-768x496.jpg 768w, http:\/\/supportingelement.com\/wp-content\/uploads\/2019\/09\/InspectElement1-660x426.jpg 660w, http:\/\/supportingelement.com\/wp-content\/uploads\/2019\/09\/InspectElement1.jpg 1036w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\"><li>In the \u201cElements\u201d tab of the window that appears, details of the control are shown, including the \u201cid\u201d of the control.  The id includes the table and field named.  In this example the table is called \u201cGP_VARIABLE\u201d and the field name is \u201cDECIMAL_VALUE\u201d.<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image image-border\"><img loading=\"lazy\" decoding=\"async\" width=\"820\" height=\"604\" src=\"http:\/\/supportingelement.com\/wp-content\/uploads\/2019\/09\/InspectElement2.jpg\" alt=\"\" class=\"wp-image-265\" srcset=\"http:\/\/supportingelement.com\/wp-content\/uploads\/2019\/09\/InspectElement2.jpg 820w, http:\/\/supportingelement.com\/wp-content\/uploads\/2019\/09\/InspectElement2-300x221.jpg 300w, http:\/\/supportingelement.com\/wp-content\/uploads\/2019\/09\/InspectElement2-768x566.jpg 768w, http:\/\/supportingelement.com\/wp-content\/uploads\/2019\/09\/InspectElement2-660x486.jpg 660w\" sizes=\"auto, (max-width: 820px) 100vw, 820px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">\u201cPS Utilities\u201d Chrome Extension<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">The free \u201cPS Utilities\u201d extension for Google Chrome includes a number of features including a \u201cField Inspector\u201d.<\/p>\n\n\n\n<figure class=\"wp-block-image image-border\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"966\" src=\"http:\/\/supportingelement.com\/wp-content\/uploads\/2019\/09\/PSUtilities-Extension-1024x966.jpg\" alt=\"\" class=\"wp-image-266\" srcset=\"http:\/\/supportingelement.com\/wp-content\/uploads\/2019\/09\/PSUtilities-Extension-1024x966.jpg 1024w, http:\/\/supportingelement.com\/wp-content\/uploads\/2019\/09\/PSUtilities-Extension-300x283.jpg 300w, http:\/\/supportingelement.com\/wp-content\/uploads\/2019\/09\/PSUtilities-Extension-768x725.jpg 768w, http:\/\/supportingelement.com\/wp-content\/uploads\/2019\/09\/PSUtilities-Extension-660x623.jpg 660w, http:\/\/supportingelement.com\/wp-content\/uploads\/2019\/09\/PSUtilities-Extension.jpg 1115w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\"><li>Click on the &#8220;Field Inspector&#8221; icon in the PS Utilities menu, then select the control for which you require information:<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image image-border\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"544\" src=\"http:\/\/supportingelement.com\/wp-content\/uploads\/2019\/09\/PSUtilities-Extension2-1024x544.jpg\" alt=\"\" class=\"wp-image-267\" srcset=\"http:\/\/supportingelement.com\/wp-content\/uploads\/2019\/09\/PSUtilities-Extension2-1024x544.jpg 1024w, http:\/\/supportingelement.com\/wp-content\/uploads\/2019\/09\/PSUtilities-Extension2-300x159.jpg 300w, http:\/\/supportingelement.com\/wp-content\/uploads\/2019\/09\/PSUtilities-Extension2-768x408.jpg 768w, http:\/\/supportingelement.com\/wp-content\/uploads\/2019\/09\/PSUtilities-Extension2-660x351.jpg 660w, http:\/\/supportingelement.com\/wp-content\/uploads\/2019\/09\/PSUtilities-Extension2.jpg 1073w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">\u201cCtrl-J\u201d &amp; App Designer<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">If you have access to PeopleSoft \u201cApp Designer\u201d you can use the \u201cCtrl-J\u201d shortcut to display the name of the Page.<\/p>\n\n\n\n<figure class=\"wp-block-image image-border\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"557\" src=\"http:\/\/supportingelement.com\/wp-content\/uploads\/2019\/09\/Ctrl-J-1-1024x557.jpg\" alt=\"\" class=\"wp-image-263\" srcset=\"http:\/\/supportingelement.com\/wp-content\/uploads\/2019\/09\/Ctrl-J-1-1024x557.jpg 1024w, http:\/\/supportingelement.com\/wp-content\/uploads\/2019\/09\/Ctrl-J-1-300x163.jpg 300w, http:\/\/supportingelement.com\/wp-content\/uploads\/2019\/09\/Ctrl-J-1-768x418.jpg 768w, http:\/\/supportingelement.com\/wp-content\/uploads\/2019\/09\/Ctrl-J-1-660x359.jpg 660w, http:\/\/supportingelement.com\/wp-content\/uploads\/2019\/09\/Ctrl-J-1.jpg 1145w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">You can then open the Page in \u201cApp Designer\u201d to find details of the control.<\/p>\n\n\n\n<figure class=\"wp-block-image image-border\"><img loading=\"lazy\" decoding=\"async\" width=\"1000\" height=\"491\" src=\"http:\/\/supportingelement.com\/wp-content\/uploads\/2019\/09\/AppDesigner.jpg\" alt=\"\" class=\"wp-image-261\" srcset=\"http:\/\/supportingelement.com\/wp-content\/uploads\/2019\/09\/AppDesigner.jpg 1000w, http:\/\/supportingelement.com\/wp-content\/uploads\/2019\/09\/AppDesigner-300x147.jpg 300w, http:\/\/supportingelement.com\/wp-content\/uploads\/2019\/09\/AppDesigner-768x377.jpg 768w, http:\/\/supportingelement.com\/wp-content\/uploads\/2019\/09\/AppDesigner-660x324.jpg 660w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Sometimes it is necessary to know the Table and Field name associated with a text box or control on displayed on a PeopleSoft Page. Here\u2019s a few ways to identify the table\/field: \u201cInspect Element\u201d Right click the control for which you want to know the table\/field name. Select \u201cInspect\u201d In the \u201cElements\u201d tab of the\u2026 <span class=\"read-more\"><a href=\"http:\/\/supportingelement.com\/index.php\/2019\/09\/03\/identifying-a-record-field-name-from-a-page-control\/\">Read More &raquo;<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21],"tags":[],"class_list":["post-256","post","type-post","status-publish","format-standard","hentry","category-peoplesoft"],"_links":{"self":[{"href":"http:\/\/supportingelement.com\/index.php\/wp-json\/wp\/v2\/posts\/256","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/supportingelement.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/supportingelement.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/supportingelement.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/supportingelement.com\/index.php\/wp-json\/wp\/v2\/comments?post=256"}],"version-history":[{"count":6,"href":"http:\/\/supportingelement.com\/index.php\/wp-json\/wp\/v2\/posts\/256\/revisions"}],"predecessor-version":[{"id":276,"href":"http:\/\/supportingelement.com\/index.php\/wp-json\/wp\/v2\/posts\/256\/revisions\/276"}],"wp:attachment":[{"href":"http:\/\/supportingelement.com\/index.php\/wp-json\/wp\/v2\/media?parent=256"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/supportingelement.com\/index.php\/wp-json\/wp\/v2\/categories?post=256"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/supportingelement.com\/index.php\/wp-json\/wp\/v2\/tags?post=256"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}