Skip to main content
Question

Compare users in fields

  • February 22, 2018
  • 0 replies
  • 25 views

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.  
This topic has been closed for replies.

  • Registered
  • February 22, 2018
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.