Solved

How to display different colors for field values in column in view?

Posted on 2008-06-25
7
267 Views
Last Modified: 2013-12-18
I have a number editable field which will contains 10 or 20 or 35 or 55 etc.
In my view under a column, i have the formula ->
Bgr := 255:255:255;
Chr := 255:0:0;
@If(projectCompP="10";Chr:Bgr;"")
but I do not see the color and the value display?

Please advise. Thank you.
0
Comment
Question by:kopibean
  • 4
  • 3
7 Comments
 
LVL 19

Expert Comment

by:madheeswar
Comment Utility
the code will be in a column and for the values to display u need to have another column.
Example:
First column:
red := 255:0:0;
apricot := 0:128:0;
@If(status="Open";red;apricot)
Second column:
Status
0
 
LVL 19

Expert Comment

by:madheeswar
Comment Utility

Rank: Sage
Is this what you were looking for?Yes No
madheeswar:
the code will be in a column and for the values to display u need to have another column.
Example:
First column: In the column properties, enable Use value as color
red := 255:0:0;
apricot := 0:128:0;
@If(status="Open";red;apricot)
Second column:
Status
0
 

Author Comment

by:kopibean
Comment Utility
Hi,

I have tried your solution. It works only for dkgreen:white?
Below is my formula:

red := 255:0:0;
dkgreen := 0:128:0;
dkblue := 0:0:128;
white := 255:255:255;
@If(projectCompP<="99%";dkgreen:white;projectCompP="0%";red:white;projectCompP="100%";dkblue:white;"")

Pls advise.
0
Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

 
LVL 19

Expert Comment

by:madheeswar
Comment Utility
Use this:
red := 255:0:0;
dkgreen := 0:128:0;
dkblue := 0:0:128;
white := 255:255:255;
apricot := 0:128:0;
@If(projectCompP<="99%";dkgreen:white;projectCompP="0%";red:white;projectCompP="100%";dkblue:white;apricot:white)
0
 

Author Comment

by:kopibean
Comment Utility
Hi,

I have tried your formula but it does not work.
If projectCompP=10% and the projectCompP=100%, they are the same colors.
Is it have something to do with this ->  projectCompP<="99%"?

Pls advise.
0
 
LVL 19

Accepted Solution

by:
madheeswar earned 50 total points
Comment Utility
in the first column, just give 255:0:0
and see if you get the colors.
And as per not working, it is to do with projectCompP field. make sure it has the data stored in numbers and not in %.
it won't understand %, only numbers you can do it for manupulation.
you do one thing: (if projectCompP is stored with %. and is a +ve)
res:=@If(@Length(projectCompP)=2;@Left(projectCompP;1);@Length(projectCompP)=3;@Left(projectCompP;2);@Left(projectCompP;3));
red := 255:0:0;
dkgreen := 0:128:0;
dkblue := 0:0:128;
white := 255:255:255;
apricot := 0:128:0;
@If(res<="99";dkgreen:white;res="0";red:white;res="100";dkblue:white;apricot:white)
0
 

Author Closing Comment

by:kopibean
Comment Utility
Thank you very much!
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

This article covers general Notes 8.5 troubleshooting information including recreating the Notes\Data folder.
Article by: Rob
Notes 8.5 Archiving Steps and Tips This article covers setting up a Notes archive, and helps understand some of the menu choices making setting up and maintaining a Notes archive file easier.
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now