help with a syntax formula

[abidoss]

Hello friends, please, I need to update this record (formationsIds = typeFormation.formationsIds ) but with the following condition: if the (formationsNames) contains the term "Valide."

[abidoss]

I tried that, but it doesn't work
ifThen(formationsNames == string\contains(formationsNames, 'Valide'), entity\setAttribute('formationsIds', typeFormation.formationsIds));

[rabii]

That would not work string/contains search in a string and formationsNames is an array. If valide is a name of the formation record you can try code below:

if (array\length(formationsIds) > 0) {
    
    $i = 0;
    
    while($i < array\length(formationsIds)) {
        $name = record\attribute('Formation', array\at(formationsIds, $i), 'name');
        
        if (string\contains($name, 'Valide')) {
            
            entity\addLinkMultipleId('formations', array\at(formationsIds, $i));
        }
        
        $i = $i + 1;
    }
}​ 

[abidoss]

Hello Rabii, thank you for your help. Indeed, your code found the 3 records, but it didn't manage to find one with the name "valide".

[abidoss]

I tried that too.

if (array\length(classe.formationsIds) > 0) {
    
    $i = 0;
    
    while($i < array\length(classe.formationsIds)) {
        $name = record\attribute('Formations', array\at(classe.formationsIds, $i), 'name');
        
        if (string\contains($name, 'Valide')) {
            entity\setAttribute('Meeting', $i);
        }
        $i = $i + 1;
    }
} 

My idea here is to only join the training sessions that contain the word 'Valid' in the 'Meeting' recording.

[rabii]

I need to know what are the entities involved and relationship between them for me to help. which entity is the target entity etc?

[rabii]

Hello Rabii, thank you for your help. Indeed, your code found the 3 records, but it didn't manage to find one with the name "valide".

$name = record\attribute('Formations', array\at(classe.formationsIds, $i), 'name'); 

Formations ??? it should be single - name of the entity should be always single.