As a new feature of smart seatsWorkflow templateWas added.
It seems to be important among them"Alert if row is deleted"Introducing the functions of.
Workflow template
Access from the workflow template automation menu.
Newly added workflow
If you look at the template, you'll see a template called "Alert user if row is deleted".
For some reason it's not in the trigger menu of the current workflow, but you can use this feature from the template.
Workflow to alert when a row is deleted
Significance of new features
Collaborators delete rows
What I care about when managing smart seats isIf you give collaborators sheet-level editing rights, you also get permission to delete arbitrary rows.That is.You can lock the row to prevent this, but doing so will prevent collaborators from editing.
So if a collaborator accidentally deletes a line,There is no choice but to restore from backupThere was a problem.
If you have not backed up, go to the activity log to take a snapshot before deletion and restore the row.
Dealing with the damage caused by deletion before it spreads
By making it possible to use the "workflow that alerts when a row is deleted", sheet managers, etc. can use it.Before the damage caused by the deletion spreads, it is possible to take measures such as warning to the person who restored the line or deleted it.It looks like
The actual "Delete Row" alert workflow
As mentioned above, this workflow is currently selected from the workflow template gallery.
It's simple to use and alerts the user with "Delete Row" as a trigger.
Alert destinations include specific users, all users with whom a sheet is shared, and so on.You cannot select columns in the contact list.
Is the alert good for "all users with whom the sheet is shared"?
Deleting a row can have a lot of impact, so it might be a good idea to send an alert to everyone with whom the sheet is shared so that someone notices it sooner.
Alternatively, you may want to specify "Sheet Owner" or "Licensed Administrator or Editor".These peopleActivity logSince you can refer to, it is possible to restore deleted lines as needed.
Note that you should be careful when deleting rows, as attachments, cell history, etc. cannot be restored at this time, either as a backup or as a snapshot. (In Smartsheet, please make editable (but not delete lines) permission as soon as possible.
"Delete row" alert email sent
This is the email that was sent.I didn't edit the fancy message, but it has a sheet name, so I can handle it.