+ Start a Discussion
Malisa Gibbons 9Malisa Gibbons 9 

How can I write an APEX code to find out which reports are using specific fields?

I have several fields that were created as TEXT on the Account Page but should have been created as a FORMULA pulling information from the USER Informaton.  I need to replace all the fields being I cannot convert TEXT to FORMULA.
Is there a way to run a query to find out what reports these fields are being used on?
Example:
Object: Account
Text Field: FNAS First Name
Text Field: FNAS Last Name
NagendraNagendra (Salesforce Developers) 
Hi Malisa,

There are some App exchange products that does the same. You can give them a try n your sandboxes.
  • https://appexchange.salesforce.com/listingDetail?listingId=a0N3A00000EShrRUAT
  • https://help.salesforce.com/articleView?id=000001010&type=1
Hope this helps.

Kindly mark this as solved if the reply was helpful.

Thanks,
Nagendra