count rows from a table

[pedramezzati]

hi
is there an a way to count how many rows in a table, and display it in a text
also to count rows that have a specific data

in my case, i made an IT Inventory and i want to show the number of Items in the inventory (total rows in Assets Table)
and want to show number of Computers in Inventory (rows with Desktop in the Category field in Assets Table)

im using budibase internal database

thanks

[mikesealey]

Hey @pedramezzati

This is fairly straightforward - simply add a Data Provider (unless you already have one). In my case I'm also adding a text component.

Then in the Text component's bindings drawer, click on the Data Provider

You'll see a handful of bindings available with information about the Data Provider. Hovering over them will give you a quick preview.

You can also use the Preview button to see how it will look (especially useful if you're doing something more complicated.

[pedramezzati]

thanks alot

worked like a charm