I’m building a calendar app, using the Full Calendar plugin. For the event color, I don’t want it to be static, but rather tied to an event Category. I have an EventCategory table with Name and Color (text field with HEX code), and an CalendarEvent table with Category as a type of EventCategory. But I want to pull the Color from the attached EventCategory.
“Use a dynamic color for each event” only looks in the direct data’s source (not any connected fields), and only for Text entry. So can I create a Color field that when the data for the event is pulled, it formulaically fills in the Color field based on the corresponding Color field of the connected Category record?
So if I don’t choose dynamic color, it gives the option to pick the event’s category’s color. But it only changes their color from the default when they are clicked (which is contrary to how the choices are labeled).
The correct behavior I get is when I choose dynamic color and set the field to a text field (called Color), but is there a way to automatically update that Color field to match the Category’s color field? For example, if the Category of an event is changed, the color updates; or, if the Category’s color is changed, the event pulls the changed color.
Then in the Calendar’s inspector, set the Data source to Search for Diary and check ‘Use a dynamic color for each event’ and choose the Event name you just created, ie. color. Now the Calendar to ‘talking to’ your Database.
Now, when I create a Calendar event the colour is the ‘Role’s color’, or in my case I am setting it to the teamMember’s value’s Role color because I have a team member Datatype.