6 Replies Latest reply: Aug 7, 2017 10:56 AM by Aaron Wang RSS

    Create field 'Type' based on values in other fields

    Aaron Wang

      Any help is appreciated.

      I have Users and Documents.

       

      Each User can be tied to one or more documents, which that user is allowed to view.

       

      I have 5 documents named: AR, SA, IA, ED, CS

       

      I have 3 users: Holden, Aaron, Brent

       

      NTNAME, DocumentName

      Holden,AR

      Holden,SA

      Holden,IA

      Holden,ED

      Holden,CS

      Aaron,CS

      Brent,AR

      Brent,SA

      Brent,IA

      Brent,ED

       

      The above data linking Users and Documents is in an existing QVD

       

      There are three different ‘Types’ of users based on the groups of documents they are assigned.

       

      Aaron would be a type of CS

      Holden would be a type of BI + CS

      Brent would be a type of BI

       

       

      BI has access to at least one document but its not CS

      CS has access to only CS

      BI+CS has access to at least one non-CS doc as well as the CS doc.

       

      How can I assign this ‘Type’ in script?

      Create another field called type based on the above parameters?

       

      Thanks!