What’s the formula format to color v2 calendar as “result of template”?
Looking for the ability to vary color based on owner ID
If({{OwnerId}}=xxxxxxxxxxxxxxx, #32a852, IF{{OwnerId}}=yyyyyyyyyyyyyyyyyyyy, #32a852, …
What’s the formula format to color v2 calendar as “result of template”?
Looking for the ability to vary color based on owner ID
If({{OwnerId}}=xxxxxxxxxxxxxxx, #32a852, IF{{OwnerId}}=yyyyyyyyyyyyyyyyyyyy, #32a852, …
Best answer by Rob_Hatch
The template can just call a UI only field on your calendar model. I’d recommend using a a Case Function in that UI Only formula field.
Read the docs about Case Function here.
https://docs.skuid.com/latest/en/skuid/formula-function.html#text-manipulation-and-analysisThe formula might look like this.
CASE(
{{OwnerId}},
"Id1", "Color1",
"Id2", "Color2",
"Color3")
The last value is the default value in case none of the user values are found.
The Color can be Hex, or an named html color value
WARNING: This solution will be fragile and will require you to edit the skuid page every time you have a new team member who needs a special color. I’d recommend adding a custom field to user object. (with a default value). This “User Color” field could be included in your skuid model for the calendar and would be used in that template.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.