Alerts - Notify when Text Changes

Is there any way to set an alert of a change in text? I have a table card that lists addresses (Street, City, Zip Code) and I need to be alerted if there is a change in one of those fields.

When attempting to create a new alert, I receive the error "No alertable metrics found on this card. Please add a Summary Number or change chart types and try again."

TYIA!

Best Answer

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    What you could do is use a recursive ETL to store the current value that's being updated and the old value that was in the former dataset. Then compare the two, if they're different you can set a flag on the record saying it changed and then alert on that specific value.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Answers

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    What you could do is use a recursive ETL to store the current value that's being updated and the old value that was in the former dataset. Then compare the two, if they're different you can set a flag on the record saying it changed and then alert on that specific value.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • Ingenious. Thank you!