Modify field displayed value

(0) Share

Report

Posted on by AntonisK

260

Greetings to all you.

I need to deal with the case below.

I have created a custom field on the item card as you can see below.

Is there any way , to customize this field so that , the displayed value inside the field would be the value of the Column Name and not of the Column No of the table?

For example ,if i select the code 6 , atm , my custom field will display the value 6 , however i would like to display the value test instead on the item card.

Is it possible to do so? If yes, i would also need some help when it comes to the needed commands..

Thank you in advance for your time.

With respect,
Antonis

I have the same question (0)

All responses (3)

Answers (1)

Suggested answer

Andy Sather on at

Like (0)

Report

Hello - We currently do not have dedicated Dev support via the Dynamics 365 Business Central forums, but I wanted to provide you some additional resources to assist. If you need assistance with debugging or coding I would recommend discussing this on one of our communities.

www.yammer.com/dynamicsnavdev

dynamicsuser.net/.../developers

I will open this up to the community in case they have something to add.

Was this reply helpful? Yes No
Verified answer

YUN ZHU 95,329 Super User 2025 Season 2 on at

Like (1)

Report
Hi, This is done in two main ways.

1. Using TableRelation property: Add code and name fields, when code is filled in, the Name field is automatically written.

tableextension 80111 MyExtension extends Item { fields { field(50101; MainCustomerNo; Code[20]) { Caption = 'Main Customer No.'; TableRelation = Customer."No."; DataClassification = CustomerContent; trigger OnValidate() var Cust: Record Customer; begin if Cust.Get(MainCustomerNo) then MainCustomerName := Cust.Name; end; } field(50102; MainCustomerName; Text[100]) { Caption = 'Main Customer No.'; DataClassification = CustomerContent; Editable = false; } } } pageextension 80111 MyExtension extends "Item Card" { layout { addafter(Description) { field(MainCustomerNo; Rec.MainCustomerNo) { ApplicationArea = All; } field(MainCustomerName; Rec.MainCustomerName) { ApplicationArea = All; } } } }

2. Using Onlookup trigger

tableextension 80111 MyExtension extends Item { fields { field(50102; MainCustomerName; Text[100]) { Caption = 'Main Customer No.'; DataClassification = CustomerContent; trigger OnLookup() var Cust: Record Customer; begin Cust.Reset(); if Page.RunModal(Page::"Customer List", Cust) = Action::LookupOK then MainCustomerName := Cust.Name; end; } } } pageextension 80111 MyExtension extends "Item Card" { layout { addafter(Description) { field(MainCustomerName; Rec.MainCustomerName) { ApplicationArea = All; } } } }

Hope this will help.

Thanks.

ZHU

1 people found this reply helpful.

Was this reply helpful? Yes No
AntonisK 260 on at

Like (0)

Report

yzhums

Thank you so much sir.

It worked just as i wanted to do so.

Appreciated!

Was this reply helpful? Yes No