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
CafeCafe 

Edit content of formula fields

Is it possible to create a custom formula field that is not read-only? I have a situation where a formula can give us the right answer 90% of the time, but I want my users to be able to edit the field in special cases. As far as I can see, I don't have the option of editing content of formula fields. Has anyone been able to do this? Thanks
JakesterJakester
No, but you can provide a field that the formula checks. For example, if your formula right now is something like
Code:
price * quantity

 

Then you could add a manual_price__c field and then make the formula:
Code:
if isnull(manual_price__c),price * quantity,manual_price__c)

 
CafeCafe
Great! Thanks for the help!