Hi, can someone help me with the following.
I would like to setup a workflow/automation: when I fill in a form (add data to one table) that after saving the form data is edit in an order table automatically, for example the status becomes โlist checkedโ.
When I try to set this up in Automation with data change โData changes to which table should trigger this event?โ must be the same as โWhat entity table does this task work against?โ in Tasks???
The action to follow doesnโt allow me to change/edit data in an other tableโฆ
How can I solve this best??
There are two actions that you can use.
So you would build a Bot that has an event on change to TableA. Then define a process that has a data action step to update the row in TableB with on of the options stated above.
For more info on the automation essentials take a look at AppSheet Automation: The Essentials | AppSheet Help Center.
Hi Dan, thank you so far. The expression must be written in the References Row (From the referenced table, these are the rows to act on) I assume?? And what could the expression look likeโฆ
I need to change the status (from โopenโ to โclosedโ) of a value in Table A if the Keys ID of Table A = Table Bโฆ
Hi Dan, thank you so far. The expression must be written in the References Row (From the referenced table, these are the rows to act on) I assume?? And what could the expression look likeโฆ
I need to change the status (from โopenโ to โclosedโ) of a value in Table A if the Keys ID of Table A = Table Bโฆ
@MJvanEwijk wrote:Hi Dan, thank you so far. The expression must be written in the References Row (From the referenced table, these are the rows to act on) I assume?? And what could the expression look likeโฆ
I need to change the status (from โopenโ to โclosedโ) of a value in Table A if the Keys ID of Table A = Table Bโฆ
Do we have a solution to this?
There is no built-in way to do it.
User | Count |
---|---|
41 | |
36 | |
30 | |
23 | |
16 |