function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
coolbeastcoolbeast 

PRIORVALUE in Custom Formulas

PRIORVALUE on CONTACT entity:
 
I am trying to write a Custom Formula (Field Update) that uses PRIORVALUE for MAILING ADDRESS fields. (Street, City... etc). The PRIORVALUE works fine when the prior value of these fields is not blank. In the case when the prior value of all these fields* (and not one of the fields) is blank, it returns the MAILING ADDRESS information of the associated ACCOUNT.
 
I want to update certain fields when the MAILING ADDRESS information (any field) changes and due to the problem explained above, it is not working when all the fields are blank.
 
Anyone please suggest.
 
Thanks
KaushikKaushik
Hi
I assume that you are using the workflow  field updates.
In that case you could trigger the update only when the address of the contact is not blank.

You could also have a validation to prevent saving a contact with a blank address

Hope this helps you

Kaushik