Automated Workflow for Scheduled Email Notifications with Status Tracking

[KamenRider]

Hi,

I am developing a workflow that is scheduled to run at specific times. The workflow checks if a file has been updated with today's date, matching the "DateWrite" field. If a match is found, the workflow sends a notification email. The input file contains a status field that changes from 0 to 1, where 1 indicates that the email has been successfully sent. Although the workflow is scheduled to run twice a day, it will not send an email if it detects a status of 1, as this indicates that a notification has already been sent.

 

The issue I'm encountering is that when no records are displayed, the status field becomes blank instead of showing 0 or 1.

 

 

I hope someone would help me solve this problem.

Thanks

Kamen

[KamenRider]

Hi guys,

any help from somone?

Kamen