Count records

[Alvim]

Hi

How can I count the records of a table and display it on the app screen?

Tks

[Marc_Dillon]

help.appsheet.com

COUNT()

Number of list items

[Alvim]

I’m using the ‘detail’ view type

Is there a method to display the total number of records somewhere on the screen

[Marc_Dillon]

You could add a Virtual Column to that Table, using the COUNT() expression from above, and show the new column in that Detail View.

[Alvim]

I created the virtual column and used the expression COUNT (SELECT (BASE [EMAIL], TRUE, TRUE))

the answer was 3
but BASE has 1660 records

I think I’m still missing something

[Marc_Dillon · Accepted solution]

Are there only 3 unique email addresses in the entire table?

help.appsheet.com

SELECT()

Gather column values from row in table or slice

[Alvim]

you’re right

I changed it to COUNT (SELECT (BASE [ACCOUNT], TRUE, TRUE)) and now I got the right result

tks

[Marc_Dillon]

COUNT( BASE[ACCOUNT] )
is equivalent

[Steve]

Technically speaking,

COUNT(UNIQUE(BASE[ACCOUNT]))

is equivalent.

[Marc_Dillon]

ya got me!

[Alvim]

I use a slice to separate the records from the base [EMAIL] = USEREMAIL ()
how do I link this to COUNT (SELECT (BASE [ACCOUNT], TRUE, TRUE))

[Marc_Dillon]

You specify Slices the same way you do Tables.

[Alvim]

I did not understand

I want to count the user current records

how can I do this