Vote 1810  points

Hank Thompson

Enable Admins to Write Custom Formula Functions with Apex

Salesforce Platform, Apex & Visualforce, Customization, Database Services, Large Enterprise Ideas, Large Enterprise



It would be amazing to enable coding admins (those who can code Apex) to help out non-coding admins by allowing them to create custom formula functions which utilize more powerful logic branching than is available with the standard formula functions. The functions would be written in Apex but could be exposed as formula functions available in the formula creation screen. A simple example would be the creation of a function called "WORKHOURSBETWEEN" which would return the number of work hours between two date variables. Though this is possible to do with standard formula functions, the formula text is long & complicated and requires copying and pasting the exact formula text every time you want to use the logic within a new formula. It would be far more useful to other users as an abstracted function. A more advanced (but arbitrary) example would be the creation of a function called "ISVALIDZIPCODE". This function could use the capabilities of Apex to implement my company's custom logic which determines whether or not a zip code is "valid". By centralizing this in an Apex-powered "custom formula function" my company would be able to easily update the value of any formula utilizing the "ISVALIDZIPCODE" function by updating code in one place (the custom formula function) instead of updating a dozen formulas.

4 years ago · 21 Comments ·Merge Idea · Report Abuse

1 to 10 of 21 | Next Page

Ideas

Apps

Questions

Help us to keep IdeaExchange clean by pointing out overlapping ideas. We'll investigate your suggestion and merge the ideas if it makes sense.



 

 

Thanks for your merge suggestion. We will review it shortly and merge the ideas if applicable.

Salesforce.com takes abuse situations very seriously. Examples of abuse include but are not limited to posting of offensive language or fraudulent statements. To help us process your request as quickly as possible, please fill out the form below describing the situation. For privacy and security reasons, the final outcome of an abuse case may not be revealed to the person who reported it.


 

Thank you for your feedback. We take abuse seriously and will investigate this issue and take appropriate action.