I have a simple bot that looks for all changes on a table and triggers an action on a set of rows. When I click the referenced action, it works. When I test the bot, I get no errors. Other than that, I cannot get the bot to trigger.
The action simply calculates the sum of quantities in different statuses. I suspect the issue is the referenced rows however, breaking down the expression, I can’t seem to figure out the glitch. Please help.
Have you been able to check any errors the BOT shows under Manage – > Monitor → Audit History – . Launch Log Analyzer?
Doesn’t look like I can do that unless I’m on the Enterprise plan
>>“I suspect the issue is the referenced rows however, breaking down the expression, I can’t seem to figure out the glitch. Please help.”
Don’t you think it might help if you show what you’re doing there?
You most definitely can view the audit logs on any plan. Also check the Automation Monitor.
On audit logs part, you can certainly view audit logs for past 7 days at least even if you have the Starter or Core plans. Below screenshot is from the Pricing page.
With other Enterprise plans, the additional feature is the audit logs are available for much extended period and one can apply more filtering options apart from date range to those logs.
Didn’t look hard enough. My bad. Shows no errors.
When a user adds or updates a row on the Totals_Scans table, the bot triggers an update to Quantity_Prepped and Quantity_Boxed columns on the inventory table.
Event type: Data Change; All changes
Table: Totals_Scans
Bot condition: None
Action: Run action on rows
Referenced Table: Inventory
Referenced rows: SELECT(Inventory[ID],OR(IN([ID],Totals_Scans[FNSKU_ASIN]), IN([ID],Totals_Scans[FNSKU_ASIN])))
Referenced Action: Data: set the values of some columns in this row
IFS(SUM(SELECT(Work Order Form[Prepped],AND(
[_THISROW].[ID]=[WO_MSKU],IN([Prep_Status],LIST(“Working”,“Boxing”)))))-SUM(SELECT(Work Order Form[Sent],AND(
[_THISROW].[ID]=[WO_MSKU],IN([Prep_Status],LIST(“Working”,“Boxing”)))))>0,SUM(SELECT(Work Order Form[Prepped],AND(
[_THISROW].[ID]=[WO_MSKU],IN([Prep_Status],LIST(“Working”,“Boxing”)))))-SUM(SELECT(Work Order Form[Sent],AND(
[_THISROW].[ID]=[WO_MSKU],IN([Prep_Status],LIST(“Working”,“Boxing”))))),SUM(SELECT(Work Order Form[Prepped],AND(
[_THISROW].[ID]=[WO_MSKU],IN([Prep_Status],LIST(“Working”,“Boxing”)))))-SUM(SELECT(Work Order Form[Sent],AND(
[_THISROW].[ID]=[WO_MSKU],IN([Prep_Status],LIST(“Working”,“Boxing”)))))<=0,0)`
SUM(SELECT(Totals_Scans[Total],AND(
[_THISROW].[ID]=[FNSKU_ASIN],[FNSKU_ASIN]<>“Total”,[Amazon_Shipment_ID]=“Blank”)))`
