Dynamics 365 CommunityForums Business Central forum Combining the values o...

Business Central forum

Answered

Combining the values of 2 fields into one new column

(0) Share

Report

Report

Posted on by Divan

43

Hi Guys,

I have made a new table extension and added a new field Ship to External No:

        field(50003; TBLSHP_ExternalNo; Text[30])
        {
            Caption = 'Ship-to External No.';
        }

However what i want to do now is to get the value of 2 existing fields and combine them as the value of the new table.

For example the current values of the fields are:

Thus the value of the new field "Ship To External No" must reflect "01121212-002"

How can one achieve this?

Thanks

Categories:

All responses Img

All responses (2)

Answers Img

Answers (1)

Suggested answer

AM-07051506-0 on at

Like (0)

Report

Combining the values of 2 fields into one new column

Or you can make the source a function (which always returns the combination of the two fields)

field(50003; TBLSHP_ExternalNo; GetCustNoAndCode())

{

Caption = 'Ship-to External No.';

}

local procedure GetCustNoAndCode(): Text

begin

exit(format(Rec."Customer No" + Rec.Code));

end;
Verified answer

Nitin Verma 20,989 Super User on at

Like (0)

Report

RE: Combining the values of 2 fields into one new column

Hi,

You should call those events for your table in the codeunit or you can write the below code On OnInsert trigger and OnModify Trigger as well.

[EventSubscriber(ObjectType::Table, database::"YourTable", 'OnAfterInsertEvent', '', true, true)]

local procedure OnAfterInsertEvent_YourTable(var Rec: Record "YourTable")

begin

if (rec."Customer No." <> '') and (rec.code <> '') then

rec."External Document No." := rec."Customer No." + ' ' + rec.Code;

end;

[EventSubscriber(ObjectType::Table, database::"YourTable", 'OnAfterModifyEvent', '', true, true)]

local procedure OnAfterModifyEvent_YourTable(var Rec: Record "YourTable")

begin

if (rec."Customer No." <> '') and (rec.code <> '') then

rec."External Document No." := rec."Customer No." + ' ' + rec.Code;

end;

Helpful resources

Quick Links

Leaderboard

Andre Arnaud de Cal... 283,375 Super User

Martin Dráb 223,308 Super User

nmaenpaa 101,140

Featured topics

Product updates

Dynamics 365 release plans