A function I have often been asked for, but which does not exist in standard Dynamics AX 2012 is copy-down, or the ability to press a key on the keyboard to copy values into the currently selected field from the row immediately above it. \u00a0In my implementation, I have chosen the F11 key, as it was not used for anything else.<\/p>\n
The function will be available on all grid-based forms, even in the table browser.<\/p>\n
To implement this, modify the SysSetupFormRun class to add a new methods called EB_copyDown. \u00a0(As usual, the prefix is up to you and the naming conventions you follow)<\/p>\n
\/\/ EB 11\/03\/2016: Enable copy-down on F11 key<\/span><\/em>\nprivate<\/strong> void<\/strong><\/span> EB_copyDown( FormDataSource _fds, FieldId _fieldId )\n{\n Common prevRecord = _fds.cursor( _fds.getPosition() - 1<\/span><\/strong> );\n Common common = _fds.cursor();\n\n common.( _fieldId ) = prevRecord.( _fieldId );\n}<\/pre>\nThis sets prevRecord to the record immediately above\u00a0the current record, by subtracting one from the value returned by getPosition(), and\u00a0sets common to the current record. \u00a0Next, it just copies the requested field from one record to the other. \u00a0(This is an example of late-binding fields, or dynamic binding.)<\/p>\n
In order for this to work, I’ll need to modify the task() method as well.
\nI start by adding a number of local variables I’ll need.<\/p>\n
\/\/ EB 11\/03\/2016: Enable copy-down on F11 key ==><\/em><\/span>\n FieldBinding binding;\n FormDataSource fds;\n FormControl ctrl;\n FieldId fieldId;\n container<\/span> <\/strong>dependentFields;\n int<\/span> <\/strong>i;\n Object fds_Object;\n FormDataObject o;\n \/\/ EB 11\/03\/2016: Enable copy-down on F11 key <==<\/em><\/span><\/pre>\nThen we add an else-if branch to the if-statement.<\/p>\n
\/\/ EB 11\/03\/2016: Enable copy-down on F11 key ==><\/em><\/span>\nelse if<\/span><\/strong>( _p1 == 357<\/strong> <\/span>) \/\/ F11<\/em><\/span>\n{\n ctrl = this.selectedControl();\n if<\/span><\/strong>( ( ctrl != null<\/span> <\/strong>) && ctrl.enabled() && ctrl.allowEdit() )\n {\n binding = ctrl.fieldBinding();\n fieldId = binding.fieldId();\n fds = ctrl.dataSourceObject();\n\n if<\/span><\/strong>( fds.getPosition() > 1<\/span><\/strong> )\n {\n this.lock();\n o = fds.object( fieldId );\n if<\/strong><\/span>( o.allowEdit() )\n {\n fds_Object = fds as<\/span> <\/strong>Object;\n this.EB_copyDown( fds, fieldId );\n if<\/strong><\/span>( formDataSourceHasMethod( fds, identifierStr<\/span><\/strong>( EB_dependentFields ) ) )\n {\n dependentFields = fds_Object.EB_dependentFields( fieldId );\n }\n for<\/strong><\/span>( i = 1<\/span><\/strong>; i <= conlen<\/strong><\/span>( dependentFields ); i++ )\n {\n this.EB_copyDown( fds, conPeek<\/strong><\/span>( dependentFields, i ) );\n }\n\n o.modified();\n for<\/strong><\/span>( i = 1<\/strong><\/span>; i <= conlen<\/strong><\/span>( dependentFields ); i++ )\n {\n o = fds.object( fieldId );\n o.modified();\n }\n }\n this.unLock();\n fds.refresh();\n }\n else<\/strong><\/span>\n {\n warning( \"Not copying down. You had to try, didn't you?\"<\/span> );\n }\n }\n}\n\/\/ EB 11\/03\/2016: Enable copy-down on F11 key <==<\/em><\/span><\/pre>\nI’m checking to make sure that the user is not on the first row in the grid. \u00a0If he\/she is, I show a suitable message. \u00a0Of course, sensibilities and political correctness may mandate that you don’t show what I did. \u00a0I will not be held responsible for any consequences if you do…<\/p>\n
Some fields will depend on others. \u00a0An example may be a subcategory, which depends on a major category. \u00a0When copying the subcategory, it would be useful to also copy the major category, so\u00a0I have added support for also copying such dependent fields. \u00a0To do this, add a form-level method to the relevant form(s). \u00a0The method should be called EB_dependentFields and take a fieldId as single parameter. \u00a0It will return a container filled with the fieldIds of all other fields that also need to be copied. \u00a0You can change the name of the method to suit whatever naming convention you follow, just make sure that the method is public and follows the API described here. \u00a0Also, make sure the code above is updated to match the method name you choose.<\/p>\n
As usual, an XPO containing these changes are available here:\u00a0Class_SysSetupFormRun (2).zip<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"A function I have often been asked for, but which does not exist in standard Dynamics AX 2012 is copy-down, or the ability to press a key on the keyboard to copy values into the currently selected field from the row immediately above it. \u00a0In my implementation, I have chosen the F11 key, as it … Continue reading “Another form trick, copy-down in grids”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4,1],"tags":[2,3,5],"class_list":["post-33","post","type-post","status-publish","format-standard","hentry","category-dynamics-ax","category-uncategorized","tag-ax2012r3","tag-dynamics-ax","tag-user-interface"],"_links":{"self":[{"href":"https:\/\/www.bakke.online\/index.php\/wp-json\/wp\/v2\/posts\/33","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bakke.online\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bakke.online\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bakke.online\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bakke.online\/index.php\/wp-json\/wp\/v2\/comments?post=33"}],"version-history":[{"count":0,"href":"https:\/\/www.bakke.online\/index.php\/wp-json\/wp\/v2\/posts\/33\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.bakke.online\/index.php\/wp-json\/wp\/v2\/media?parent=33"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bakke.online\/index.php\/wp-json\/wp\/v2\/categories?post=33"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bakke.online\/index.php\/wp-json\/wp\/v2\/tags?post=33"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}