I am attempting to use the "result of template’ under the Color format on my Calendar component, but having lots of issues.
It’s a relatively simple formula, but whenever I put in any logic all my events render in a gray that isn’t part of my formula. I’m guessing I have something wrong in the syntax, but can’t crack the issue.
Calendar rendering as gray, not following template despite both an R and D being present:
Any help is greatly appreciated - I’d really like to avoid having three duplicate models powering my calendar, but that is the only idea I can come up with if this feature doesn’t work out.
After a super cursory review of your question - I think the problem is that the Case function is looking for “=” and not “in” If your AWBC_Party__c field has more text in it than the “R” or the “D” then the match won’t get effected and it falls down to the default #FFFFFF. If you isolate the first letter of the string in your formula, or create a UI ONly field that extracts that first letter - the CASE matching should work.
Something like
CASE(
LEFT({{AWBC_Party__c}}, 1),
“D” …
Are you trying to put the formula in the “Color” template directly on the calendar component? I don’t think formulas will process there. Run your formula on a UI Only field on the model and then reference the value of that field in your calendar color template.
I’m not sure what you mean by ‘run your formula on a UI only field’. I attempted to add a UI Only field that uses my formula as a placeholder, then reference that, but it’s yielding the same results. I feel like I’m just not getting it in the right place:
The first attempt would not have worked. The placeholder property does not process formulas.
The second attempt should have worked.
I often put a placeholder table on my pages with all the model fields in them, just to make sure I’m actually getting the expected values. Does that happen?
Then can you post a picture of your calendar Event Configuration?
Thanks for the guidance - I added the table and it helped to troubleshoot where I did and did not need quotes to power the formula. I’m in business, and I know more about leveraging UI Only fields for formulas. Plus - I don’t have three models powering my calendar that I have to maintain!
