News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... finding the id of a fi...

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

Suggested answer

finding the id of a field using the field name only by using the recref and fieldref

(1) Share

Report

Report

Posted on by Community member

I want to find the field id using its name (only thing that I know about it). How do I do that using the recref and fieldref

Categories:

Dynamics 365 Business Central

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

YUN ZHU 81,360 Super User 2025 Season 1 on at

Like (0)

Report

finding the id of a field using the field name only by using the recref and fieldref

Hi, hope the following can give you some hints.

How to get the id, type, length and value of a field by its text name (field name)
https://yzhums.com/40436/

Thanks.

ZHU
Suggested answer

Govinda Kumar 2,211 Moderator on at

Like (0)

Report
finding the id of a field using the field name only by using the recref and fieldref

In an alternate approach, you can utilize the Field table to find the Field ID by setting a range on the Field Name... here's the example code..
var Fieldlist: Record Field; begin Fieldlist.SetFilter(FieldName, 'YourFieldName'); if (Fieldlist.FindSet()) then Message('Field No. is %1', Fieldlist."No.") end;

Additionally, you can specify the table name before the Field Name filter..

Regards!

Helpful resources

News and Announcements

🌸 Community Spring Festival 2025 Challenge & Updates🌸

Quick Links

Leaderboard

#1

André Arnaud de Cal... 294,095 Super User 2025 Season 1

#2

Martin Dráb 232,866 Most Valuable Professional

#3

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans