AnsweredAssumed Answered

Script question

Question asked by kilbot on Sep 29, 2009
Latest reply on Sep 29, 2009 by philmodjunk

Title

Script question

Post

I wrote this script and it works however I have 15 repeating fields for each record and this only seems to work off the first field. Is there any way I could make this go through all 15 field and note if the last 3 position numbers were different. This way the field might show administration/engineering services

 

 

Let (

p = Right ( Position#; 3) ;

Case(
p < 100 ; "Administration";
p < 300 ; "Project Development/Planning";
p < 400 ; "Engineering Services";
p < 500 ; "Right of Way";
p < 600 ; "Construction";
p < 800 ; "Maintenance";
Other )

)

 







Outcomes