rjvelarde Posted February 21, 2020 Report Share Posted February 21, 2020 I am running a calendar data page which shows different code for service types in a day. Would like the all elements of the service type background to be certain colors. I found this link in the forum but is not working. Quote Link to comment Share on other sites More sharing options...
Vitalikssssss Posted February 24, 2020 Report Share Posted February 24, 2020 Hi @rjvelarde, I think the easiest way to achieve is by using Formula field in the table with CASE expression. e.g. CASE WHEN [@YOUR_FIELD] = 'Follow up' THEN '<span style="color:#ffff00;">'+[@YOUR_FIELD]+'</span>' WHEN [@YOUR_FIELD] = 'Irrigation System' THEN '<span style="color:#0066ff;">'+[@YOUR_FIELD]+'</span>' WHEN [@YOUR_FIELD] = 'New Well' THEN '<span style="color:#009933;">'+[@YOUR_FIELD]+'</span>' ELSE 'Not defined' END Finally, you can render the content of the formula output as HTML if you enable the HTML option in Formatting field settings: Hope this helps. Regards, Vitalikssssss Quote Link to comment Share on other sites More sharing options...
rjvelarde Posted February 24, 2020 Author Report Share Posted February 24, 2020 Thanks. We appreciate it. Quote Link to comment Share on other sites More sharing options...
GoodBoy Posted September 11, 2022 Report Share Posted September 11, 2022 Hi! This article can also help if you want color coding per date in your Calendar. - https://howto.caspio.com/tech-tips-and-articles/advanced-customizations/color-coding-in-datapages/ Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.