Discuss

Show Total Number of Records from a Query

On this page

We created a page, which returns records from a database query. We want to show the total number of records in a paragraph below the table:

Screenshot_37|690x392

Double click inside the paragraph, to activate the edit mode. Then click the dynamic data icon:

Screenshot_38|690x392

In the data picker, select your database query(1) and click the data formatter icon(2):

Screenshot_39|690x392

Right click the expression and then select the count formatting option, in the collections category:

Screenshot_40|690x392

Click Select:

Screenshot_41|690x392

And click Select to insert the formatted value on the page:

Screenshot_42|690x392

Then save:

Screenshot_43|690x392

And you are done, the total number of records is displayed on the page:

Screenshot_44|690x392


WapplerPrevious|101x31   WapplerNext|77x31