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 befo...
Forum Discussion
Maybe this:
But at some point writing formula this long becomes ridiculous.
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.
- The ";" does not work. Any ideas on this? I want to separate somehow.
