Enable Admins to Write Custom Formula Functions with Apex
Product Team Review
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.