Add the content of one column to another using an action.

[MrOtter6]

Hello Appsheet Community,
I can't manage to create an action that copies all values from one column and adds them to a column in another worksheet.
Example:

Table A:

ID	Bill
1	5€
2	8€
3	2€

Table B

ID	Debt
1	2€
2	0€
3	4€

Action triggered:  Bill + Debt

Table B:

ID	Debt:
1	7€
2	8€
3	6€

Unfortunately, I could not find a solution to this problem. I would be very happy if you could help me here.

Many thanks in advance

[TeeSee1]

Create an action of type Data: set the value of some columns in this row on Table B

Set

• Debt = [Debt] + LOOKUP("ID", "Table A", "ID", "Bill")

You can run a bulk action to apply the action to the selected rows of Table B.

[MrOtter6]

Hello TeeSee1,
thank you for your reply.

Unfortunately, I have not yet managed to incorporate your suggestion into my project.

I have customized the formula but when I try to execute it as a bulk action, the value of ID 1 is used for all actions.

[to pay] + LOOKUP([ID], "Spreadsheet1", "ID", "Cost")

Result:

Table B:

ID	to pay
1	7€
2	5€
3	6€

When I use this formula I get this result:

[to pay] + LOOKUP("ID", "Spreadsheet1", "ID", "Cost")

Table B:

ID	to pay
1
2
3

it seems to return a void value.

[TeeSee1 · Accepted solution]

My mistake.

The first argument of the LOOKUP should bi [_THISROW].[id] instead of "id"

[MrOtter6]

With this formula it has finally worked.

[_THISROW].[to pay] + LOOKUP([_THISROW].[ID], "Spreadsheet1", "ID", "Costs")

Thank you for your Help 🙂