We have been trying for a while to solve a Drupal Rules problem. The situation is;
On every cron run we would like to check for Users who have a certain Role. We will then send an email to those Users. But we only want this email to go once.
We are thinking therefore that we will create a new custom/hidden User field called 'email sent'. Then the rule will;
- EVENT: On every cron run
- CONDITION: Check for Users who have the role AND have a null value in that field
- ACTIONS: Send an email to the users AND set the value of the user 'email sent field to 1.
We think this is possible but we can't see how you can set up a rule to do this. Any help really appreciated