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
Solved! Go to Solution.
My mistake.
The first argument of the LOOKUP should bi [_THISROW].[id] instead of "id"
Create an action of type Data: set the value of some columns in this row on Table B
Set
You can run a bulk action to apply the action to the selected rows of Table B.
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.
My mistake.
The first argument of the LOOKUP should bi [_THISROW].[id] instead of "id"
With this formula it has finally worked.
[_THISROW].[to pay] + LOOKUP([_THISROW].[ID], "Spreadsheet1", "ID", "Costs")
Thank you for your Help ๐
User | Count |
---|---|
32 | |
31 | |
30 | |
19 | |
16 |