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?
Solved! Go to 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!
User | Count |
---|---|
18 | |
9 | |
8 | |
5 | |
5 |