I have a table named events that is a calendar. I have a bot to notify people when an event is made that sends a text and also sends an email to the members of the group the event is for. Everything is working on the text part because everyone has a phone number entered but some people do not have an email address entered. When the bot is triggered all the texts go out but the emails do not because there is no To: address because the email field is blank. Is there a way to skip to records that have a blank email so it will still send to anyone with an email address?
Solved! Go to Solution.
Maybe this?
select (
members[email], and(isnotblank([email]),[member group] = [_thisrow].[group]
))
User | Count |
---|---|
16 | |
11 | |
9 | |
8 | |
4 |