Announcement

Collapse
No announcement yet.

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

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • yuri
    replied
    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.

    Leave a comment:


  • geonaute
    replied
    Originally posted by rabii View Post
    Hi geonaute

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

    Code:
    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

    Leave a comment:


  • rabii
    replied
    Hi geonaute

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

    Code:
    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

    Leave a comment:


  • geonaute
    replied
    Originally posted by yuri View Post
    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

    Leave a comment:


  • yuri
    replied
    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'.

    Leave a comment:


  • geonaute
    replied
    Originally posted by dimyy View Post
    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

    Leave a comment:


  • dimyy
    replied
    Simple experiment with returning color
    Attached Files

    Leave a comment:


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

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

    Attached Files

    Leave a comment:


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

    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
Working...
X