Notifications
Announcements
No record found.
how can we concatenate between two field i.e debit id & item id
For example:
Debit id: 01
Item id: 99
I want to generate both these two field in one column. like 0199
*This post is locked for comments
Concatenate where? If you want to do this on a form, you could add new field and a display method that would do it. If the field is on a grid, adding display method fields can have a negative impact on performance.
Or, if you need to have it in a physical field in a table, you could modify that table's insert and update methods and add/update the value in there. If your table doesn't already have insert/update method overwritten, this could have a negative impact on performance.
i want to display it on excel column using Ax2012.
So you would need to have it as a field on a form.
You can add a display field or a physical field, Excel won't care about that. You can find instructions from here: community.dynamics.com/.../how-to-add-new-fields-methods-in-listpage-from-in-ax-2012
Or you can just concatenate those two fields in Excel.
Hi,
If both are strings, then you can concantenate them with a plus sign
xlsWorkSheet.cells().item(row,2).value(debitId + ItemId); // If ItemId and debitId are strings
(or)
xlsWorkSheet.cells().item(row,2).value(int2str(debitId) + int2str(ItemId)); // If they are integers
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 4 Most Valuable Professional
Priya_K 4
MyDynamicsNAV 2
