Need a little help - Problem with array\push()

[i-Arbeitsschutz]

Hi there,

I use EspoCRM 9.0.6 with all necessary extensions.

I've got 3 entities ("shelf-inspection V1.0" , "shelf-inspection V.2.0" and "shelves" - from both "shelf-inspections" I need to transfer the entire values of multi-enum fields to an enum-field in "shelves".

This is what I got so far (thanks to THIS POST):

$i=0;
prevInspections = regalinspectionsV1Ids;
while ($i < array\length(regalinspectionsV2Ids),
$secondId = array\at(regalinspectionsV2Ids, $i);
prevInspections = array\push(prevInspections, $secondId);
$i = $i + 1;
);

It works almost perfectly fine, because it merges now the IDs of multi-enum field X of "shelf-inspection V1.0" and multi-enum field Y of "shelf-inspection V2.0" into multi-enum field Z of "shelves" ...

However, I'm completely lost at this point, because I actually want to see the "values" of the multi-enum field, not the ID's (e.g. "I-AS.2025.SLPR.00869" instead of its ID "67e3d6814396a3dbd") ...

What do I have to change /add to make this happen ?!

Would be great to get some help... Thanks a lot

Regards, Martin

[lazovic]

Hi i-Arbeitsschutz,

Please note that there are no IDs for fields. You need to first throw the records IDs into one array, and then get the values of their fields in another array.

Let's look at a simple example. We have one Account, which has several Opportunities. Each Opportunity has a field called Multi-Enum.

To collect and combine all the values of the Multi-Enum fields of the related Opportunities in the formula script for the Account, you need to do the following:

​$oppIds = record\findRelatedMany('Account', id, 'opportunities', 10000);

$i = 0;

$multiEnums = list();
$values = list();

while ($i < array\length($oppIds)) {
    
    $multiEnum = record\attribute('Opportunity', array\at($oppIds, $i), 'multiEnum');
    $multiEnums = array\push($multiEnums, $multiEnum);
    
    $y = 0;
    
    while ($y < array\length($multiEnum)) {
        
        $value = array\at($multiEnum, $y);
        $values = array\push($values, $value);
        
        $y = $y + 1;
    }
    
    $i = $i + 1;
}

The values will be stored in the corresponding $values variable.