ArchiveUser
8 years agoQrew Captain
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.
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.