1 Reply Latest reply on Sep 29, 2009 10:02 AM by philmodjunk

    Script question

    kilbot

      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 )

      )

       







        • 1. Re: Script question
          philmodjunk
            

          There's a function called "GetRepetition" that you can use to check each repetition in a loop.

           

          However, as I think has been recommended to you elsewhere, it would be much, much easier for you to split your data into a related table where each record stores the data for one repetition.