AnsweredAssumed Answered

Script to find records with a specific value in multiple fields

Question asked by samxli on Nov 13, 2008
Latest reply on Aug 25, 2009 by ninja

Title

Script to find records with a specific value in multiple fields

Post

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). 

Outcomes