Change or Set Text field color based on Single Choice field value

126 views
Skip to first unread message

Randy Flinn

unread,
Jun 3, 2026, 5:43:58 PMJun 3
to mementodatabase
Ok, maybe making this too complicated, but now I would like to set or change the text color of a field “Item” based on the value of a Single Choice field “Status”.

“Status” can be “Complete”, “Incomplete”, “In-process” or “No-action” <default>.

For…

“Complete”, “Item” would be green
“Incomplete”, “Item” would be red
“In-process”, “Item” would be yellow
“No-action”, “Item” would be default text color (white)

Should I use a JavaScript or Trigger to accomplish?

Mmm

unread,
Jun 3, 2026, 10:28:48 PMJun 3
to mementodatabase
К сожалению, за это можно только проголосовать:
четверг, 4 июня 2026 г. в 00:43:58 UTC+3, rfli...@gmail.com:

Mmm

unread,
Jun 4, 2026, 12:05:18 PMJun 4
to mementodatabase
Временное решение с использованием дополнительного поля JS и невидимых пробелов от 1 до 3, в зависимости от значения статуса.
Невидимый пробел #1:


Шаблон с примером в каталоге шаблонов:
четверг, 4 июня 2026 г. в 05:28:48 UTC+3, Mmm:
color_text.jpg

Mmm

unread,
Jun 4, 2026, 12:06:53 PMJun 4
to mementodatabase
Источник невидимого пробела #1:
четверг, 4 июня 2026 г. в 19:05:18 UTC+3, Mmm:

Bill Gallagher

unread,
Jun 10, 2026, 1:34:52 PMJun 10
to Mmm, mementodatabase
By using single choice list drop down box, then choose your colors,  then in the main dbase values choose what choice will be your background,  I do this this way I also choose it to highlight my glucose if its to high or to low for my diabetes works great.

--
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/e4b7b511-c062-46db-9e00-c8db3a2f36edn%40googlegroups.com.
Reply all
Reply to author
Forward
0 new messages