cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Alert types

Highlighted
Newbie

Alert types

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?

Tags (1)
1 REPLY 1

Re: 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