I have created a scheduled event to send an email when a column date field [Contract Ends Date] is equal to today. But in my testing I am getting every line of data from the sheet. Can someone help me. What have I missed.
[Contract Ends Date]=Today()
From the screenshoot is seems you want one email per record that has an End date equals to Today.
Now, you are receiving the same amount of emails as records you have with no filter?
Just to make sure I get it right
You may want to try to make the setting “Foreachrowintable” to off.
This is correct. Looking to get one email per record that has the date equal to today.
I did try this and received one email that included all the records also.
How are you testing the bot? Are you using the Test button or the Run one?
Also, what seems weird to me is that you are receiving each row from the list, it would be easier to fix if the filter condition is filtering out everything.
Please post the Test results from the Expression Assistant for the expression you made
While Testing I am doing both the Test & Run buttons.
Here is the Expression Assistant.
Test results pull back all records, this is just the last two records:
Well, it seems the expression is actually working.
Are you sure you are getting up 400 emails each time you test? Just checking
I just retested and I can confirm that I am not getting every line. I am getting notified on the lines that the Date matches, the Date has already pasted and where there are blanks to the Date field. Is this something that the process need to do the first time it runs? Is there a way to avoid these?
Change it to:
AND(
ISNOTBLANK([DATE]),
[DATE]=TODAY()
)
Thank you very much. This worked as it should.
Curious to know why do we need the ISBLANK check?
Depending on the app configuration, AppSheet handles the = operator strangely: if the left-side operand is blank, the result will be TRUE no matter what the right-side operator is. So if the expression is [DATE]=TODAY() and [DATE] produces a blank value, the expression is TRUE, even though a blank date value is not rationally the same as today’s date.