Note on formula

[peterberlin]

Hallo,

Missing in the list of functions
number\floor & number\ceil functions
lowerCase & upperCase functions

peter

[tanya]

Hello
Not all functions are in list, some of them you can find only in the documentation.

https://www.espocrm.com/documentation/administration/formula/

[esforim]

We can't use these string on Print2PDF Template can we?

[Maximus]

Are you asking about ability to use formula provided by Peter in PDF Template?

Formula is not available for Print2PDF Template. The only one thing you can do with number in PDF Template is utilizing the number formating feature https://docs.espocrm.com/user-guide/...ber-formatting.
Also, you can try to develop a custom helper that allows you to do such things https://docs.espocrm.com/development...custom-helper/.

[esforim]

Thanks Maximus

I was more interested in doing something like this for Print2PDF Template, rather than the number formatting.

string\upperCase(STRING)
string\upperCase(name)

I'm aware I can use Uppercase on Formula (one of my read only formula has used that), but I don't want another Field for the purpose of formula and was hoping it possible to use upperCase directly through Print2PDF.

Planned to do something like this in Print2PDF
{{firstName}} string\uppercase{{lastName}}

Naturally I can create a new field call "uppcasecaselastname", then write a formula for that then in my Print2PDF template I use this special formula field.

[item]

Hello espocrm, Maximus give you the right way .. you can create a custom helper and use it in pdf template like so :


{{upperCase myLowerCaseField}}

The helper will just return : return new LightnCandy\SafeString( strtoupper ( item) );
see the second link of Maximus

or you can direclty create a formula for that field in entityManager

[esforim]

That a new discovery then. Thanks item

Would this code be sufficient to make this work?

<?php

namespace Espo\Custom\TemplateHelpers;

class MyHelper
{
public static function myHelper()
{
$args = func_get_args();
$context = $args[count($args) - 1];
$hash = $context['hash'];
$data = $context['data']['root'];

$value = $args[0] ?? null; // argument

$upper = $hash['upper'] ?? '#EA1'; // option upper='VALUE'

$entityType = $data['__entityType'];

$html = "<span style=\"upper: {$upper};\">" . $value . "</span>";

return new LightnCandy\SafeString( strtoupper ( item) );
}
}

[item]

Hello espocrm,

here my test sample :

and to use so in template : {{ToUpper myField}}

and file is : ToUpper.php

and content is so :

<?php

namespace Espo\Custom\TemplateHelpers;

class ToUpper
{
public static function ToUpper()
{
$args = func_get_args();
// $context = $args[count($args) - 1];  // maybe not util this

$value = $args[0] ?? null; // argument

return new LightnCandy\SafeString( strtoupper ( $value ) );
}
}

Maybe it's more just so to do so : strtoupper ( strtolower ( $value ) )

Not tried but would work .. and not forget the other file json .. see link of maximus

[esforim]

Thank you. Giving it a try soon and will report back.