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
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](https://support.google.com/appsheet/table/10104782?hl=en&ref_topic=10099895,10173496,10099316,#query=sum()([SELECT](https://support.google.com/appsheet/table/10104782?hl=en&ref_topic=10099895,10173496,10099316,#query=select()(Table2[Amount], [Type] = [_THISROW].[Type])
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
Consider one of the following techniques:
