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.
@Aparicio_Pineyrua
In the Calendar UX there is a Category property where you can assign colors to your data with a Color type column
I see the Category, but I donโt see where I can select the colors
@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.
Ok, but how can I add a specific color for each status value?
@Aparicio_Pineyrua
For example:
SWITCH(
[Status],
"Completed", "Green",
"In-progress", "Orange",
"Blue"
)
Cool thanks!
Youโre welcome Apa.
Hi where exactly can you add that switch in AppSheet in order to color code the calendar entries?
Thanks.
@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.
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
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)
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โ
)
Or:
SWITCH(
[Status],
โContratadoโ, โGreenโ,
โEmailโ, โPurpleโ,
โLlamarโ, โYellowโ,
โReuniรณnโ, โRedโ,
โSin Interesโ, โBlackโ,
โBlueโ
)
Disregard my question about the color legend
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.
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
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.
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?
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.
My trick work in every case.
Look at my first message down below.
Got it! Thank you!
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.
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.
Hope this helps you.
Thank you @Bernard_Barbarisi, I notice the differences from the version 1, it works with the correct colors.
I want to look inside this app, but it is only for view
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).
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:
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |