Is it possible if we could make a field un-editable by using field validation? We can't make it read only beacuse we have a code that uses selector report to update those fields. Is there a way we can put a validation on the field that it would throw an error message whenever a user tries to edit that field?
Yes, there is a function called ExcludeChannel("Web Services") that will not apply the validation rule to an update that's being made through a Web Services Call. I'm not sure how this would work though, never tried this on Field Validations. It's mostly used with Workflows.
All you need to do to the previous Validation Rule is add AND ExcludeChannel('Web Services'). Please make sure you test this well.
Actually, I just thought of a better way of doing this. This should definitely work
You probably would have only 1 user login that would communicate with your CRM On Demand instance via web services. Get the User ID of that username and add this line to the validation.
AND UserValue('<UserId>') not equal to 'XXXX-XXXXX'. For some reason the not equal to sign is not displaying after I submit the post. just replace the not equal to with the opening and closing angle bracket (less than symbol greater than symbol)
Edited by: Royston Goveia on Dec 12, 2012 11:23 AM