LinkedIn
Twitter
hello, i just need some help regarding my automation, the table i needed for this automation is supposed to be 上司2承認 but appsheet has chosen the other table already and i cannot even choose from them.
is there anything that i missed?
i need to show the detail of 上司2承認 for my app view to embed in email body .
i cannot do that if i couldnt change the table above.
thank you in advance!
When you create an automation, it operates in the context of a certain table. This is controlled by the Bot Event section. You cannot mix table context amongst the Bot steps.
Since it looks like you are trying to send an email, you would need to create a separate Bot that operates on the Tables rows you wish to use for generating emails. The tricky part is determining how the Bot identifies the rows it needs to operate on. Many times this means having a dedicated column in that table strictly for triggering the Bot - e.g. "Send Email".
If you can provide more details about your Bot and process to identify rows for which to send emails, we might be able to help with design considerations.
I hope this helps!
****************
To round this out for understanding...in Data Change Bots there is, what I call, a "bridge" action. It's purpose is to identify rows in another table and transition to actions(s) on that table for data updates. See image below for the action type. This bridge action cannot be used for generating emails as there are no actions that perform that kind of activity. Email generation is a Bot level activity only.
