Hello
I was playing around a bit and did this with l expression to prioritize my 5 codes that I'm looking for:
{if(tArray_5>0 and tArray_7>0 and tArray_8>0 and tArray_13>0 and tArray_15>0, join(if(tArray_5>0,"E",""),if(tArray_7>0,"G",""),if(tArray_8>0,"H",""),if(tArray_13>0,"M",""),if(tArray_15>0,"O","")),join(if(tArray_1>0,"A",""),if(tArray_2>0,"B",""),if(tArray_3>0,"C",""),if(tArray_4>0,"D",""),if(tArray_6>0,"F",""),if(tArray_9>0,"I",""),if(tArray_10>0,"J",""),if(tArray_11>0,"K",""),if(tArray_12>0,"L",""),if(tArray_14>0,"N",""),if(tArray_16>0,"P",""),if(tArray_17>0,"Q",""),if(tArray_18>0,"R",""),if(tArray_19>0,"S",""),if(tArray_20>0,"T",""),if(tArray_21>0,"U",""),if(tArray_22>0,"V",""),if(tArray_23>0,"W",""),if(tArray_24>0,"X",""),if(tArray_25>0,"Y",""),if(tArray_26>0,"Z",""),if(tArray_27>0,"1",""),if(tArray_28>0,"2",""),if(tArray_29>0,"3",""),if(tArray_30>0,"4",""),if(tArray_31>0,"5",""),if(tArray_32>0,"6",""),if(tArray_33>0,"7","")))}
And if it does it to me, however, this means that if I enter several codes including these 5, it only calculates the 5.
What I'm really looking for is to ask for 6 products, giving priority to the 5 codes. If you selected 2 codes, we first ask those 2 and another 4 additional ones that are not priority.
If you did not select any of the codes in any of the 14 scenarios, then their substitutes are applied to 6 products.
I hope if anyone has any other ideas.
Greetings,