Alert someone when a row is deleted

mmac

Hello, I have this workflow configured. However, when a row with data is deleted from the sheet, the notification is triggered, and an email is sent, but the data from that row is not displayed within the email. Does this workflow notification allow for the data to flow into the notification so the user knows what's actually been deleted?

Andrée Starå

https://community.smartsheet.com/discussion/138263/alert-someone-when-a-row-is-deleted

Hi,

I hope you're well and safe!

It's because when the Workflow triggers, there's no data left. A workaround could be to move the row to another sheet and have it trigger from that sheet instead.

Make sense?

Would that work/help?

I hope that helps!

Be safe, and have a fantastic day!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Awesome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!

Mounika

Hi @mmac

Technically, the alert is running after the row has been deleted, which means the data was already deleted by the time this workflow runs, so I believe it is not possible to include what was deleted within the email alert.

Andrée Starå

https://community.smartsheet.com/discussion/138263/alert-someone-when-a-row-is-deleted

Hi,

I hope you're well and safe!

It's because when the Workflow triggers, there's no data left. A workaround could be to move the row to another sheet and have it trigger from that sheet instead.

Make sense?

Would that work/help?

I hope that helps!

Be safe, and have a fantastic day!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Awesome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!

mmac

Thank you @Andrée Starå and @Mounika for the insight. I understand the logic, but I was hopeful that the automated alert would carry over the data that was deleted, similar to how you can review the change history of the sheet. Otherwise, for this instance, the alert just tells you something has been deleted, but no one knows through the alert what that something is.

Andrée Starå

https://community.smartsheet.com/discussion/comment/480300#Comment_480300

Happy to help!

Yes, that would be ideal, and maybe that is something that could be developed.

Please submit an Enhancement Request when you have a moment

✅ Remember! Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Awesome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!