Forum Discussion

ArchiveUser's avatar
ArchiveUser
Qrew Captain
8 years ago

Compare users in fields

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.  
  • 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.
    • ArchiveUser's avatar
      ArchiveUser
      Qrew Captain
      The ";" does not work.  Any ideas on this?  I want to separate somehow.