Modify a column from other For

[LoopinG]

Hey Helpers

Am all new to appsheet, and have started an app but cant figure out how i can change a value in a table from a form link to an other table.

Type	Amout
Transfer	0
Cash	0

This table most be updated from a form connected to this table when i click save:

Type	Amount
Transfer	10
Transfer	20
Cash	10
Cash	30

It must add the value to, is it clear?  hope so. well thanks helps if you can

[dbaum]

Various aspects of the best approach (e.g., virtual columns, actions, reverse references) are likely dependent on many aspects of your need and current app design that you haven't elaborated here. Based on the minimal information you provided, consider starting with an expression like the following in first table's Amount column's App formula property.

SUM(SELECT(Table2[Amount], [Type] = [_THISROW].[Type])

[LoopinG]

Ok, euh.... i need to update the [amounts] of a table called Tracking, every time a submit a form from a second table called Details, Value from row [Amount], with the type has ids

[LoopinG]

Better in image

[dbaum]

Consider one of the following techniques:

• Use an action designated as the view's form saved event to trigger the recalculation.
• Convert the data source column to a virtual column.