2 Replies Latest reply on Dec 31, 2008 4:47 PM by travbrack

    Scripting: Patterncount for multiple repetitions

    travbrack

      Title

      Scripting: Patterncount for multiple repetitions

      Post

      FM Pro 9.0V3, Windows XP SP3

       

      Hi there, I'm trying to control access to records in a DB by determining whether the username is listed in a field.

       

      PatternCount ( Assigned Users ; Get(AccountName) )  >  0

       

      That works fine, but my problem is that the field has multiple repetitions, so if the username is listed in any repetition besides 1, it will return 0.  I don't see anything in the docs about how to do this. I guess I could make a loop that adds 1 to the active repetition, but I'd like to do it in one line if possible.

       

      Please help!