0

Different colours in Calendar

Hi,

I have created a database that lists Composers their Compositions. Both contain date fields, that I have set to appear annually in the Calendar:

- Composer: birthdate and deceased date (calculated fields, based on records for a Composer in a table called Life Events)

- Composition: date of the first performance of a piece.

The attached images shows how this appears in the Calendar.Screenshot 2020-04-17 at 12.12.16

It would be nice to have different colours for each type of event in the calendar, e.g. green for "birth", black for "death" and blue for "premiere". Is there a setting that I can/should set to have this effect? 

Thanks,

Jacques.

6 replies

null
    • Terry_Prokopchuk
    • 4 yrs ago
    • Reported - view

    Hi Jacques, 

    Click on the date fields within editor, then select the colour you want to from the 'with color' option as show in the screen shot...Screenshot 2020-04-17 at 12.25.16

    • jacqueskinnaer
    • 4 yrs ago
    • Reported - view

    Hi Terry,

    Thank you. This at least sets apart the dates that come from the composition table. In the composers table, birth and death date are calculated fields based on the "life events" table. I can give the date in the life events table a colour, but would not be able to set a colour based on the type of life event.

    But at least, there is now a clearer distinction between premieres and other dates.

    • Nick
    • 4 yrs ago
    • Reported - view

    Hi Jacques,

    I assume that your events is a choice field with colors, like this...

    Screen Shot 2020-04-17 at 17.29.03

    ...then in "Show As" box...

    Screen Shot 2020-04-17 at 17.29.53

    ...enter your code like this...

    Screen Shot 2020-04-17 at 17.32.50

    ...and the result is

    Screen Shot 2020-04-17 at 17.33.47

     

    I hope it's clear!

    • Nick
    • 4 yrs ago
    • Reported - view

    (I hit the Post button too fast)

    You can do enything you want in the "Show As" calc.

    Example: 

    if event is "Birth" then styled(...

    else if event is "Death" then styled(...

    else styled(...

    • jacqueskinnaer
    • 4 yrs ago
    • Reported - view

    Hi Nick,

    Thank you. This looks awesome! I'll give it a go and let you know :-)

    Thanks,

     

    Jacques.

    • jacqueskinnaer
    • 4 yrs ago
    • Reported - view

    Great! That indeed does the trick :-) Wonderful

     

    Screenshot 2020-04-17 at 18.31.56

Content aside

  • 4 yrs agoLast active
  • 6Replies
  • 1199Views