Insert a ; or space into formula

  • 0
  • 1
  • Question
  • Updated 8 months ago
  • Answered
Formula reads:
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, ";");

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) &


It comes out with all the names jumbled together.  
Photo of Sarah Bunten

Sarah Bunten

  • 664 Points 500 badge 2x thumb

Posted 8 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,166 Points 50k badge 2x thumb
Can we see an example of the current result that you do not like and how you want it to appear?
Photo of Sarah Bunten

Sarah Bunten

  • 664 Points 500 badge 2x thumb
Appears: Waiting onButch Glenn Juan Caballero Matthew LensmireMawuena Gnamavo 

Wanting: Waiting on: Butch Glenn; Juan Caballero; Matthew Lensmire; Mawuena Gnamavo

I tried: 
If (not Contains([Quality Approval], $QTA & "] Approved") and not Contains([Quality Approval], $QTA & "] Rejected"), $QTA & ";") &

But the ";" appears even if the user is not there;  In other words it appears as:
Waiting on: Butch Glenn; Juan Caballero; Matthew Lensmire; Mawuena Gnamavo;;;;;
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,166 Points 50k badge 2x thumb
Ah, so what you want to use if the List function.  The list function separates a list of text phrases with a delimiter that you set, but is smart enough not to add the separator of there is nothing to separate.

So you want your separator to be "; "

List("; ",

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),


etc

)  // close the List ( open bracket)
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,166 Points 50k badge 2x thumb
Can you post the formula as text and not as an image.  Using the "pre" button will help it's legibility. No way I can read what you posted.
Photo of Sarah Bunten

Sarah Bunten

  • 664 Points 500 badge 2x thumb
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, ";");

var Text CAA = Part(UserListToNames([CA Team]), 1, ";"); 
var Text CAB = Part(UserListToNames([CA Team]), 2, ";");
var Text CAC = Part(UserListToNames([CA Team]), 3, ";");
var Text CAD = Part(UserListToNames([CA Team]), 4, ";");

var Text QSTA = Part(UserListToNames([QST Team]), 1, ";"); 
var Text QSTB = Part(UserListToNames([QST Team]), 2, ";");
var Text QSTC = Part(UserListToNames([QST Team]), 3, ";");
var Text QSTD = Part(UserListToNames([QST Team]), 4, ";");
var Text QSTE = Part(UserListToNames([QST Team]), 3, ";");
var Text QSTF = Part(UserListToNames([QST Team]), 4, ";");

var Text OPA = Part(UserListToNames([Operations Team]), 1, ";"); 
var Text OPB = Part(UserListToNames([Operations Team]), 2, ";");
var Text OPC = Part(UserListToNames([Operations Team]), 3, ";");
var Text OPD = Part(UserListToNames([Operations Team]), 4, ";");
var Text OPE = Part(UserListToNames([Operations Team]), 5, ";");
var Text OPF = Part(UserListToNames([Operations Team]), 6, ";");
var Text OPG = Part(UserListToNames([Operations Team]), 7, ";");
var Text OPH = Part(UserListToNames([Operations Team]), 8, ";");

var Text WA = Part(UserListToNames([Welding Team]), 1, ";"); 
var Text WB = Part(UserListToNames([Welding Team]), 2, ";");
var Text WC = Part(UserListToNames([Welding Team]), 3, ";");
var Text WD = Part(UserListToNames([Welding Team]), 4, ";");

var Text CA = Part(UserListToNames([Coating Team]), 1, ";"); 
var Text CB = Part(UserListToNames([Coating Team]), 2, ";");
var Text CC = Part(UserListToNames([Coating Team]), 3, ";");
var Text CD = Part(UserListToNames([Coating Team]), 4, ";");

var Text HRA = Part(UserListToNames([HR Team]), 1, ";"); 
var Text HRB = Part(UserListToNames([HR Team]), 2, ";");
var Text HRC = Part(UserListToNames([HR Team]), 3, ";");
var Text HRD = Part(UserListToNames([HR Team]), 4, ";");

var Text PA = Part(UserListToNames([Purchasing Team]), 1, ";"); 
var Text PB = Part(UserListToNames([Purchasing Team]), 2, ";");
var Text PC = Part(UserListToNames([Purchasing Team]), 3, ";");
var Text PD = Part(UserListToNames([Purchasing Team]), 4, ";");

var Text MA = Part(UserListToNames([Materials Team]), 1, ";"); 
var Text MB = Part(UserListToNames([Materials Team]), 2, ";");
var Text MC = Part(UserListToNames([Materials Team]), 3, ";");
var Text MD = Part(UserListToNames([Materials Team]), 4, ";");

var Text EA = Part(UserListToNames([Engineering Team]), 1, ";"); 
var Text EB = Part(UserListToNames([Engineering Team]), 2, ";");
var Text EC = Part(UserListToNames([Engineering Team]), 3, ";");
var Text ED = Part(UserListToNames([Engineering Team]), 4, ";");

var Text NDTA = Part(UserListToNames([NDT Team]), 1, ";"); 
var Text NDTB = Part(UserListToNames([NDT Team]), 2, ";");
var Text NDTC = Part(UserListToNames([NDT Team]), 3, ";");
var Text NDTD = Part(UserListToNames([NDT 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) &
If (not Contains([Quality Approval], $QTE & "] Approved") and not Contains([Quality Approval], $QTE & "] Rejected"), $QTE) &
If (not Contains([Quality Approval], $QTF & "] Approved") and not Contains([Quality Approval], $QTF & "] Rejected"), $QTF) &
If (not Contains([Quality Approval], $QTG & "] Approved") and not Contains([Quality Approval], $QTG & "] Rejected"), $QTG) &
If (not Contains([Quality Approval], $QTH & "] Approved") and not Contains([Quality Approval], $QTH & "] Rejected"), $QTH) &
If (not Contains([Quality Approval], $QTI & "] Approved") and not Contains([Quality Approval], $QTI & "] Rejected"), $QTI) &
If (not Contains([Quality Approval], $QTJ & "] Approved") and not Contains([Quality Approval], $QTJ & "] Rejected"), $QTJ) &

If (not Contains([CA Approval], $CAA & "] Approved") and not Contains([CA Approval], $CAA & "] Rejected"), $CAA) &
If (not Contains([CA Approval], $CAB & "] Approved") and not Contains([CA Approval], $CAB & "] Rejected"), $CAB) &
If (not Contains([CA Approval], $CAC & "] Approved") and not Contains([CA Approval], $CAC & "] Rejected"), $CAC) &
If (not Contains([CA Approval], $CAD & "] Approved") and not Contains([CA Approval], $CAD & "] Rejected"), $CAD) &

If (not Contains([QST Approval], $QSTA & "] Approved") and not Contains([QST Approval], $QSTA & "] Rejected"), $QSTA) &
If (not Contains([QST Approval], $QSTB & "] Approved") and not Contains([QST Approval], $QSTB & "] Rejected"), $QSTB) &
If (not Contains([QST Approval], $QSTC & "] Approved") and not Contains([QST Approval], $QSTC & "] Rejected"), $QSTC) &
If (not Contains([QST Approval], $QSTD & "] Approved") and not Contains([QST Approval], $QSTD & "] Rejected"), $QSTD) &
If (not Contains([QST Approval], $QSTE & "] Approved") and not Contains([QST Approval], $QSTE & "] Rejected"), $QSTE) &
If (not Contains([QST Approval], $QSTF & "] Approved") and not Contains([QST Approval], $QSTF & "] Rejected"), $QSTF) &


If (not Contains([Operations Approval], $OPA & "] Approved") and not Contains([Operations Approval], $OPA &"] Rejected"), $OPA) &
If (not Contains([Operations Approval], $OPB & "] Approved") and not Contains([Operations Approval], $OPB &"] Rejected"), $OPB) &
If (not Contains([Operations Approval], $OPC & "] Approved") and not Contains([Operations Approval], $OPC &"] Rejected"), $OPC) &
If (not Contains([Operations Approval], $OPD & "] Approved") and not Contains([Operations Approval], $OPD &"] Rejected"), $OPD) &
If (not Contains([Operations Approval], $OPE & "] Approved") and not Contains([Operations Approval], $OPE &"] Rejected"), $OPE) &
If (not Contains([Operations Approval], $OPF & "] Approved") and not Contains([Operations Approval], $OPF &"] Rejected"), $OPF) &
If (not Contains([Operations Approval], $OPG & "] Approved") and not Contains([Operations Approval], $OPG &"] Rejected"), $OPG) &
If (not Contains([Operations Approval], $OPH & "] Approved") and not Contains([Operations Approval], $OPH &"] Rejected"), $OPH) &

If (not Contains([Welding Approval], $WA & "] Approved") and not Contains([Welding Approval], $WA & "] Rejected"), $WA) &
If (not Contains([Welding Approval], $WB & "] Approved") and not Contains([Welding Approval], $WB & "] Rejected"), $WB) &
If (not Contains([Welding Approval], $WC & "] Approved") and not Contains([Welding Approval], $WC & "] Rejected"), $WC) &
If (not Contains([Welding Approval], $WD & "] Approved") and not Contains([Welding Approval], $WD & "] Rejected"), $WD) &


If (not Contains([Coating Approval], $CA & "] Approved") and not Contains([Coating Approval], $CA & "] Rejected"), $CA) &
If (not Contains([Coating Approval], $CB & "] Approved") and not Contains([Coating Approval], $CB & "] Rejected"), $CB) &
If (not Contains([Coating Approval], $CC & "] Approved") and not Contains([Coating Approval], $CC & "] Rejected"), $CC) &
If (not Contains([Coating Approval], $CD & "] Approved") and not Contains([Coating Approval], $CD & "] Rejected"), $CD) &

If (not Contains([HR Approval], $HRA & "] Approved") and not Contains([HR Approval], $HRA & "] Rejected"), $HRA) &
If (not Contains([HR Approval], $HRB & "] Approved") and not Contains([HR Approval], $HRB & "] Rejected"), $HRB) &
If (not Contains([HR Approval], $HRC & "] Approved") and not Contains([HR Approval], $HRC & "] Rejected"), $HRC) &
If (not Contains([HR Approval], $HRD & "] Approved") and not Contains([HR Approval], $HRD & "] Rejected"), $HRD) &

If (not Contains([Purchasing Approval], $PA & "] Approved") and not Contains([Purchasing Approval], $PA & "] Rejected"), $PA) &
If (not Contains([Purchasing Approval], $PB & "] Approved") and not Contains([Purchasing Approval], $PB & "] Rejected"), $PB) &
If (not Contains([Purchasing Approval], $PC & "] Approved") and not Contains([Purchasing Approval], $PC & "] Rejected"), $PC) &
If (not Contains([Purchasing Approval], $PD & "] Approved") and not Contains([Purchasing Approval], $PD & "] Rejected"), $PD) &

If (not Contains([Materials Approval], $MA & "] Approved") and not Contains([Materials Approval], $MA & "] Rejected"), $MA) &
If (not Contains([Materials Approval], $MB & "] Approved") and not Contains([Materials Approval], $MB & "] Rejected"), $MB) &
If (not Contains([Materials Approval], $MC & "] Approved") and not Contains([Materials Approval], $MC & "] Rejected"), $MC) &
If (not Contains([Materials Approval], $MD & "] Approved") and not Contains([Materials Approval], $MD & "] Rejected"), $MD) &

If (not Contains([NDT Approval], $NDTA & "] Approved") and not Contains([NDT Approval], $NDTA & "] Rejected"), $NDTA) &
If (not Contains([NDT Approval], $NDTB & "] Approved") and not Contains([NDT Approval], $NDTB & "] Rejected"), $NDTB) &
If (not Contains([NDT Approval], $NDTC & "] Approved") and not Contains([NDT Approval], $NDTC & "] Rejected"), $NDTC) &
If (not Contains([NDT Approval], $NDTD & "] Approved") and not Contains([NDT Approval], $NDTD & "] Rejected"), $NDTD) &

If (not Contains([Engineering Approval], $EA & "] Approved") and not Contains([Engineering Approval], $EA & "] Rejected"), $EA) &
If (not Contains([Engineering Approval], $EB & "] Approved") and not Contains([Engineering Approval], $EB & "] Rejected"), $EB) &
If (not Contains([Engineering Approval], $EC & "] Approved") and not Contains([Engineering Approval], $EC & "] Rejected"), $EC) &
If (not Contains([Engineering Approval], $ED & "] Approved") and not Contains([Engineering Approval], $ED & "] Rejected"), $ED)
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,166 Points 50k badge 2x thumb
OK, now I can read the formula, but I do not see where you have used the List function.
Photo of Sarah Bunten

Sarah Bunten

  • 664 Points 500 badge 2x thumb
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, ";");

var Text CAA = Part(UserListToNames([CA Team]), 1, ";"); 
var Text CAB = Part(UserListToNames([CA Team]), 2, ";");
var Text CAC = Part(UserListToNames([CA Team]), 3, ";");
var Text CAD = Part(UserListToNames([CA Team]), 4, ";");

var Text QSTA = Part(UserListToNames([QST Team]), 1, ";"); 
var Text QSTB = Part(UserListToNames([QST Team]), 2, ";");
var Text QSTC = Part(UserListToNames([QST Team]), 3, ";");
var Text QSTD = Part(UserListToNames([QST Team]), 4, ";");
var Text QSTE = Part(UserListToNames([QST Team]), 3, ";");
var Text QSTF = Part(UserListToNames([QST Team]), 4, ";");

var Text OPA = Part(UserListToNames([Operations Team]), 1, ";"); 
var Text OPB = Part(UserListToNames([Operations Team]), 2, ";");
var Text OPC = Part(UserListToNames([Operations Team]), 3, ";");
var Text OPD = Part(UserListToNames([Operations Team]), 4, ";");
var Text OPE = Part(UserListToNames([Operations Team]), 5, ";");
var Text OPF = Part(UserListToNames([Operations Team]), 6, ";");
var Text OPG = Part(UserListToNames([Operations Team]), 7, ";");
var Text OPH = Part(UserListToNames([Operations Team]), 8, ";");

var Text WA = Part(UserListToNames([Welding Team]), 1, ";"); 
var Text WB = Part(UserListToNames([Welding Team]), 2, ";");
var Text WC = Part(UserListToNames([Welding Team]), 3, ";");
var Text WD = Part(UserListToNames([Welding Team]), 4, ";");

var Text CA = Part(UserListToNames([Coating Team]), 1, ";"); 
var Text CB = Part(UserListToNames([Coating Team]), 2, ";");
var Text CC = Part(UserListToNames([Coating Team]), 3, ";");
var Text CD = Part(UserListToNames([Coating Team]), 4, ";");

var Text HRA = Part(UserListToNames([HR Team]), 1, ";"); 
var Text HRB = Part(UserListToNames([HR Team]), 2, ";");
var Text HRC = Part(UserListToNames([HR Team]), 3, ";");
var Text HRD = Part(UserListToNames([HR Team]), 4, ";");

var Text PA = Part(UserListToNames([Purchasing Team]), 1, ";"); 
var Text PB = Part(UserListToNames([Purchasing Team]), 2, ";");
var Text PC = Part(UserListToNames([Purchasing Team]), 3, ";");
var Text PD = Part(UserListToNames([Purchasing Team]), 4, ";");

var Text MA = Part(UserListToNames([Materials Team]), 1, ";"); 
var Text MB = Part(UserListToNames([Materials Team]), 2, ";");
var Text MC = Part(UserListToNames([Materials Team]), 3, ";");
var Text MD = Part(UserListToNames([Materials Team]), 4, ";");

var Text EA = Part(UserListToNames([Engineering Team]), 1, ";"); 
var Text EB = Part(UserListToNames([Engineering Team]), 2, ";");
var Text EC = Part(UserListToNames([Engineering Team]), 3, ";");
var Text ED = Part(UserListToNames([Engineering Team]), 4, ";");

var Text NDTA = Part(UserListToNames([NDT Team]), 1, ";"); 
var Text NDTB = Part(UserListToNames([NDT Team]), 2, ";");
var Text NDTC = Part(UserListToNames([NDT Team]), 3, ";");
var Text NDTD = Part(UserListToNames([NDT Team]), 4, ";");

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

If (not Contains([CA Approval], $CAA & "] Approved") and not Contains([CA Approval], $CAA & "] Rejected"), $CAA) &
If (not Contains([CA Approval], $CAB & "] Approved") and not Contains([CA Approval], $CAB & "] Rejected"), $CAB) &
If (not Contains([CA Approval], $CAC & "] Approved") and not Contains([CA Approval], $CAC & "] Rejected"), $CAC) &
If (not Contains([CA Approval], $CAD & "] Approved") and not Contains([CA Approval], $CAD & "] Rejected"), $CAD) &

If (not Contains([QST Approval], $QSTA & "] Approved") and not Contains([QST Approval], $QSTA & "] Rejected"), $QSTA) &
If (not Contains([QST Approval], $QSTB & "] Approved") and not Contains([QST Approval], $QSTB & "] Rejected"), $QSTB) &
If (not Contains([QST Approval], $QSTC & "] Approved") and not Contains([QST Approval], $QSTC & "] Rejected"), $QSTC) &
If (not Contains([QST Approval], $QSTD & "] Approved") and not Contains([QST Approval], $QSTD & "] Rejected"), $QSTD) &
If (not Contains([QST Approval], $QSTE & "] Approved") and not Contains([QST Approval], $QSTE & "] Rejected"), $QSTE) &
If (not Contains([QST Approval], $QSTF & "] Approved") and not Contains([QST Approval], $QSTF & "] Rejected"), $QSTF) &


If (not Contains([Operations Approval], $OPA & "] Approved") and not Contains([Operations Approval], $OPA &"] Rejected"), $OPA) &
If (not Contains([Operations Approval], $OPB & "] Approved") and not Contains([Operations Approval], $OPB &"] Rejected"), $OPB) &
If (not Contains([Operations Approval], $OPC & "] Approved") and not Contains([Operations Approval], $OPC &"] Rejected"), $OPC) &
If (not Contains([Operations Approval], $OPD & "] Approved") and not Contains([Operations Approval], $OPD &"] Rejected"), $OPD) &
If (not Contains([Operations Approval], $OPE & "] Approved") and not Contains([Operations Approval], $OPE &"] Rejected"), $OPE) &
If (not Contains([Operations Approval], $OPF & "] Approved") and not Contains([Operations Approval], $OPF &"] Rejected"), $OPF) &
If (not Contains([Operations Approval], $OPG & "] Approved") and not Contains([Operations Approval], $OPG &"] Rejected"), $OPG) &
If (not Contains([Operations Approval], $OPH & "] Approved") and not Contains([Operations Approval], $OPH &"] Rejected"), $OPH) &

If (not Contains([Welding Approval], $WA & "] Approved") and not Contains([Welding Approval], $WA & "] Rejected"), $WA) &
If (not Contains([Welding Approval], $WB & "] Approved") and not Contains([Welding Approval], $WB & "] Rejected"), $WB) &
If (not Contains([Welding Approval], $WC & "] Approved") and not Contains([Welding Approval], $WC & "] Rejected"), $WC) &
If (not Contains([Welding Approval], $WD & "] Approved") and not Contains([Welding Approval], $WD & "] Rejected"), $WD) &


If (not Contains([Coating Approval], $CA & "] Approved") and not Contains([Coating Approval], $CA & "] Rejected"), $CA) &
If (not Contains([Coating Approval], $CB & "] Approved") and not Contains([Coating Approval], $CB & "] Rejected"), $CB) &
If (not Contains([Coating Approval], $CC & "] Approved") and not Contains([Coating Approval], $CC & "] Rejected"), $CC) &
If (not Contains([Coating Approval], $CD & "] Approved") and not Contains([Coating Approval], $CD & "] Rejected"), $CD) &

If (not Contains([HR Approval], $HRA & "] Approved") and not Contains([HR Approval], $HRA & "] Rejected"), $HRA) &
If (not Contains([HR Approval], $HRB & "] Approved") and not Contains([HR Approval], $HRB & "] Rejected"), $HRB) &
If (not Contains([HR Approval], $HRC & "] Approved") and not Contains([HR Approval], $HRC & "] Rejected"), $HRC) &
If (not Contains([HR Approval], $HRD & "] Approved") and not Contains([HR Approval], $HRD & "] Rejected"), $HRD) &

If (not Contains([Purchasing Approval], $PA & "] Approved") and not Contains([Purchasing Approval], $PA & "] Rejected"), $PA) &
If (not Contains([Purchasing Approval], $PB & "] Approved") and not Contains([Purchasing Approval], $PB & "] Rejected"), $PB) &
If (not Contains([Purchasing Approval], $PC & "] Approved") and not Contains([Purchasing Approval], $PC & "] Rejected"), $PC) &
If (not Contains([Purchasing Approval], $PD & "] Approved") and not Contains([Purchasing Approval], $PD & "] Rejected"), $PD) &

If (not Contains([Materials Approval], $MA & "] Approved") and not Contains([Materials Approval], $MA & "] Rejected"), $MA) &
If (not Contains([Materials Approval], $MB & "] Approved") and not Contains([Materials Approval], $MB & "] Rejected"), $MB) &
If (not Contains([Materials Approval], $MC & "] Approved") and not Contains([Materials Approval], $MC & "] Rejected"), $MC) &
If (not Contains([Materials Approval], $MD & "] Approved") and not Contains([Materials Approval], $MD & "] Rejected"), $MD) &

If (not Contains([NDT Approval], $NDTA & "] Approved") and not Contains([NDT Approval], $NDTA & "] Rejected"), $NDTA) &
If (not Contains([NDT Approval], $NDTB & "] Approved") and not Contains([NDT Approval], $NDTB & "] Rejected"), $NDTB) &
If (not Contains([NDT Approval], $NDTC & "] Approved") and not Contains([NDT Approval], $NDTC & "] Rejected"), $NDTC) &
If (not Contains([NDT Approval], $NDTD & "] Approved") and not Contains([NDT Approval], $NDTD & "] Rejected"), $NDTD) &

If (not Contains([Engineering Approval], $EA & "] Approved") and not Contains([Engineering Approval], $EA & "] Rejected"), $EA) &
If (not Contains([Engineering Approval], $EB & "] Approved") and not Contains([Engineering Approval], $EB & "] Rejected"), $EB) &
If (not Contains([Engineering Approval], $EC & "] Approved") and not Contains([Engineering Approval], $EC & "] Rejected"), $EC) &
If (not Contains([Engineering Approval], $ED & "] Approved") and not Contains([Engineering Approval], $ED & "] Rejected"), $ED)

)
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 26,352 Points 20k badge 2x thumb
That's a lot of no code, low code
Interesting article that begrudgingly recognizes the need for code:

Do you really need developers to build applications?
"It's not at all low-code." - Quick Base CEO Rick Willet
http://www.zdnet.com/article/do-you-really-need-developers-to-build-applications/
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,166 Points 50k badge 2x thumb
The individual elements of the List need to be separated with a comma and not an &

see the comma at the end of each line





List("; ",
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) ,
Photo of Sarah Bunten

Sarah Bunten

  • 664 Points 500 badge 2x thumb
Great!  Thanks!