concatenate array (enum) and string

[shalmaxb]

Is it possible to use the formula string\concatenate to join multi enum and text field values?

[espcrm]

Doubt it if you asking this question (I assume you must have tried). Only thing I can think of (have not test) is to cheat. You know how Print2PDF can use {each} {/each}, perhaps it might work with Formula as well?

[item]

look https://docs.espocrm.com/administration/formula/#list , while, and concat

[shalmaxb]

Hi,
item, I already considered that, but what would be the values? list(VALUE-1, ... VALUE-N), will I use some Id`s, from where do I achieve them, will I have to use the actual values of all the enum values as string??

The following while condition I don`t understand.

$source = list(0, 1, 2);
$target = list();
$i = 0;
while($i < array\length($source), $target = array\push( $target, array\at($source, $i) );
$i = $i + 1; );

The documentation is very difficult to understand, for whom never did that before. Lot of guessing.

[yuri]

Using formula requires some programming skills, except when the logic is very simple.

'list' function instantiates an array by given values.

There's no join function at the moment. I suggest adding a custom function. See https://docs.espocrm.com/development...on-in-formula/


custom/Espo/Custom/Core/Formula/Functions/MyGroup/MyJoinType.php

<?php
namespace Espo\Custom\Core\Formula\Functions\MyGroup;

class MyJoinType extends \Espo\Core\Formula\Functions\Base
{
    public function process(\StdClass $item)
    {
        $args = $this->fetchArguments($item);

        return implode($args[1], $args[0]);
    }
}

`custom/Espo/Custom/Resources/metadata/app/formula.json`

{
    "functionClassNameMap": {
        "my\\join": "Espo\\Custom\\Core\\Formula\\Functions\\MyGroup\\MyJoinType"
    }
}

Then use:

$joinedString = my\join($array, ', ');

[shalmaxb]

yuri , thank you, I will try, but I think it will be beyond my skills in coding (if there are some at all)

[espcrm]

I saw this issue, I think yuri made it possible in v6.2?
Formula: array\join function #1917

https://github.com/espocrm/espocrm/issues/1917

[shalmaxb]

yuri and espcrm the new formula in 6.1.3 works perfectly. Thank you.

[espcrm]

That good to hear, did you manually patched that code in? I initially thought it was v6.2 but looking at it again it listed as v6.1.3 instead

In the end how does formula look in the end? One that is a "live working example".

[shalmaxb]

espcrm , yes it has been implemented in 6.1.3 and my formula outputs all values from an enum field this way:

my target field = legendeTechnik, is a plain textfield, that should show all values of an existing enum field named "technik" in one comma separated field.

Formula:

legendeTechnik=array\join(technik, ', ');

Be aware, that after the comma itself there is a space to line up the values with a space after the comma. The result looks like this:

technik1, technik2, technik3, ....

Further on you may e.g. concatenate this new text field with other fields as usual.

[espcrm]

Mr shalmaxb looking at the date wow! 2 and half year later I'm finally playing to your level.

How do you create new lines for each of the technik1, technik2, technik3, .... result?

For example, right now it showing as technik1, technik2, technik3, ....

I want it as

technik1
technik2
technik3, ....

[espcrm]

Update; and thinking on my feet, I got this. So here is the solution:

output\printLine(array\join($nameArray, '\n'))

[shalmaxb]

that`s right '\n' for line break. And in case you need to print this in PDF, here is the solution to escape: https://forum.espocrm.com/forum/gene...4187#post94187

[espcrm]

shalmaxb While we are on this topic, do you ever have to do something like this? I don't know how your technik field data is structured.

https://forum.espocrm.com/forum/general/94750-espocrm-regex-type

It because of these array result that I need to separated them into their "category". Currently I'm making everyone in the same group so it doesn't work too well, instead of separate them into their group such as "Buyer" and "Seller".

Now it just
technik1
technik2
technik3

Instead of something like
Buyer:
technik

Seller:
technik2
technik3

Do you play regex often?

[shalmaxb]

I never worked with regex so far, because I did not need. And honestly it is quite a mystery for me.

[espcrm]

Hmm maybe one day. Hopefully by then I'm more fluent and I can help you instead!