Delaying a row creation or a bot action

Rem
Bronze 2
Bronze 2

Hello, I'm trying to do the following

I have an action that changes a cell from a list of rows 

then these rows that were updated are copied into another table

when this happens it triggers a bot that is supposed to send a message to whatsapp using a webhook to every [phone number] in each row changed

but it happens so fast that all the webhooks aren't triggered, so it end ups sending 3 messages instad of 6 for example

is there a way to delay the creation of the rows or the webhooks?

Solved Solved
0 5 207
1 ACCEPTED SOLUTION

Thank you. Three points here you may want to explore

 


@Rem wrote:

action: execute an action on a set of rows

referenced rows: select(scheduling[CODIGO],[date]=TODAY())


Hope [Codigo] is the key column of the table. Reference row expressions expect key columns.


@Rem wrote:

it does for some of them, but my guess is the change in the columns happens so fast that the bot doesn't have time to send all the messages


You may in general want to explore the following set up in the bot automation

Bot step that changes the columns
followed by
A wait step
followed by
A step that send WA message

Also please check the bot monitor or audit history logs for any clue to the issue.

 

View solution in original post

5 REPLIES 5

Your action /  bot configuration is not clear but you may want to take a look at the wait step option in automation.

Steps: The Essentials - AppSheet Help

 

let me reephrase it

I have a bot that is supposed to send a message through whatsapp to a target phone number in various rows

i have it so when the bot sees a certain change in a row, let's say "send" Y/N it triggers the webhook that sends the message

but if i set an action that changes many rows in a row, the rows are changed but not all the webhooks are sent

Rem
Bronze 2
Bronze 2

action: execute an action on a set of rows

referenced rows: select(scheduling[CODIGO],[date]=TODAY())

action: set the values of some lumns in this row 

set this column: Remind? = Yes

the bots see the change in the column and is supposed to send a message to all the phones using whatsapp, and it does for some of them, but my guess is the change in the columns happens so fast that the bot doesn't have time to send all the messages

 

 

Thank you. Three points here you may want to explore

 


@Rem wrote:

action: execute an action on a set of rows

referenced rows: select(scheduling[CODIGO],[date]=TODAY())


Hope [Codigo] is the key column of the table. Reference row expressions expect key columns.


@Rem wrote:

it does for some of them, but my guess is the change in the columns happens so fast that the bot doesn't have time to send all the messages


You may in general want to explore the following set up in the bot automation

Bot step that changes the columns
followed by
A wait step
followed by
A step that send WA message

Also please check the bot monitor or audit history logs for any clue to the issue.

 

ok this actually slows the process enough adding a few seconds for it to work, thank you!

Top Labels in this Space