Hello People!
In my head, this sounds like a simple thing, but unfortunately, I haven't been able to find a solution that easily. Here's what I'm trying to do.
I have an app working just the way I want it. In this app, I have a gallery connected to a table (named 'Inventory') that aggregates the field of a different table (called 'InventoryMovements'). The result of this aggregation is displayed in a text label inside the gallery. Here's a screenshot for reference and the code I used to get that result:
Text(Sum(Filter(Movimientos,MarcaDeProductoBC.MarcaDeProductoPR=ThisItem.MarcaDeProductoPR),Unidades),"0,#")
Pretty neat. The problem is not in the app itself, however. What I want to do now is to take the results of the sum (For example; 03 in the case of the first item) and patch the table that the gallery is connected to (the 'Inventory' table) based on the item (in this case: Planchita).
Any ideas?

Report
All responses (
Answers (