Alert types

Hello Costas,

With some configuration, you can accomplish this. Using an automatic calculation, you can set the value of a Date/Time field (say 'Yes/No Last Modified') to the current date/time whenever the value of the Yes/No field is modified.

The 'Yes/No Last Modified' calculation should be Text. Assuming you are not defaulting the value of the Yes/No field to 1, it would look like:

Yes/No Last Modified =

$Case(

Yes/No == 0 && Yes/No Last Modified == "" , "" ,

Yes/No == 1 , $CurrentDateTime() ,

1 == 1 , $CurrentDateTime()

)

If you are defaulting the value of the Yes/No field, then you would use:

$Case(

Yes/No == 1 && Yes/No Last Modified == "" , "" ,

Yes/No == 0 , $CurrentDateTime() ,

1 == 1 , $CurrentDateTime()

)

Then a Match Criteria Alert can run daily, looking for records with 'Yes/No Last Modified' is in the last day.

Ryan