Notification for when a field changes from specific option to any other option.

  • 1
  • 1
  • Question
  • Updated 4 years ago
  • Answered

I want to receive a notification only when the field Contact Status changes from "Call Center" to anything else, not any other status changes. So I don't care if it goes from New Lead to Prospect or Prospect to Dead Lead, just Call Center to Prospect, New Lead, Dead Lead or any other value in the multiple choice field. It looks like the notification options only lets you choose a notification based on the value after the change, not before. I'm sure there is a simple formula field i could create to trigger it, but I am not the best at those. Appreciate any help or input.

Photo of Michael

Michael

  • 10 Points

Posted 4 years ago

  • 1
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,422 Points 50k badge 2x thumb
No problem.  Look near where it says "Notify When" and in blue it says "additional criteria". Open that up and checkbox your [Contact Status] field.
Photo of Michael

Michael

  • 10 Points
Yes, however that still does not achieve what I need. Doing that only lets you specify the condition based on what the value is AFTER the change, I want it based on what is was BEFORE the change. Before the change it was Call Center, now it is anything else.