News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Combining the values o...

Small and medium business | Business Central, N...

Answered

Combining the values of 2 fields into one new column

(0) Share

Report

Report

Posted on by Divan

53

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:

Business Central

Business Central

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 21,091 Super User 2024 Season 1 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

#1

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2

Martin Dráb 230,235 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans