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):

1. Only a few cells need to be deleted, not the whole record.


2. 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!