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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / To add fields on the f...
Small and medium business | Business Central, N...
Suggested Answer

To add fields on the form from different tables

(0) ShareShare
ReportReport
Posted on by tanya07 1,638

What possibly be the best way to add fields from another tables on a form? 1. Flowfield? 2. Or declaring a variable and assigning the value by writing code on onaftergetrecord () trigger via GET function? Does flowfield affects the database performance?

*Need to just display the information*

I have the same question (0)
  • Lars Lohndorf-Larsen Profile Picture
    Lars Lohndorf-Larsen on at

    Hi Tanya,

    You can do both. It depends on the exact scenario. The two methods you mention are both very sensible. Flowfield is maybe easier while GET takes more code, but gives you more freedom. If it is a List form/page, then be careful adding Flowfields to it, as it may indeed affect performance. On the other hand, so would GET. And with Flowfields, depending on the version, some work has been done to optimize calculating flowfields on pages.

    So in short I think there is no black and white here in my opinion but if it is on a list page then just make sure that the flowfield / GET is as optimized as possible.

  • Suggested answer
    JAngle Profile Picture
    JAngle 133 on at

    As Lars has said no defined answer. Extra remarks to help or hinder.

    If the users need to sort or filter with the field then it existing on the table is important. If they don't then you have another option. On the page you can create a calculated field using a supporting codeunit. It is for sure more code but you can define lookup or drill down aspects. Same as a flowfield but the data only exists at page runtime.

    If you have the base app to look at, check out a fact box page. It uses that concept and the application is littered with fact boxes.

  • tanya07 Profile Picture
    tanya07 1,638 on at

    Thankyou for your kind suggestions , it helped.

  • SnowWizard Profile Picture
    SnowWizard 5 on at

    If the users need to sort or filter MyGroundBiz with the field then it existing on the table is important. If they don't then you have another option. On the page you can create a calculated field using a supporting codeunit. It is for sure more code but you can define lookup or drill down aspects. Same as a flowfield but the data only exists at page runtime.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,468

#2
YUN ZHU Profile Picture

YUN ZHU 923 Super User 2025 Season 2

#3
Sumit Singh Profile Picture

Sumit Singh 607

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans