Calendar block event colour

Hello,

Is it possible to assign colours to calendar block events based on something other than the start and end date? I realize that according to the help article this is not possible so I am looking to see if anyone has a work around other than embedding an airtable calendar? The use case is to visually identify the status of projects on the calendar. Airtable is my datasource and there are 3 project status options.

Thanks in advance!

Not sure I understand your question, but I believe you can specify the color for your event based on custom values entered in your table from airtable.

This is what my data looks like. I want to map the event colour to the airtable status field instead of having colour assigned by a single select field that I would have to go choose a colour for every different event. The status field already automatically has a colour assignment plan and I would like the event colour to be based off that rather than the event dates.
I suppose I could have an airtable automation to assign the colour to a single select field and change it as statuses are updated but I would really like to know if anyone has a more elegant solution.
Thanks!

formula field with a switch.

SWITCH({Status Field},
“Scheduled”,“Blue”,
“Complete”,“Green”,
“Requested”,“Yellow”,
“White”)

1 Like

Thanks @Sean_Wilson !

No worries, my formula has some syntax errors. The switch I used was:
SWITCH({Task Status},

“Complete”,“#45caff”,

“Confirmed”,“#1a8927”,

“Unconfirmed”,“#fdbc3a”,

“Planning”,“#d2481a”,

“In Progress”,“#7a39e8

)
And the formula field is called “Softr_Event_Colours”

1 Like