[SalesForce] Help: Salesforce will block JavaScript execution in hyperlink formula fields

I got an email from Salesforce stating that my org has JavaScript in hyperlink formula fields and that they would no longer be supported by October.
How do I find these? What is the solution?

I am in Classic. Here is the relevant article:

Salesforce will block JavaScript execution in hyperlink formula fields via a phased approach. Salesforce defines these fields as custom hyperlink formula fields starting with the string "javascript:"

Phase 1: Starting with the Spring '17 release, admins will be unable to create new hyperlink formula fields containing JavaScript. Editing and saving existing fields containing JavaScript will also be prevented unless the JavaScript is being removed. This change will not impact packages, sandboxes or change sets.

Phase 2: In the Summer '17 release**, a Critical Update Console (CRUC) setting will be introduced, allowing admins to opt-in to blocking the execution of JavaScript in hyperlink formula fields by activating the CRUC.

Phase 3: The phased approach will conclude with the Winter '18 release*** when execution of JavaScript in hyperlink formula fields will be prevented.

** Currently targeted for June 2017; date subject to change
*** Currently targeted for October 2017; date subject to change.

Best Answer

There's no easy way to identify these, so you'll have to manually search for them or check out your documentation.

Ideally, your org's been documented by someone in a wiki, and you can easily identify these fields. You'll need to either remove them or update them to not use JavaScript. The exact method depends on the formula's behavior. The most likely solution as a replacement will be a Visualforce page that does whatever the current script does.

If you don't have any documentation, you'll have go at it the hard way. That is, you'll need to download the Force.com IDE, download all of the objects, standard and custom, into your local file system, and search for the term 'javascript:' (no quotes) to find possibly offending fields. From there, you should be able to identify which objects have these fields, and the fields' names, at which point you can fix them or remove them as necessary.

If you need help converting a specific formula to a future-compatible format, please feel free to ask a separate question including the formula's code so that we can assist you.