hello,
Thank you so much for sharing this helpful information, it helped me alot
Thanks and regards. 9apps cartoonhd
Announcement
Collapse
No announcement yet.
how to configure formula for date format "Quartal"?
Collapse
X
-
Hi Maximus!
great advice, now it works as a first step.
The output in field "quartal" is for example "3".
I need "3. Quartal 2020"
So now I added string\concatenate in this way:
quartal = string\concatenate
(number\floor(
datetime\month(
entity\attribute('datum')
) / 4
) + 1,'. Quartal ','year');
The result:
"3. Quartal year"
I need "3. Quartal 2020"
Is there a way to do it?
Thank you!
Leave a comment:
-
Code:$quarter = number\floor( datetime\month( entity\attribute('datum') ) / 4 ) + 1; $quarterString = string\concatenate( $quarter, '. Quartal ', datetime\year( entity\attribute('datum') ) ); entity\setAttribute('quartal', $quarterString);
Last edited by yuri; 09-16-2020, 08:59 AM.
- Likes 1
Leave a comment:
-
Hi gustav,
in formula 'entity\attribute()' you don't need to replace 'entity' with 'EigenkontrolleBrandschutztueren'. It is constant value, so it should be as in the Yuri's example.
Also, replace '$quartal' with 'quartal' in ypur formulaLast edited by Maximus; 09-16-2020, 08:45 AM.
Leave a comment:
-
Hello yurikuzn!
appreciate your suggestion of a code!
So what I am doing:
Code:
$quartal = number\floor(
datetime\month(
EigenkontrolleBrandschutztueren\attribute('datum')
)
) + 1;
EigenkontrolleBrandschutztueren = custom entity
quartal = vachar field in entity EigenkontrolleBrandschutztueren
datum = date field in entity EigenkontrolleBrandschutztueren where the user enters the date
I dont know what in this case attribute is, I took the field name again "quartal"
Unfortunately does not work!Last edited by gustavgraz; 09-16-2020, 08:22 AM.
Leave a comment:
-
how to configure formula for date format "Quartal"?
Advanced Pack 2.5.14
EspoCRM Version 5.9.3
Hello!
I am building a custom entity where I need a "quarterly" date format.
So if the record has a date field 25.02.2020, there shall be a second date field which is autofilled with "1. Quartal 2020"
I think that this feature should be realised with a formula in the custom entity. But I am not good enough in formulas...
something like:
if field "date" is between 01.01.2020 and 30.03.2020 then field "quartal" is "1. Quartal 2020"
and
if field "date" is between 01.04.2020 and 30.06.2020 then field "quartal" is "2. Quartal 2020"
and
if field "date" is between 01.07.2020 and 30.09.2020 then field "quartal" is "3. Quartal 2020"
and
if field "date" is between 01.10.2020 and 31.12.2020 then field "quartal" is "4. Quartal 2020"
How can this be formulated in a correct working way?
Thank you!1 PhotoTags: None
Leave a comment: