Bot Firing Issue

[MadScientistNut]

Hello all,

Overall my goal is to delete a row in another table based on a row being added to a table that has a matching value in a column. Details below. 

I have a table called Deletion Log and a table called Batch Code Generator. They both have a column called [batch code id] in them. In the Batch Code Generator table it is the key. The deletion log has another key. In the deletion log the column is a ref type(it does not reference the batch code generator table, but another table called status log where [batch code id] is the key) and in the batch code generator table it is a text type. 

What I want to do is use a bot to call a delete action by using a row being added to the deletion log table as a trigger and use run action on rows as the data action. In that dialogue I have the referenced table as Batch Code Generator table and the following formula to track down the row I would like to delete: SELECT(Batch Code Generator[batch code id], [batch code id] = [_thisrow].[batch code id]). The referenced action is set to delete, but nothing happens. Why?

[Elvic]

The easiest way to undestand what is going on with a bot is to open "Monitor" and simply take a look. 

One possible reason is that you have different field types, like Deletion Log[batch code id] is a text field but Batch Code Generator[batch code id] is a number field. Just a guess.

[Joseph_Seddik]

Your expression should simply be: LIST([batch code id])

[MadScientistNut]

I appreciate the responses. I am having a hard time understanding how to trouble shoot in the test page in the bot area. Could you provide some resources? I was able to achieve what I wanted through an action when the form saves which seems to have solved it.

Joseph, wouldn't that select all of the [batch code id] columns for deletion? The reason I ask is I did have some success when I plugged in Batch Code Generator[batch code id]. The bot fired, but ended up deleting everything in the table. Good thing I am still testing!

[Joseph_Seddik]

Generator[batch code id] is effectively the list of all values of the batch code id column in Generator table. 

[batch code id] is just a single value taken from the row that triggered the event, and you wrap it with LIST() because this field expects a list not a single value, though it will be a single-element list. 

[Joseph_Seddik]

---

@MadScientistNut wrote:

I am having a hard time understanding how to trouble shoot in the test page in the bot area

---

Use "Monitor", not "Test"