As a functional consultant, we can only add fields that are on the page from the user interface. However, if we need to add fields from the source table of the page, that aren't directly on the page itself, we'll need assistance from technical consultants. This is because the fields that are not available on the page (but available on the source table of the page) cannot be added from the user interface of BC.
We would need to publish the extension using VS Code to add these fields.
In NAV also, we used to add such fields from the Development Environment. 👎🏻 This creates a dependency for the users, functional consultants, and administrators on the technical consultants for a small task like adding a field on the page. 👎🏻 These small changes eat a lot of time for the developers that could be utilized in some actual developments and working on interesting customizations for the client or working on creating some good add-ons.
So, what is the solution to the problem stated above? 🤔 The solution is simple.
✅ Provide the option in D365 BC to add even the table fields from the user interface.
🥳 The good news is that we have got this now in D365 BC with the 2023 Wave 2 Release.
1) Add table fields Now, when you try to add fields using the personalization option, you will find a dropdown in which by default the value selected is All fields. If you scroll down to add any field or search for any field on the table, you will find it here and easily add it to the page.
The below screenshot is from the previous version and you can see this option is not available here.
If you click on the dropdown you can see two more options. So, basically, we have three options in this dropdown.
Recommended fields: These are the fields that are curated by the application developer specifically for this page, including those from extensions.
All fields: If you choose this option you get all the fields that are available on the page, table, and through extensions.
Advanced: This feature gives multiple options to filter the fields available based on Category, Source, and Visibility.
You can read the tooltip (as shown below) to understand better about these filters:
It also gives you information about the use of the field and the type and source of the field as shown below.
2) Add fields more precisely to intended locations on pages Now, if we try to add a filed by dragging it onto the page, we will geta an accompanying text with the cursor that helps to precisely drop the field where we want on the page.
3) Govern your data and extensions Administrators can choose precisely which persons are allowed to add table fields to pages using new system permission. Developers can protect sensitive table fields by excluding them from UI customization using a new AL property.
Please note: This feature is currently in preview (on 20-Sep-2023) and is subject to change. This feature isn't intended for creating new fields on tables and will still require developer support when used to add complex, existing table fields.
I will update this blog in case any further changes come.
That is all in this blog.
Hope it helps! Cheers!