I’ve been trying to automate the deletion of sensitive data when a record comes into a certain view or meets certain conditions. No success so far…
There are 2 obstacles (to my limited abilities in this field):
- Only a few cells need to be deleted, not the whole record.
- The deleted cells are attachments, so it won’t work to update a record with an empty cell. I’ve tried, but the attachments remain where they are, even though the tests run successfully.
I’ve read a bit about scripting, but this is beyond my understanding. Does anyone know a way to achieve this, even for a noob as myself?
TIA!