Using <=/>= in an Alert

Sara C

Hi - 

I am trying to set up an Alert for when a column gets to greater than or equal to .75. When specifying a change, I can only select existing values. When I have typed ">= .75" I have not gotten any updates when that change is met. It makes me believe that typing in "<=" is not valid. 

I have looked through the community posts and it looks like you used to be able to choose a "greater or equal to' option when setting up an alert, not sure what happened to it. Maybe when the layout of the Alert set up changed it made it not as obvious anymore?

Thanks for your help!

Paul Newcome

You can set it by adding a condition. See screenshot below. Just click on the + below the criteria box.

Andrée Starå

Paul,

I knew that, but somehow it escaped me at the time. 

Best,

Andrée

Mike Wilday

Hi Sara, 

I think this is actually possible. Check out my screenshot to see the results (right-click to open in a new tab and enlarge it). 

1. Set up a new action for when a row is added or updated. 
2. Set the action to look at any changes to the percentage column. 
3. Add a condition, Only when Percentage is greater or equal to...
4. add .75 as the value
5. determine who the alert should go to. 

Let me know if that works. 

Mike Wilday

Whoops forgot the screenshot! 

Mike Wilday

And it looks like Paul beat me. 

Mike Wilday

Sara, if you don't set the change specifically to the percentage field, in the first box of the alert, you will get an alert anytime, anything on the row changes, not just when the percentage changes. just something to consider as you're setting it up. 

Paul Newcome

No worries. I was on a 3 day tirade when they first changed the Alerts and Actions format. Then a coworker asked "What if you click on that little plus thingy there?" Hahahahahahaha 

Paul Newcome

Haha. Usually I open up a thread to answer and see that either you or Andree has already answered. (Craig has been rather quiet lately. Hmm...). This time it was my turn. Hahaha