News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... How to get count of ta...

Small and medium business | Business Central, N...

Suggested answer

How to get count of table record in business central

(1) Share

Report

Report

Posted on by Nilam Bhor

153

Hi Guys,

I want For example: Below is my Usage statistics config page. On that page there is one action i.e show count. when I clicked on that action, it will show the count of selected record.

For example : Here I selected customer, so when we click on action it will show the customer record. i.e., 6 because i have 6 customers as shown image 2

Is any way to do this.

All responses Img

All responses (3)

Answers Img

Answers (0)

Suggested answer

YUN ZHU 73,647 Super User 2024 Season 2 on at

Like (0)

Report

How to get count of table record in business central

Hi, you can add a field or variable, and assign this value when inserting a record, or when modifying it.

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-insert-modify-modifyall-delete-and-deleteall-methods

Hope this helps.

Thanks.

ZHU
Nilam Bhor 153 on at

Like (0)

Report

How to get count of table record in business central

I got my count. but instead of message out, I want to display this count on my record count field.

Is any way to do this.
Suggested answer

YUN ZHU 73,647 Super User 2024 Season 2 on at

Like (0)

Report

How to get count of table record in business central

Hi, Looks like there are only five customers. . . . It doesn't matter.
You can simply use the count method. Below is a simple example.

Hope this helps.

Thanks.

ZHU

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2

Martin Dráb 230,198 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans