Hi all
I have created a bot that creates a PDF and sends that as an email when two conditions are satisfied -
1. Status of the record is "finished"
2. Verification Status is "verified"
Verification status is a virtual column that gets updated based on whether an entry is added to another table.
This bot used to work for me just fine but it stopped working randomly.
I have set the event to an update when both of these conditions are met.
When I test the bot, I can only see 24 rows of data.
As you can also see, the fields for Job Status and Verification Status are "Finished" and "Verified"
But there are more rows on this table. Why can't I see the rest of the records? When I test the expression I get the following output which is what I expect to see.
My bot's structure is below:
After adding a record and making sure that both status change to what I expected to see, I cannot see any activity when I go to the monitoring tab of the bot.
Any ideas what I can do to troubleshoot this?
This is what I see in the automation monitor:
Please check what the Audit history shows when you modify the record. There is a log as "Edit row". What happens right after that?
How I have fixed this is I have changed the verification status from a virtual column to a column on my google spreadsheet and set a bot to update the verification status. This works for me now. I checked the audit log and it doesn't show me anything useful tbh.
So.. now the question is, how have you triggered the Bot? It should send the email every time when you modify the reord?
User | Count |
---|---|
17 | |
10 | |
7 | |
5 | |
5 |