Number of children

AppSheet AppSheet Q&A
,
1

I need to display the NAME and the number of repetitions of this product in the report, how can I do this?
Products are always different

Below is an example How the report should look like:

3X_8_0_8047f84897e729af73867f7385b49aff834bf752.png
3X_8_0_8047f84897e729af73867f7385b49aff834bf752.png267×105 1.36 KB

2

Can you give us more infotmation?

3

I have orders, they have REF, I need to display what and how much is in REF, while the quantity needs to be calculated COUNT (because the quantity is not written, that is, 1 position = 1 piece)

should be displayed in Google docs

I know how to display the order itself, but I don’t know how to display the total quantity of ordered goods for all orders

3X_a_f_af05a739eb7d75b747e0c2e45d1229d44fd900d5.png
3X_a_f_af05a739eb7d75b747e0c2e45d1229d44fd900d5.png1360×246 9 KB

3X_1_5_15a34c554ad4620ee6aedce3ce6983e74813054f.png
3X_1_5_15a34c554ad4620ee6aedce3ce6983e74813054f.png847×286 22.2 KB

osition = 1 piece)

1 Like
4 
COUNT(Select(TableName[Column],AND(
   [ColumnA]="123",
   [ColumnB]="456"
)))

Something like this will give you a total with a couple of variables. You can wrap it in <<>> and paste it into your template table if you want.

1 Like
5

This will not help, because the variations of variables can reach up to 50, and it is not entirely suitable to write them manually.

6 
COUNT(Select(TableName[Column],AND(
   [ColumnA]=[_Thisrow].[ColumnA],
   [ColumnB]=[_Thisrow].[ColumnB]
)))

?

2 Likes
7

So I won’t list only those products that I need. That is, I will iterate over each variable and display the number, however, they will be repeated and I do not need their repetitions.