Workflow triggered by "add a new row to another ta...

Robert_Horvath · 11-28-2020 01:10 AM

Hello AppSheet Community,

Please take a look at the following diagram! is the following chain of actions and workflows are realizable?

Somehow the action “Add a new row to another table” cannot invoke Workflow #2. Although adding data manually to tableX start Workflow #2 and Action #2 as well.

Please let me know if AppSheet capable of handling this! If yes I will further investigate.

Thanks,
Robert

LeventK

@Robert_Horvath
Instead of Data Change worflow rule, use webhook workflow and choose preset AppSheet Edit Row. This will automatically trigger the workflow#2.

LeventK

@Robert_Horvath

Steve

The actions of a workflow will not trigger other workflows.

Robert_Horvath

Hello Steve,
Workflow rules will become Bots soon.
Your comment is valid for bots as well?
I mean a bot’s process can trigger another bot’s event?

Steve

I have no idea; I have no experience with Automation. @prithpal, can you offer any insight?

Koichi_Tsuji

Yes it will.
Automation will make it possible that the one workflow (currently called so) will trigger another workflow.

Former Community Member

Yes it can. If Bot 1 has a step/task of type “data change” that changes data on let’s say table2, and if you have Bot 2 that is listening for changes to data in table2, then Bot 2 will be triggered.

Koichi_Tsuji

Without separating into two bot, we wrap everything into one BOT to do the same job, is that right?
@prithpal

Former Community Member

Yes, you can wrap everything inside one bot.

Automation is built on the design principle of reusability (tasks, processes, events) which provides multiple options:

You can have a bot call another process directly through the “call process” step.
You can have bot trigger another bot directly (as discussed above)
Multiple bots can be created by reusing existing events & processes

Markus_Malessa

I think you are saying if BOT1 triggers an update event in another table and I have BOT2 configured to look for an Update_Only event in that other table, then BOT1 should trigger BOT2?

I have this set up actually, however BOT2 does not seem to get triggered.

Koichi_Tsuji

My understanding is the answer to your query is YES, correct.Thats how Automation would work and designed.
If not working, then I suggest you contact support.

Markus_Malessa

I guess I’m missing something then, because my second bot does not execute. Hopefully today’s office hours will shed some more light on this.

Koichi_Tsuji

Yes, will see.
I tested simple bots, and bot 1 triggered bot 2 as advised, for your guidance.

Markus_Malessa

Any chance you can share how you accomplished this? I have a table where a user interaction changes something, then I have a bot that changes a value in a Ref table and does some other things. My Bot2 is supposed to pick up the changes in the Ref table but apparently does not do so.

Any insight you could share would be appreciated.

Workflow triggered by "add a new row to another table" action