Issue with trigger conditions in 'Liste' Field: Multiple Text conditions not triggering as expected

Fred it’s a text field. In essence, I need to copy a text into this box. Based on the content of the text, it selects the corresponding boxes from "Zertifikate". This way, I get PDFs that appear as certificates to print according to the list. Doing so still leaves the option to manually select the "Zertifikate" boxes as well.

Fred Thank you! It took me a while to understand the formula. I changed a couple of things. Within the "Allegati" table, I created a text field "Keyword". This field contains keywords separated by commas. Based on the words contained in this "Keyword" field, the formula should search for matches. The formula has been modified and adapted and seems to work, but it still applies the logic only to the first match and not to the subsequent ones.

let getAllegatiRec := (select Allegati where Aktiv = 1);
let makeArray := split(Liste, ", ");
let getSelectedAllegatiRecs := for loop1 in makeArray do
        getAllegatiRec[contains(Keyword, loop1)]
    end;
Zertifikate := getSelectedAllegatiRecs

Fred 

It's a simple text field that contains keywords. If any of these words match with a word in the text field 'Liste', it has to flag the corresponding field in the dMC 'Zertifikate'. It works but only for the first match

Fred 

Fred It works with more then one match? Can you paste the code? Something has to be different in your code

Fred Here I am! There have been several complications regarding the check for possible matches between the "List" field and the "Keyword" field. The first issue was that it wasn't working because the Keywords were not separated by commas, and in the "List" field, there were also no commas. This is why it stopped at the first match. Consequently, being article codes, I preferred to create a table called "Table1" with the respective codes in the "Art." field instead of the "Keyword" field. Then there was another problem because some codes matched the text in the "List" but continued with **A, **B, etc., for an internal matter. Therefore, it did not recognize the codes. The final and perfectly working code is the folowing. Thanks a lot for your help :)

let getAllegatiRec := (select Allegati where Aktiv = 1);
let replacedListe := replacex(Liste, " ", ",");
let makeArray := split(replacedListe, ",");
let getSelectedAllegatiRecs := for loop1 in makeArray do
        if contains(loop1, "**") and length(loop1) > 3 then
            let baseCode := substring(loop1, 0, length(loop1) - 3);
            let existsInTabella1 := count(select Tabella1 where 'Art.' = baseCode) > 0;
            if existsInTabella1 then
                getAllegatiRec[contains(Tabella1.'Art.', baseCode)]
            else
                null
            end
        else
            let existsInTabella1Direct := count(select Tabella1 where 'Art.' = loop1) > 0;
            if existsInTabella1Direct then
                getAllegatiRec[contains(Tabella1.'Art.', loop1)]
            else
                null
            end
        end
    end;
let filteredAllegatiRecs := for rec in getSelectedAllegatiRecs do
        if rec != null then rec end
    end;
Zertifikate := filteredAllegatiRecs;
Liste := replacedListe