I have a text field that is set to un-editable for all profiles. However if another field (checkbox) is checked, then this text field should become editable and required. I have created a validation rule for the required part. however I need this field remain un-editable when the checkbox is unchecked. Thanks for any input.
[SalesForce] How to make a field editable only if a checkbox is checked
Related Solutions
This isn't possible on standard pages using validation rules - the red "required" marker is only displayed when a field is required, either at the page layout or field level. A validation rule will mark the field when the error occurs, but this is after the user attempts to save.
You can do this in Visualforce, by conditionally rendering some additional classes, but that would mean (a) moving your whole page to Visualforce and (b) having some of your logic in the validation rule (the actual rule) and some in the page (the knowledge about whether to display the field as required to a particular user).
If your rule was specific to a profile rather than a user, you could have a different page layout for each profile and make the field required (or not) at the page level.
You can make the Account Owner field as Read only in the page layout assigned to those profiles.
But the recommended approach is to use a validation rule, like this:
AND (
ISCHANGED( OwnerId),
OR(
RecordType.Id = "000D0000000xxxx",
RecordType.Id = "000D0000000xxxx"
),
$Profile.Id <>'000D0000000xxxx'
)
Because then even if the user triggers the change through the API, for example, the platform will validate this change. Doing the "lock" just on the page layout does not prevent this.
Best Answer
You cannot allow them to edit this text field if you make it unallowed by removing access to profiles.
What you can do though, is allow them to edit by profile, but use a VF page in order to display this field. You can then put this VF page on the page Layout for the object. Use the VF page and/or Controller in order to control access to that variable.