Discussions

Expand all | Collapse all

Compare users in fields

  • 1.  Compare users in fields

    Top
    Contributor
    Posted 02-22-2018 13:30
    I need to compare Field A and Field B below.  Field A is a multiple user select and B is a multiple choice.  The users in Field A have been selected to approve a document.  They must all complete before the approval is complete.  I have created a checkbox to do this.
    Contains([Quality Approval],(Part(UserListToNames([Quality Team]),1,";"))&"] Approved") and
    Contains([Quality Approval],(Part(UserListToNames([Quality Team]),2,";"))&"] Approved") and etc.

    My issue is I want to know which user has selected on the dropdown "Approved" or "Rejected".  So if a 10 users in Field A are required and only 9 have approved- which user am I waiting on.  I am putting a lot of documents through our system and would like a way to see this quickly.


    I now have this formula:

    var Text QTA = Part(UserListToNames([Quality Team]), 1, ";"); 
    var Text QTB = Part(UserListToNames([Quality Team]), 2, ";");
    var Text QTC = Part(UserListToNames([Quality Team]), 3, ";");
    var Text QTD = Part(UserListToNames([Quality Team]), 4, ";");

    If (not Contains([Quality Approval], $QTA & "] Approved"), $QTA) &
    If (not Contains([Quality Approval], $QTB & "] Approved"), $QTB) &
    If (not Contains([Quality Approval], $QTC & "] Approved"), $QTC) &
    If (not Contains([Quality Approval], $QTD & "] Approved"), $QTD) &

    Which works great.  The problem is they are allowed to reject and say what they need to change.  I want to know who all has not responded - chosen "approved" or "Rejected".

    I also would like a coma or semicolon between each name.  


  • 2.  RE: Compare users in fields

    Top
    Contributor
    Posted 02-22-2018 13:41
    Maybe this:
    var Text QTA = Part(UserListToNames([Quality Team]), 1, ";"); 
    var Text QTB = Part(UserListToNames([Quality Team]), 2, ";");
    var Text QTC = Part(UserListToNames([Quality Team]), 3, ";");
    var Text QTD = Part(UserListToNames([Quality Team]), 4, ";");
    If (not Contains([Quality Approval], $QTA & "] Approved")
        and
        not Contains([Quality Approval], $QTA & "] Rejected")
        , $QTA) &
    If (not Contains([Quality Approval], $QTB & "] Approved")
        and
        not Contains([Quality Approval], $QTB & "] Rejected")
        , $QTB) &
    If (not Contains([Quality Approval], $QTC & "] Approved")
        and
        not Contains([Quality Approval], $QTC & "] Rejected")
        , $QTC) &
    If (not Contains([Quality Approval], $QTD & "] Approved")
        and
        not Contains([Quality Approval], $QTD & "] Rejected")
        , $QTD)

    But at some point writing formula this long becomes ridiculous.


  • 3.  RE: Compare users in fields

    Top
    Contributor
    Posted 02-22-2018 20:38
    The ";" does not work.  Any ideas on this?  I want to separate somehow.