You need to sign in to do that
Don't have an account?
Lloyd Ruz
How do I stop users editing an existing field value, but allow them to input data is the field is blank?
I am trying to make a validation rule which stops users editing the email address of a contact or lead UNLESS the email field is blank.
I have tried the following both formulae to no avail:
Email <> "" && ISCHANGED(Email)
IF( Email <> "", ISCHANGED(Email), ISBLANK( Email ) )
The reason for this is that the Salesforce record is checked against a nother databse which uses email address as the unique identifier, so whenever the email address is changed in Salesforce, it creates a duplicate record (with the new email address) in the other database.
Any help is much appreciated!
I have tried the following both formulae to no avail:
Email <> "" && ISCHANGED(Email)
IF( Email <> "", ISCHANGED(Email), ISBLANK( Email ) )
The reason for this is that the Salesforce record is checked against a nother databse which uses email address as the unique identifier, so whenever the email address is changed in Salesforce, it creates a duplicate record (with the new email address) in the other database.
Any help is much appreciated!
NOT(ISBLANK(PRIORVALUE(Email))))
All Answers
NOT(ISBLANK(PRIORVALUE(Email))))