I was hoping to get some ideas on how can I go about doing this.
So I want to run a report that checks if one Encrypted field in one of our objects is empty but we cant use encrypted fields in any of the filters or anywhere.
We needed a way to check so we originally thought we could have a formula field and have a checkbox to see if it's empty if it is then check it. Unfortunately looks like Salesforce won't allow that I keep getting the
'Unsupported field type called "Text (Encrypted)'. Is there another way of doing this?
Actual formula : IF(LEN(CODE__c)==0,0,1)
Error: ' You referenced an unsupported field type called "Text (Encrypted)" using the following field: CODE__c'
Can we use apex class to check this instead?