Calendar View - Entry Color, can we change it?

Brandon M.

unread,

Mar 19, 2025, 4:27:15 PM3/19/25

to mementodatabase

Hello everyone,

I have returned with a different question this time. I am using the Android version of Memento Database and I am trying to use Calendar view for easy viewing and tracking of work orders on a specific date. However, all of the entries are colored red. I would like to change the color of the entry in the calendar based on conditions present in the entry. The placement on the calendar is based on separate fields named "Estimated Start Time" and "Estimated Duration".

For example, if "Work Order Start Time" is empty, the entry background in the calendar should be red.

If "Work Order Start Time" is not empty, but "Work Order End Time" is empty, it should be yellow.

If "Work Order Start Time" and "Work Order End Time" are not empty, the color should be green.

I've been digging through the docs as best as I can, and I haven't seem to found a way to do this. Changing the colorization of the field doesn't appear to do anything in the Calendar view.

Is this even possible in Memento? If it's not, then maybe I'll have to consider storing a symbol such as an emoji checkmark to the entry title to create a visual distinction between finished and unfinished work orders.

Best Regards,

Brandon

RG T

unread,

Mar 19, 2025, 7:00:24 PM3/19/25

to Brandon M., mementodatabase

Bonsoir

Une piste de solution :

Si vous avez une liste de choix unique dans vos champs alors le calendrier prendra la couleur paramétrée dans le champ.

TRG

--
You received this message because you are subscribed to the Google Groups "mementodatabase" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mementodataba...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/mementodatabase/4cf928bf-9968-4210-9d5d-d4767af72c8an%40googlegroups.com.

Mmm

unread,

Mar 19, 2025, 8:09:06 PM3/19/25

to mementodatabase

Вариант решения.

Скрытое поле JS "color" с выполнением в реальном времени:

let start = field("Work Order Start Time");

let end = field("Work Order End Time");

if (start && end) {

'green';

} else if (start) {

'yellow';

} else {

'red';

}

Настройка "цвет записи" – поле "color".

четверг, 20 марта 2025 г. в 02:00:24 UTC+3, trg...@gmail.com:

David Gilmore

unread,

Mar 20, 2025, 5:52:58 PM3/20/25

to mementodatabase

(This accidently got posted to a separate thread, Oops!)

The entry color of a calendar entry uses the library's "foreground" color parameter/setting. You can dynamically adjust that parameter in many ways. I generally use Javascript as described above.

Brandon M.

unread,

Mar 24, 2025, 9:10:46 AM3/24/25

to mementodatabase

Thank you everyone for your suggestions, I ended up going with a field on a hidden page and using a trigger script to check and adjust on an entry update. It's working exactly as intended and I can easily add more colors/conditions later on if the need arises.