Counter Issue

AppSheet AppSheet Q&A
, , , ,
1

Hi everybody

Kindly have a look the below image. The item shows a number 1, which represents how many rows in the child table.

Can I the know the expression used to evaluate that number.

I am trying to move data from this table to a new table and for the item column I want to but as number value so for example the item number is 1 it will show 1 and if 2 it shows 2. ets.

Can I have the same row counter in parent table after I apply some filters. For example I filter all row of customers who want to buy chairs for example.

Thanks

app.jpg
app.jpg322Ă—394 14 KB

2

COUNT(FILTER(“CHILD TABLE”, [ref to PARENT]=[_THISROW]))

this assumes that the expression is placed in the PARENT table as one of its Columns

1 Like
3

@TeeSee1

Thank you very much

on the same table for example I want to count how many rows after certain filters are done.

I wrote this

COUNT(FILTER(“Orders”, [Order ID]=[_THISROW]))

where order ID is unique but it only shows 1 , it does not calculate rows number.

in my case it should see how many IDs and out the number.