Calendar colors

[Aparicio_Pineyr]

Hi!
Is there a way to change the calendar task colors views?
It would be nice to have the chance to customized it as it happened in Charts.

@morgan

[LeventK]

@Aparicio_Pineyrua
In the Calendar UX there is a Category property where you can assign colors to your data with a Color type column

[Aparicio_Pineyr]

I see the Category, but I don’t see where I can select the colors

[LeventK]

@Aparicio_Pineyrua
You need to add a COLOR type column to your table referencing that Calendar UX. It can even be a VC where you can set the task colors with an IFS expression and then assign this column to your Category property.

[Aparicio_Pineyr]

Ok, but how can I add a specific color for each status value?

[LeventK]

@Aparicio_Pineyrua
For example:

SWITCH(
    [Status],
    "Completed", "Green",
    "In-progress", "Orange",
    "Blue"
)

[Aparicio_Pineyr]

Cool thanks!

[LeventK]

You’re welcome Apa.

[dellavecchia]

Hi where exactly can you add that switch in AppSheet in order to color code the calendar entries?

Thanks.

[Nate_Moneypenny]

@LeventK I am getting the color code to show up based on my category when in detail view however that color is not the color of the event in the calendar view. That view is still showing the default colors. As you can see I have applied the color Blue to the Health checkup but it is displaying Red in the Calendar veiw still.

[Zaiyin_Bast]

I am have the same issue; changes the font in the detail, but not in the calendar view. It looks like from the 11/2018 blog release, the ability to change the calendar view color was not an option? Maybe I am still missing something? Thanks for the help!

---

Ref Comment at end of blog entry:
Peter Dykstra
11/5/2018, 11:23:34 AM
Hi Mark - custom formats for your events aren’t available yet, but are in the works!

Reply to Peter Dykstra

---

[Aparicio_Pineyr]

@Peter
I try what @LeventK said and it works in the first calendar adds, but if I enter new ones in a different date time, are not respecting the color formula.

[Bernard_Barbari]

Hey guys! try to create a new table for ‘Status’. Check this out:
Demo

You can change the Color for each status as many as you want. You can also define different names for status values. Have fun.

Notes: It’s easier with google calendar. I have set valid Color values manually in ‘Color’ virtual column. don’t use black or white color (not working - don’t know why)

[Aparicio_Pineyr]

That’s a good solution.
You can also avoid fiscal columns just adding a virtual column in the calenda table with this formula:

IFS(
[Status]=“Contratado”, “Green”,
[Status]=“Email”, “Purple”,
[Status]= “Llamar”, “Yellow”,
[Status]= “Reunión”, “Red”,
[Status]=“Sin Interes”, “Black”,
true,“Blue”
)

[Steve]

Or:

SWITCH(
  [Status],
  “Contratado”, “Green”,
  “Email”, “Purple”,
  “Llamar”, “Yellow”,
  “Reunión”, “Red”,
  “Sin Interes”, “Black”,
  “Blue”
)

[Matthew_Wolman]

Disregard my question about the color legend

[Muzekker_Vatan]

Dear Steve,
I have used your code as below and it is working fine.
SWITCH(
[Flight Status_10],
“Active”, “Green”,
“To be cancelled”, “Yellow”,
“Canceled”, “Red”,
“Blue”
)

Any possible to have two different color based value in another column?
Example;
I have [Has] column as well. Would like to have color as "green" and black for same line if [Flight Status_10]="active" and [has]=engine.
Is it possible? Or can you recommend something different? Would be better to have flight still active in calendar and flight which have also engine.


Thanks in advance.

[Nate_Moneypenny]

Could you show an example with the google calendar. I am thinking about using that instead just because I like that it can add the appointments there from within the app. However I didnt know you could change the color, I thought it just showed what was the default color for that google calendar.

Thank you

[Will_Henry]

This does not seem to work. The correct color is shown in the detail view, so the switch statement is working, but this is not the color shown in the calendar. I am using the color column for the category column in the calendar ux.

[romanus]

I have the same situation with your @Will_Henry, the correct color selected in form and detailed ux but in the calender ux I got the theme color. Any solution?

[ChristianeG]

Does anyone have a solution to this problem? Same here, the right color shows in details but not as the color in calender view. What is shown in red should be blue, turquoise should be orange etc. 

[Tartenpold]

My trick work in every case.

Look at my first message down below.

[ChristianeG]

Got it! Thank you!

[Brandon1]

Has anyone gotten this to work reliably? The sample app from @Bernard_Barbarisi works great. I was able to work with it, change names of various tables (to figure out how the formulas worked), I can make changes to colors, etc. But after trying the same exact strategy in my own app the calendar still displays the wrong colors.

[Bernard_Barbari]

Hi there! I´ve just created a version 2 of the app Calendar-183037. I made some changes in the column structure of Status and Color (Virtural column). Also, in the dashboard you can change event status on detail view and check the color changing on calender view.

Demo Calendar 2

Hope this helps you.

[romanus]

Thank you @Bernard_Barbarisi, I notice the differences from the version 1, it works with the correct colors.

[Odiez]

I want to look inside this app, but it is only for view

[Tartenpold]

Hi!
I tried many things i found in this thread, some where almost good but in fact, none of them work for me. Probably i made many mistakes, BUT, i think i found
THE EASIEST WAY to apply one precise color to one precise event type (for exemple).

1. First, you need to understand that, there's only 10 colours avaibles for differencing events in calendar.
   
   
2. Second, colors are distributed in the rainbow+ order.
   Red,
   Orange,
   Yellow,
   Green,
   Cyan,
   Blue,
   Purple,
   Pink,
   White,
   Black.
   (So, Black and white are also avaible! Above 10, the list restart in the same order)
   
   
3. Third and final, the only thing you need to do is to create a new ROW for the events type in your calendar table.
   (ENUM / DROPDOWN : entries are your list in the right order, you can even coloring the list BUT the final color in calendar dont depend on the ENUM list colors, only the order)
   
   
   I hope to help someone. 🙂

[Fabian_Weller]

Hi @Bernard_Barbarisi and all others. Thank you for the Demo App.
This is changing the color in the AppSheet App.
But can we change also the color in google calendar via AppSheet?
Like we can when we add a new event in Google Calendar via Select event color.

For this we should upvote this feature request:

New attributes to be added to Calendar data source Feature Requests

@TyAlevizos @GreenFlux yes the color attribute would be awesome! from the docs colorId, string The color of the event. This is an ID referring to an entry in the event section of the colors definition (see the colors endpoint). Optional. writable I would like to be able to change the color in Google Calendar via AppSheet.