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

How to get count of table record in business central

(1) Share

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.

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

YUN ZHU 99,805 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Nilam Bhor 153 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 99,805 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No