How to make the app show the number of entries made in numbers

[Pranav_R]

Hi, I’m working for a company and creating an interface for me and my colleagues to make the process simpler. Here I have lots of rows with data, which are added using the form within the app itself. I want the number of entries in numbers to be shown at the top as a pop-out or on some sort, which should vary automatically when the users input new data.
For example, I already have 50 entries. I need the app to show the number 50 somewhere for the reference of the users that they have made 50 entries so far and when they input more entries, the numbers should change automatically, like if they add 4 more entries to the data, then the number 54 should be shown automatically somewhere (probably if it is like a pop-out kind then it would look good).
Thanks in advance for your help

[Marc_Dillon · Accepted solution]

An expression to find the number of entries in a Table:

COUNT( Table[key-column] )

I’m not 100% sure what you mean by “pop-out”, but I don’t think there is anything in Appsheet that’ll match that description.

Perhaps you could display the result of the above expression in a Show type column?

help.appsheet.com

COUNT()

Number of list items

help.appsheet.com

Column Types: Diving Deeper

Learn more about each column type you can have when structuring your columns.

Referencing a Column value in a Table, versus referencing ALL Column values in the entire Table Tips & Tricks 💡

Having answered this question about 1 million times now, I guess I should make a tips-and-tricks post about it. Expressions of the form Table[Column] return a List type data value that contains the values in Column for ALL records in the entire Table. Most likely, If I’ve referred you to this post, the answer to your question is simply to change it to just: [Column] One of the most common places I’ve seen new app builders use this, is within SELECT() expression, like: SELECT( Table[Col…

help.appsheet.com

App Formulas and Initial Values

How you can set app formulas and initial values to dynamically assign values.

[Pranav_R]

Thanks for the suggestions and explanations. The pop-out that I meant is about making it seen out like we see an add action button. Now I’m clear about the formula used, how to inbuild it into that button kind if it is possible?

[Marc_Dillon]

Sure, you could use the expression in the Display name for an Action button. Actions can’t be used inside of Form views though. I’d stick with my Show type column suggestion. Perhaps combine it with a quickchart image.

https://community.appsheet.com/search?q=quickchart

[ABHIJEET_PATIL]

COUNT(select(Table[Name], [Name]=[_ThisRow].[Name]))

This worked for me