Skip to main content (Press Enter).
Sign in
Skip auxiliary navigation (Press Enter).
Support
Quickbase University
Skip main navigation (Press Enter).
Toggle navigation
Search Options
Home
Communities
All Posts
All Communities
My Communities
Getting Started
Events
Qrew Groups
Discussions
View Only
Community Home
Discussion
64.7K
Library
549
Blogs
177
Events
0
Members
46.7K
Back to discussions
Expand all
|
Collapse all
sort by most recent
sort by thread
Inconsistent Text Display (Formula driven)
KIRBY WILKERSON
01-29-2019 20:19
I am seeing inconsistent display of text color based on a field text selection in any report I use the ...
Evan Martinez
01-29-2019 21:04
Hi Kirby, One thing that can regularly throw off colorization formulas that are using matching text ...
QuickBaseCoach Dev./Training
01-29-2019 22:38
.. or if you suspect data is contaminated or inconsistent, you can also use IF(Trim([My field]) = ...
1.
Inconsistent Text Display (Formula driven)
1
Like
KIRBY WILKERSON
Posted 01-29-2019 20:19
Reply
Reply Privately
Options Dropdown
I am seeing inconsistent display of text color based on a field text selection in any report I use the fields in. For example: Budget Status field (text-mult choice) is "At Risk". A separate field Budget Status2 is a formula-Rich TExt field that changes the color based on selection - in this cse it should change to yellow. The formula correctly applies to many but not all entries in my report. Is this a known issue or have I taken a misstep in how I have compiled my reports or even in how I make changes in fields?
2.
RE: Inconsistent Text Display (Formula driven)
0
Like
Evan Martinez
Posted 01-29-2019 21:04
Reply
Reply Privately
Options Dropdown
Hi Kirby,
One thing that can regularly throw off colorization formulas that are using matching text can be when a formula calls the value and is missing or has extra spaces. What is open helpful to do is to check the multiple choice field to see if any of the entries have a leading or trailing space and if it does make sure that is also captured in the formula. So for example if it isn't colorizing "At Risk" it could be because the entry is actually "_At Risk" or "At Risk_" with that dash representing a space somewhere in there and since you are using an equal to Quick Base isn't considering them exactly the same even though just looking at it casually they appear to be equal. When working up a formula I have had that catch me a few times.
The other trick is to wrap the field tag in a Trim function that would cut off any extra spaces Trim([Budget Status])="At Risk
3.
RE: Inconsistent Text Display (Formula driven)
0
Like
QuickBaseCoach Dev./Training
Posted 01-29-2019 22:38
Reply
Reply Privately
Options Dropdown
.. or if you suspect data is contaminated or inconsistent, you can also use
IF(Trim([My field]) = "At Risk", "yellow")
The Trim will trim away and leading or training invisible characters like spaces.
×
New Best Answer
This thread already has a best answer. Would you like to mark this message as the new best answer?
Skip Navigation Links
Terms and Conditions
Copyright . All rights reserved.
Powered by Higher Logic