Hi All,
I just need some help, please.
I have 2 tables in my app, Table 1 and Table 2.
Each table has an action - Action 1 (in Table 1) and Action 2 (in Table 2).
If I trigger Action 1, is there a way to also trigger Action 2 simultaneously?
For example, if I run Action 1 in Table 1, it will trigger Action 2 to change the value of a row in Table 2.
Noob here, so please be a little more elaborate on your answers ๐
Solved! Go to Solution.
Hi @Aaron_B
Yes it's possible.
What you need to do is:
-create your Action1 from Table 1
- create your Action2 from Table 2
- create an Action3: with these settings:
==> For a record of this table : Table1
==> Do this : "Data: execute an action on a set of rows"
==> Referenced Table : Table 2
==> referenced Rows: a FILTER() expression, I suggest you have a look on the help documentation for this part
FILTER("Table2", yourCondition)
==> Referenced action: Action2
- create an action "Grouped : execute a sequence of actions" from Table1 with these:
==>Action1
==>Action3
Let us know if you have some trouble into implementing this.
For reference:
https://help.appsheet.com/en/articles/2357308-filter
We need explanation by what parameters action 2 would know which row to change in Table 2
Hi @Aaron_B
Yes it's possible.
What you need to do is:
-create your Action1 from Table 1
- create your Action2 from Table 2
- create an Action3: with these settings:
==> For a record of this table : Table1
==> Do this : "Data: execute an action on a set of rows"
==> Referenced Table : Table 2
==> referenced Rows: a FILTER() expression, I suggest you have a look on the help documentation for this part
FILTER("Table2", yourCondition)
==> Referenced action: Action2
- create an action "Grouped : execute a sequence of actions" from Table1 with these:
==>Action1
==>Action3
Let us know if you have some trouble into implementing this.
For reference:
https://help.appsheet.com/en/articles/2357308-filter
@Aurelien, YOU ARE AMAZING! That is exactly what I needed. Thank you so much! Great explanation too!
In Table B, you can create a column X that references Table A by making column X a Ref type and setting the Is Part Of? option in the column's settings to TRUE with an Initial Value of [_THISROW].[Column X].[ID].
This will create a dynamic link so that when changes are made in Table A, they are also reflected in Table B.
For example, let's say:
To achieve this, you can:
[_THISROW_BEFORE].[Status] <> [_THISROW_AFTER].[STATUS]
This formula will cause the actions to fire only when the value of the [STATUS] column changes.
Configure a referenced action for Table B to set the value of [STATUS]. This action should use a LOOKUP expression and have its behavior set to TRUE so that it only fires when called on.
Configure a BOT workflow that, if the value of [STATUS] is added or updated in Table A, will update the value of [STATUS] in Table B using the referenced action in Table B.
This setup will cause both actions to fire anytime the [STATUS] column is added or updated in Table A. The value of the [STATUS] column in Table B will also be updated by the BOT workflow.
Additional notes:
LOOKUP([_THISROW].[OrderID], "Table A", "ID", "STATUS")
User | Count |
---|---|
41 | |
25 | |
25 | |
17 | |
12 |