Discussions

Expand all | Collapse all

Calendar color coding formula help

  • 1.  Calendar color coding formula help

    Posted 04-27-2017 19:36
    When adding this formula to my calendar, it is adding an empty space above my text. It is coloring the data correctly, but the extra line is making it unusable.

    If([Project Owner]="Larry","<div style=background-color:#f6ff00;\">" &"<b>" &[Planned Project]&"",
    [Project Owner]="Sam","<div style=background-color:#03aff9;\">" &"<b>" &[Planned Project]&"",
    [Project Owner]="Joe","<div style=background-color:#f90404;\">" &"<b>" &[Planned Project])


    This is what it looks like when displaying:

    ">https://d2r1vs3d9006ap.cloudfront.net/s3_images/1588835/RackMultipart20170427-9371-15m85rm-Calendar_inline.jpg?1493321493">


    As you can see each entry has a blank one above it. This is what it looks like if I don't use my formula, and only put in the [Planned Project]. This doesn't have the excellent color coding, but the information is all on one row as it should be... Any help would be much appreciated!



  • 2.  RE: Calendar color coding formula help

    Silver
    Contributor
    Posted 04-27-2017 19:46
    Venturing a guess without experimenting, but I wonder if you close your <b> tags if that might help?


  • 3.  RE: Calendar color coding formula help

    Top
    Contributor
    Posted 04-27-2017 20:39
    also venturing a guess without time to test, but try adding some type of padding element to the div

    padding:7px;


  • 4.  RE: Calendar color coding formula help

    Posted 05-02-2017 20:02
    I tried both of those suggestions, it still doesn't seem to help. Now that I am thinking it through, I am wondering if it can't color since the events go across multiple dates??? Has anyone created a calendar that could color code different events across multiple days or weeks? For instance, if we wanted to say that the Mothers day banner will be on a website from 4-15 to 5-14, but we would have multiple other one day launches or specials color coded differently on single days. I thought my formula would handle that, but I'm not sure if the calendar functionality can display it the way I am needing it to.


  • 5.  RE: Calendar color coding formula help

    Top
    Contributor
    Posted 05-03-2017 05:40
    Native QB calendar is pretty rough,  Its too bad they haven't made a better solution.


  • 6.  RE: Calendar color coding formula help

    Posted 05-08-2017 19:25
    [SOLVED]!!!! After reading up on a few other questions, I replaced "div style" with "span style" in my formula, and it worked!!! It still won't allow coloring across multiple days, but it did remove the spaces and the extra line. 

    Thank you all for the help and suggestions.