AnsweredAssumed Answered

Searching Multiple Fields in a Find

Question asked by mk4482 on May 6, 2011
Latest reply on May 6, 2011 by philmodjunk

Title

Searching Multiple Fields in a Find

Post

I am using FMP 11 Advanced on a FMP 11 Server.  I have a "work order" database in which jobs that come in are assigned to specific techs.  When tech 1 finishes their specific function, they re-assign the work order to tech #2 (from a drop-down list) to complete their specific function, and then on to tech #3, etc.  Up until now, I have had one "tech assigned" field which made the "find pending jobs" for a particular tech easy.  I have created more tech assigned fields (tech 1, tech 2, tech 3, tech 4) so I can keep track of when a tech is assigned the work order and when the next tech gets the re-assignment.  When the first tech finishes their assignment, they will reassign the work order to another tech using the tech 2 field, and when that tech finishes their assignment, they will reassign the work order to another tech using the tech 3 field, etc.  Not all work orders will use all 4 tech fields.

My problem is in writing a script so that I can find current pending work orders per tech.  So how would I write (I am not a programmer) "if tech 4 field is blank use tech 3 field (assuming tech 1 and tech 2 fields are used), if tech 4 field and tech 3 fields are blank use tech 2 field, if tech 4 field and tech 3 field and tech 2 fields are blank, use tech 1 field? 

I hope this make sense.  Thanks!

Outcomes