Hello, I've just designed a "For Sale" list on our SharePoint intranet (to encourage usage), but have just discovered a big problem that I need help with!
I needed a way to lock down list entries so that they could only be edited by the creator, even when lots of people share Active Directory (and therefore SharePoint) accounts. I added a 'Password' field, so that the user can choose a password when they create a list item.
When the list item is created, a workflow runs that copies the details (including password) to another (well hidden) list, and then blanks the password field in the main list.
When a list item is edited, another workflow checks the password entered against the password entered on initial creation, and if they do not match, returns the main list item to its state prior to editing by copying back the details from the hidden list.
This works really well, but I have just discovered a big problem! Anyone that signs up to receive alerts about new list items gets all the details including the password. I've decided that the best way to get round this will be to disable alerts on both lists. After some Googling it appears this might be possible by creating a custom 'Feature' (which I've never done before).
My question is has anyone successfully done this, and are there any other ways?
thanks
Howard
(We're using WSS 3.0 and MOSS 2007)