Conditional coloring of individual field values isn’t possible, but a common workaround is to use colored emojis supplementing the text. For example:
Good
Warn
Poor
…or drop the text entirely…
I’ll let someone else address the chart issue, as I’m on the free account and don’t have access to blocks.
Conditional coloring of individual field values isn’t possible, but a common workaround is to use colored emojis supplementing the text. For example:
Good
Warn
Poor
…or drop the text entirely…
I’ll let someone else address the chart issue, as I’m on the free account and don’t have access to blocks.
Thanks that worked. I had issues with scaling items from a pic list, so I didn’t try this … the scale with the font size should someone else care later.
You can fake conditional formatting in Page Designer through the use of layers: To do so, you define a formula field for each possible status and then ‘stack’ them, with the color of each individual field configured appropriately. For instance, if your oactual] status field is called {Status}
, and it has the possible values of 'Good'
, 'Warn'
, and 'Poor'
, your first conditional status field would be {GoodStatus}
, with the formula IF({Status}='Good',{Status})
. Your other two conditional fields would be configured similarly.
Finally, {GoodStatus}
, {WarnStatus}
, and {PoorStatus}
would be set to the same dimensions and have the same X/Y origin — but {GoodStatus}
would have a green text color, while {WarnStatus}
's would be yellow and {PoorStatus}
's red. Since two of the three conditional status fields in a record would be empty, only the valid, color-coded status is visible. To display the status of multiple records, you’d concatenate all instances of each conditional status fields into a single field, using the newline character ('\n'
) as separator, and then layer the concatenated fields, colored appropriately. The process is both easier and more annoyingly time-consuming than it sounds — but with it one can do some pretty amazing things.
I’ve published several example bases demonstrating this technique. Probably the best introduction is item 5 from this reply; it includes a couple of sample Page Designer images, along with links to the bases used to generate them.
You can fake conditional formatting in Page Designer through the use of layers: To do so, you define a formula field for each possible status and then ‘stack’ them, with the color of each individual field configured appropriately. For instance, if your oactual] status field is called {Status}
, and it has the possible values of 'Good'
, 'Warn'
, and 'Poor'
, your first conditional status field would be {GoodStatus}
, with the formula IF({Status}='Good',{Status})
. Your other two conditional fields would be configured similarly.
Finally, {GoodStatus}
, {WarnStatus}
, and {PoorStatus}
would be set to the same dimensions and have the same X/Y origin — but {GoodStatus}
would have a green text color, while {WarnStatus}
's would be yellow and {PoorStatus}
's red. Since two of the three conditional status fields in a record would be empty, only the valid, color-coded status is visible. To display the status of multiple records, you’d concatenate all instances of each conditional status fields into a single field, using the newline character ('\n'
) as separator, and then layer the concatenated fields, colored appropriately. The process is both easier and more annoyingly time-consuming than it sounds — but with it one can do some pretty amazing things.
I’ve published several example bases demonstrating this technique. Probably the best introduction is item 5 from this reply; it includes a couple of sample Page Designer images, along with links to the bases used to generate them.
Thanks! I’ll keep this in mind as I chew on this … my team is just starting to dig in and see what we want to do.