Skip to main content

Field Group in business central


How to setup field group in business central?

We can display a dropdown control on a page with the help of field group in the business central. This is the same thing that we are practicing in navision but the only difference is the style of defining field group. We can define field group in the table or table extension. In table object, first we will define field groups control then we have to enter one more control called fieldgroup(<Name>;Field) in the business central.

  • We can use DropDown or Brick as Name to display data tile.
  • Field is a comma separated list of fields.
Important Points that can be taken care while using field group
  • A field group can also be used to specify fields that display when list pages are shown in the tile view.
  • The  fieldgroups  keyword cannot be taken before the  key  control.
  • The syntax for using a DropDown, must be same DropDown  with the right keyword.

Here to give an example of field group, I have taken one table and there I have added field group with DropDown in business central.

I have added this table into one report where I use request page and there I am filtering data where I need dropdown list.

Microsoft Document Link for field group. (Click Here!)


Popular posts from this blog

Custom API in Business Central

Today, I will demonstrate how to work with custom API in Business Central. Custom API is very useful when we are working with integration apps. So, lets start exploring custom API in business central. We will take one table called student and will create one API page in order to access this table as API. Moreover, we can check this API in Postman as well. Here, we will mainly perform three operations GET, Post, and Delete. First of all, we will create student Table with four fields ID, First Name, Last Name and Email. For the primary key we will take ID. Once table is added, we will create one list page to view our data. So, we can easily check our custom API is working properly or not. Now, we will add another page which is used as API. This is a new page type introduced in business central. You can check how to create API page in business central.( Click Here ) Now, we can interact with student  data with the help of this API page in the business central. We will write a logic i

Import Excel File in Business Central

Import Excel in Business Central Many times we need to import data through excel file in the business central / navision. We used to perform this kind of activity in the navision but we need to explore the thing in business central. So, i am trying to import data from excel file in the business central. I am using business central wave 1 2020 for the development. We will create a table called student and add some fields to test imported data from Excel in Business Central. Now, We will add a new list page to view imported data from excel. Now, We will create a new report to import data from the excel in business central. If you worked with the navision then you might be noticed that some of the functions are not working in the business central due to scope issue. So, we will replace those functions which we used in NAV and try some new available functions to import excel. Now, we will add an action to the list page for import data

Export Excel in Business Central Using Excel Buffer - Harshil Patel

Export Excel in Business Central Using Excel Buffer Hello, Today we will export data using excel buffer in the business central. If you haven't check my previous blog then check out import excel in business central ( Click Here! ). Now we will create a report to export data using excel buffer in business central. Now, we will add this report to the action of the list page. OUTPUT Go to the student list page and click on the action to export data. Now, you can see the exported data in the excel file. You can download source code from GitHub ( ClickHere ). Regards, Harshil Patel