Business Central-Understanding FlowFields
Overview FlowFields are the fields which are used only to display the result of a calculation based on the “calcFormula” property. They are not the physical fields, as they do not store any value in the database. Interestingly, the values in the flowFields exists only at runtime. By default, the flowfields are initialized to 0. There are seven (7) types of flowFields, namely, sum, average, exist, count, min, max and lookup. We define a flowField by defining the fieldClass property as FlowField and giving the calcFormula property as per our requirement. Below, we have defined a flowField, “Name”, which is used to display the name of the customer. Here we have created the flowField of type “lookup”.
When the FlowField is the direct source of expression of a control on page, then FlowField is updated automatically based on calcFormula property when the page is displayed. Now, if a flowfield is initialized to 0, how do we update the value of that flowfield? The answer to this question is using CalcFields Method. Let us learn about the calcFields method.
When the FlowField is the direct source of expression of a control on page, then FlowField is updated automatically based on calcFormula property when the page is displayed. Now, if a flowfield is initialized to 0, how do we update the value of that flowfield? The answer to this question is using CalcFields Method. Let us learn about the calcFields method. - Go to Item List page in Business central.
- Select New from the Action.
CalcFields This method is used to update the value of a flowfield. As we know that FlowFields have calcFormula property. CalcFields use the current filters and perform the calculations defined in the calcFormula property and updates the value of the flowField. Let us make use of this calcFields in our code,
OUTPUT: –
-
- We will define a procedure which shows us balance (flowField) of a customer.
- Firstly, we will use Record. Get () method to retrieve the record from customer table, based on the primary key field.
- Now the balance is a flowField, If we don’t update it (without using calcFields) then it will show the balance as
OUTPUT: –
-
-
- So, we will use the calcFields method for updating the value of this flowField.
- Now Balance has some value to display, based on calcFormula.
- We will now use message () to display the Balance.
-
For more details kindly visit our LinkedIn page:
https://www.linkedin.com/company/allgrow-technologies-pvt-ltd/mycompany/
or you can write us on contact@allgrowtech.com
DO YOU WANT TO TURN YOUR IDEA INTO REALITY
Services we offer
Software and Web Development
Consulting Services
Development
Frontend
Backend
DevOps
SAAS
Locate us at
Karnataka
My Office Space, No 22/B, 2nd Floor,
BM Habitat Mall, Gokulam Main Road,
Jalakashmipuram, Mysore-570012,
Karnataka, India.
Uttar Pradesh
4th Floor, Bhavya Corporate Tower,
Vibhuti Khand, Gomti Nagar, Lucknow,
Uttar Pradesh 226010
Get in Touch
For Business – contact@allgrowtech.com
For Career – hr@allgrowtech.com
© 2026 ALLGROW TECHNOLOGIES. ALL RIGHTS RESERVED.
Manage Consent
To provide the best experiences, we use technologies like cookies to store and/or access device information. Consenting to these technologies will allow us to process data such as browsing behavior or unique IDs on this site. Not consenting or withdrawing consent, may adversely affect certain features and functions.
Functional Always active
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
The technical storage or access that is used exclusively for statistical purposes.
The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.
