Lets’s say we have 2 Tables:
Orders - Parent
Items - Child
In the Orders Table, AppSheet automatically creates the column [Related Items].
In the Items table I want to know how many Items are created. So I use this expression:
COUNT([Orders].[Related Items])
This is working. But when I add a new item, this new item is not counted in the form view. I first have to save that new item, then it’s counted.
So my workaround is this:
COUNT(SELECT(Items[ID],AND([Order]=[_THISROW].[Order],[ID]<>[_THISROW].[ID])))+1
This counts all Related Items, except the row I’m in. Then it adds 1.
This is working, but it seems to me that there should be a better way
P.S.: I need this calculation in the form view. Another column needs this for calculation.
Adding @MultiTech_Visions
User | Count |
---|---|
40 | |
34 | |
30 | |
23 | |
17 |