For each array value?

[Russ]

Hi, sorry for this basic question, I guess I couldn't find in the documentation.

How do can I create a formula that will check the array of id's, and based on that array post into text fields a list of urls?

Array example: 1,2,3

Text field example:

http://domain.com/?id=1

http://domain.com/?id=2

http://domain.com/?id=3

Thanks

[dimyy]

Use loop "while" for iterrate throw array
For example:

$i = 0;
$blocks = list('1','2','3');

while ($i < array\length($blocks)) {
    print(array\at($blocks, $i));
    $i = $i+1;
}
​

https://docs.espocrm.com/administration/formula/#while

https://docs.espocrm.com/administration/formula/array/

If you need split string use https://docs.espocrm.com/administrat...g/#stringsplit

[Russ]

Use loop "while" for iterrate throw array
For example:

$i = 0;
$blocks = list('1','2','3');

while ($i < array\length($blocks)) {
print(array\at($blocks, $i));
$i = $i+1;
}
​

https://docs.espocrm.com/administration/formula/#while

https://docs.espocrm.com/administration/formula/array/

If you need split string use https://docs.espocrm.com/administrat...g/#stringsplit

thanks

[esforim]

thanks

Hi Russ, can you assist? How do you get the array ID to work?

$blocks = list('1','2','3');

No problem if you do it like this, but the moment I add in the Array field, for example:

$blocks = list(contactsIds);

It doesn't do anything meaningful

[lazovic]

Hi esforim,

Please try to use the following formula script in the Administration > Formula Sandbox (with Account Target Type):

$i = 0;

$contactsIds = record\findRelatedMany('Account', id, 'contacts', 1000);

while ($i < array\length($contactsIds)) {
    output\printLine(array\at($contactsIds, $i));
    $i = $i + 1;
}​

[esforim]

Hi esforim,

Thank you lazovic, I manage to fix it but output\printLine work fine in Sandbox but how would I do use it in an actual formula. I was meant to post this but forgot to Reply.

Finally manage to figure it out, I need to do this:

$blocks = contactsIds;

But the next issue is,

print(array\at($blocks, $i));

This work fine for Sandbox, but how would you do it for Formula? I tried the following but error again.

$i = 0;
$blocks = contactsIds;

while ($i < array\length($blocks)) {
        $test=string\concatenate(
            $i,
        Contact ### ', record\attribute('Contact', array\at($blocks, $i), 'firstName'), '\n',
        record\attribute('Contact', array\at($blocks, $i), 'lastName'), '\n',
                            )
    ;
    $i = $i+1;
}

output\print($test)​

I'm guessing it does not work with String\concatenate?