Skip to main content
Question

Add Rejected to formula

  • February 21, 2018
  • 0 replies
  • 36 views

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

  • Quickbase Alumni
  • February 21, 2018
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?

  • Author
  • Quickbase Alumni
  • February 21, 2018
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.