AnsweredAssumed Answered

Script for searching multiple fields

Question asked by on Sep 21, 2010
Latest reply on Sep 21, 2010 by philmodjunk


Script for searching multiple fields


We run an art gallery and have artwork moving from in-house to conservators, framers etc. I have 8 fields in my movement report - 'movement from' 1 - 4 and 'movement to' 1 - 4. I want to write a script that will find, for example : Field 'Movement from 1' contains 'x' OR 'movement to 2 contains 'x'. I have only been able to get as far as 'Movement from 1' contains 'x' AND 'movement to 2 contains 'x' which obviously will show no return. Any advice much appreciated.