• 0
• Question
• Updated 1 year ago
• In Progress
I have this formula to determine if the operator has replied.

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, ";");
var Text QTE = Part(UserListToNames([Quality Team]), 5, ";");
var Text QTF = Part(UserListToNames([Quality Team]), 6, ";");
var Text QTG = Part(UserListToNames([Quality Team]), 7, ";");
var Text QTH = Part(UserListToNames([Quality Team]), 8, ";");
var Text QTI = Part(UserListToNames([Quality Team]), 9, ";");
var Text QTJ = Part(UserListToNames([Quality Team]), 10, ";");

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) &
If (not Contains([Quality Approval], \$QTE & "] Approved"), \$QTE) &
If (not Contains([Quality Approval], \$QTF & "] Approved"), \$QTF) &
If (not Contains([Quality Approval], \$QTG & "] Approved"), \$QTG) &
If (not Contains([Quality Approval], \$QTH & "] Approved"), \$QTH) &
If (not Contains([Quality Approval], \$QTI & "] Approved"), \$QTI) &
If (not Contains([Quality Approval], \$QTJ & "] Approved"), \$QTJ) &

I need to have if the user has listed has chosen Approved or Rejected.

I also need to have either a /n or comma between each user.
• 694 Points

Posted 1 year ago

• 0
• 218 Points
Is the [Quality Approval] field a text mult-line field with logging enabled? It also looks like you want to find out if it is approved or rejected along with who said that, correct?
• 694 Points
The Quality Approval is a Text - Multiple Choice with two options Approved or Rejected.

• 218 Points
I would use the Last Modified By field to determine who and the value in the value in the [Quality Approval] field to whether it says "Approved" or "Rejected"

I don't see the need for the other statements here, unless I am missing something.

Hope that helps.
• 694 Points
No, I guess I didn't explain it right.  formula is correct, but I need it to have rejected in addition to.  I tried:
If (not Contains([Quality Approval], \$QTA & "] "Approved", "Rejected"), \$QTA) &

and every possible revision of this.  Not sure what I am missing.

I also need it to have an enter or a separator between each.