Is there a way to display number of rows/records?

I would like to display the following in my application builder

“There are currently [Number of rows here] records in the database!”

Therefore, I was wondering if there was a way to count the number of rows and display the number.

1 Like

Unfortunately, I don’t think this is currently possible as we do not yet have any aggregate functions (or formulas) within the element options.

Lokaar, if I understand correctly what you are trying to to, this should be possible by creating a link from all records in your table to another table. In the second table, you can then add a rollup to the number of records.

For example, I have a table ‘Smoking Journal’, which list all my smoking sessions, that I link to record in the table ‘People’. There you can rollup the number of records. In my case, there’s more than one record, that allow me to filter to records that only apply to me. In your case, you would only need a single record.

This field can be used in application builder.

See what I have done here:

https://spookycigars.baserow.site/mysmokingjournal

1 Like

I mean, that would work. However, I have THOUSANDS of records, and linking all that manually is a hard nope. Not to mention the data is expanding by the day.

Lokaar,

I don’t remember linking them all manually - I may have done a copy - bulk paste.
For new records, I need to link manually (in my case, the people who smoked), but for your use case, perhaps a default value could be set?

hope this helps…

I created this issue to add the feature Allow to use aggregation values in the application builder (#2915) · Issues · Baserow / baserow · GitLab