How do I configure automation bots to process per row instead of per table?

[ky4tz]

I configured an automation bot to produce a PDF at the end of my process (when the column [Complete] is true). The process works fine but as I add more and more rows to the table, I noticed that AppSheet will regenerate the PDF for all rows with [Complete]=true.

How do I implement an automation bot to check only the row that's being edited?

[WillowMobileSys]

---

@ky4tz wrote:

How do I implement an automation bot to check only the row that's being edited?

---

Make sure your Bot has been configured as a Data Change Bot and not a Scheduled Bot. 

Data Change Bots operate at row level already and are automatically triggered when a row is edit (or added if you set the configuraiton that way). 

Your PDF template can assume that it has been given the row that triggered the Bot and simply refer to the columns of that row - e.g. <<[A row column name]>>.  

If your Bot is a Data Change Bot and you are still having trouble with this, please show us your PDF template.  More than likely you have implemented an expression in your template that retrieves multiple rows to be processed.

[ky4tz]

This is my PDF template.

[WillowMobileSys · Accepted solution]

---

@ky4tz wrote:

...I noticed that AppSheet will regenerate the PDF for all rows with [Complete]=true.

---

Template looks just fine and is helpful to understanding your issue. 

If I go back to your original comment (shown above), I take it that in the [Related Sales Order List] there are items that have the status of [Complete] = true that you do not want to show in the generated PDF?

If true, you simply need to adjust the START expression to filter those out.  You can do it like this:

<<START: SELECT([Related Sales Order List][Row Key Column], [Complete] <> true)>><<[Item Description]>>

NOTE: "Row Key Column", in red, needs to be replaced by the name of the column you have set as the key in your Sales Order List table.

I hope this helps!