Hello everyone,
I have created a maintenance app which records all maintenance jobs, which later must be verified by the manager. I have a separate table for maintenance records and verifications, although it is a one-to-one mapping of verification to maintenance since each maintenance record should only be verified once. I record whether a job has been verified or not in the maintenance record using a field as a flag (Status = Verified/Unverified)
I have a bot which is supposed to create a .pdf file and send it as an email attachment whenever a job is verified. However, this bot is not getting triggered.
When I go to “Monitoring” section, I cannot see any information about that bot either, although I can see another bot which I have created to send daily reports.
I tried to run a test and it ran successfully and I received an email. I clicked on execute under run task “send email notification” column.
Can anyone help? thanks
You may wish to post your BOT triggering condition expression.
1 Like
Thanks for your reply
The condition is pretty straightforward
AND([Job Status]=“Finished”,ISNOTBLANK([Are all tools clean after use?]),[Verification Status]=“Verified”)
Thank you for the details. The change in a column needs to be detected by [_THISROW_BFEORE] and [_THISROW_AFTER]
So your condition could be something like
AND([Job Status]=“Finished”,ISNOTBLANK([Are all tools clean after use?]),[_THISROW_AFTER].[Verification Status]=“Verified”, [_THISROW_AFTER].[Verification Status]<> [_THISROW_BEFORE].[Verification Status])
OR
AND([Job Status]=“Finished”,ISNOTBLANK([Are all tools clean after use?]),[Verification Status]=“Verified”, [_THISROW_AFTER].[Verification Status]<> [_THISROW_BEFORE].[Verification Status])
Please take a look at the section “Sending Email When a Row is Updated to Have a Specific Column Value” in the article below. There is an example very much matching your scenario.
1 Like
