30 Jan’19

D365 Business CentralHow to setup FieldGroups in Business Central

Introduction:

A field group in table or table extension objects defines the fields to display in a drop-down control on pages that use the table and fields that display when these pages are shown in the tile view. Syntax of fieldgroup is as follows:

fieldgroup(<Name>;<Field>)

<Name> : It can be either Dropdown, so as to define the set of fields to be included in drop down view or it can be Brick to define the set of fields to be included in a tile view.

<Field> : Here, all the fields to be included are specified each separated from the other one by comma.

Pre-Requisite:

  1. Microsoft Dynamics 365 Business Central

Solution:

  1. In Business Central, when using the table extension objects one or more fields can be added to the fieldgroup using the ‘fieldgroups’ control. It can be done by using the addlast keyword.Its syntax is as follows: addlast(<Name>;<Field>).
  2. In the example below, I created a table extension object in which I have added a new field. I have added that field in the fieldgroup using the syntax mentioned above.

Conclusion:

Thus, using the above syntax the fieldgroup control can be added to the table in Business Central and even the existing fieldgroup can be modified to add new fields.

Written by

Dhruv Mehta

Software Engineer

Leave a Reply

Your email address will not be published. Required fields are marked *

Want to streamline your business processes?

  • This field is for validation purposes and should be left unchanged.

Recent Articles

  • Bulk Clear field values in D365

    15 February’ 2019

    Introduction: A very handy approach for admins and users of Dynamics 365 who want to bulk clean up field values – And...

    Read more
  • Integrating SharePoint with D365 Portal

    8 February’ 2019

    Introduction: This blog explains how we can add files from D365 Portal directly into SharePoint which was long awaited ...

    Read more
  • Run OnDemand Workflow in D365 CE UCI Apps

    31 January’ 2019

    Introduction: This blog explains the steps on how to enable OnDemand Workflow in D365 CE UCI Apps. Scenario: After clien...

    Read more
  • Create Folder Strucutre in SharePoint using MS Flows

    31 January’ 2019

    Introduction: In this blog we will see how we can create folder structure in SharePoint for Leads when the record is cr...

    Read more
  • Hide table or column in Power BI

    30 January’ 2019

    Introduction: In this article we will read on how to hide a table or column in Power BI Web Service. Scenario: I have a...

    Read more