Script to find records with a specific value in multiple fields
I have a layout which has many calculation fields. These fields vary in value, but if an empty field is detected, it will trigger an insertion of "!!EMPTY!!" into that field.
Is there a way to write a script that will show me records that have one or more fields that contain the value "!!EMPTY!!" ?
I can approach it by doing a bunch of If-Else statements, but is there an easier way? (I have 50+ fields per record).