Generate multiple lines

[Alberto68]

Good afternoon everybody!
I have the following problem: I have created a block that generates multiple rows in a database (300 or more). The issue is that it takes a long time to finish updating the database (Googel Sheet). There is some configuration so that this does not happen.

[Aurelien]

Hi @Alberto68 

You may want to consider using a bot to achieve this operation.

Steps: The Essentials - AppSheet Help

[Alberto68]

Thanks, that's what I'm looking to do. On the other hand, wouldn't you know how to fire the bot with an action button?

[Aurelien]

---

@Alberto68 wrote:

On the other hand, wouldn't you know how to fire the bot with an action button?

---

There: Example automations - AppSheet Help

[Alberto68]

Thanks, but I don't see how to link a button to a task.
Sorry and I imagine it shouldn't be very complicated.

[Alberto68]

t's all about sending emails. In my application it has to take the data from a record and create a series of rows (using an Appscript) and to join this action it has to be executed using an operator action.

[Aurelien]

---

@Alberto68 wrote:

how to link a button to a task.

---

 You need to create an action button, which is simply made with this for example:

Then, you have to remember a bot is made of two main components: an event, and a process (which is made of steps).

So, you have to build a bot which focuses on a data change and will send the email:

The condition for the event is set with:

[_THISROW_BEFORE].[TriggerEmail]<>[_THISROW_AFTER].[TriggerEmail]

And in the process, you will have this step: