Community Tip - Did you get an answer that solved your problem? Please mark it as an Accepted Solution so others with the same problem can find the answer easily. X
I would like to create an alert that should inform a person when a "Yes/No" field changes status.
Is there any Alert type that could support this criteria?
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