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.
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.
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:
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!