web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Community site session details

Community site session details

Session Id :
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) ShareShare
ReportReport
Posted on by
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
I have the same question (0)
  • Suggested answer
    Govinda Kumar Profile Picture
    2,304 Moderator on at
    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!
  • Suggested answer
    YUN ZHU Profile Picture
    97,433 Super User 2026 Season 1 on at
    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)



     
    Thanks.
    ZHU

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.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,029 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,044 Super User 2026 Season 1

#3
Dhiren Nagar Profile Picture

Dhiren Nagar 1,026 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans