Help needed with calendar events / tasks with colors depending on the status

[yuri]

Did you create new events? This should apply to new events, not existing ones, as the formula script runs only when create/edit records.

You can run re-calculate formula from the list view > select all results > actions to apply the script for all records.

[geonaute]

Hi geonaute

Formula should something like below, when a task status is changed then we need to update the color field:

ifThen(entity\isAttributeChanged('status'),
ifThen(status === "Not Started", entity\setAttribute('color', '#6fa8d6'));
ifThen(status === "Started", entity\setAttribute('color', '#edc555'));
ifThen(status === "Completed", entity\setAttribute('color', '#7cc4a4'));
ifThen(status === "Cancelled", entity\setAttribute('color', '#ed8f42'));
ifThen(status === "Deferred", entity\setAttribute('color', '#d4729b'));
)

Hope this helps

Hi Rabii, Thank you for your assistance regarding my challenge with the calendar.

I have tried to make the steps advised by Yuri and you but I did not have any sucess.

I am missing something in here.

1- I created the new varchar field for my "event" with the name color. (Please see picture attached.

2-- I wrote on the formula field your formula, but when entering the calendar, nothing changed.

Any ideas which step I am doing wrong?

Thanks

[rabii]

Hi geonaute

Formula should something like below, when a task status is changed then we need to update the color field:

ifThen(entity\isAttributeChanged('status'),
ifThen(status === "Not Started", entity\setAttribute('color', '#6fa8d6'));
ifThen(status === "Started", entity\setAttribute('color', '#edc555'));
ifThen(status === "Completed", entity\setAttribute('color', '#7cc4a4'));
ifThen(status === "Cancelled", entity\setAttribute('color', '#ed8f42'));
ifThen(status === "Deferred", entity\setAttribute('color', '#d4729b'));
)

Hope this helps

[geonaute]

1. Create a new varchar field for Task with the name 'color'.
2. Write formula that sets a HEX value to the 'color' attribute, depending on the 'status'.

Hi Yuri,

Do you have an example of that formula? I am newbie eager to learn some more.

Thank you

[yuri]

1. Create a new varchar field for Task with the name 'color'.
2. Write formula that sets a HEX value to the 'color' attribute, depending on the 'status'.

[geonaute]

Simple experiment with returning color

Hi dimyy,
Thank you for answering my question.
I will try this one out troughout the weekend and leave a feedback.

This looks promising

[dimyy]

Simple experiment with returning color

[dimyy]

Espo use fullCalendar v. 3 (https://fullcalendar.io/docs/v3/event-object)

As I see in source code you can pass event color.

[geonaute]

Hi EspoCrm lovers,

I am trying to find some advise or guidance for the following challenge.

On my EspoCrm I am using a lot the calendar option and events to have an internal booking system. The platform provides me almost all the details I need, and this was one of the main points I opted for EspoCrm. The possibility to edit the events / tasks on the calendar.
However I came to the situation where I would need to have the events / tasks being able to be colored like the Kanban Views.

The case is that I have the following options for the events / tasks ( Planned, Confirmed, On Hold, Canceled, Completed).
It would be amazing to see them on the calendar with specific colors for each event / tasks.


Please see attached pictures with my Kanban View and my calendar view, to give a better idea of my need.

Thank you