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! Go to 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.
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
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!
User | Count |
---|---|
17 | |
11 | |
7 | |
3 | |
2 |