category and color

Yes – in our example file we use color fields for the events. Those fields can be a calculation so that they can be based on anything – category, status, resource, etc.

The result of the calculation can be a color name (“red”, “blue”, etc.) or a web hex result (“#00FFCC”).

Let me know if that helps, or if I can answer any other questions.

Thank you for your answer.
In your example, a color is attributed to a “staff member” when you create a new event. This can be determined in the “preferences”.
I need to link a color with a “category” (which are for me “procedures”) without having to choose one in the scrolling menu.
How do I do that?

Thank you

You can change this field to a calculation and write something similar to:
Case (
Category = “category 1”; “red”;
Category = “category 2”; “green”;
“blue”
)

If you want to make it based on a table, the way we did with Staff, you’d probably want to create another table called “Category” and link it to the Event table by Category name. Then you can just change the color field to read:

Category::color

Let me know if that helps.